Merging databases

[Ike]

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA, but
with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

Thanks, Ike

[Colin McKinnon]

Ike spilled the following:

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA,
but with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

This kinda suggests that you didn't normalize your database.

To answer your question....

1) do you need to ....
(
SELECT 'A' AS Branch, BranchA.* FROM BranchA WHERE $criteria
) UNION (
SELECT 'B' AS Branch, BranchB.* FROM BranchB WHERE $creiteria
)
2) if you really have to then...
DELETE FROM BranchToT;
INSERT INTO BranchToT SELECT * FROM BranchA WHERE $criteria
REPLACE INTO BranchToT SELECT * FROM BranchB WHERE $criteria
I'll leave you to work out why the third statement in the above might work
better with a REPLACE instead of an INSERT.

C.

[Colin McKinnon]

Ike spilled the following:

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA,
but with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

This kinda suggests that you didn't normalize your database.

To answer your question....

1) do you need to ....
(
SELECT 'A' AS Branch, BranchA.* FROM BranchA WHERE $criteria
) UNION (
SELECT 'B' AS Branch, BranchB.* FROM BranchB WHERE $creiteria
)
2) if you really have to then...
DELETE FROM BranchToT;
INSERT INTO BranchToT SELECT * FROM BranchA WHERE $criteria
REPLACE INTO BranchToT SELECT * FROM BranchB WHERE $criteria
I'll leave you to work out why the third statement in the above might work
better with a REPLACE instead of an INSERT.

C.

[Colin McKinnon]

Ike spilled the following:

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA,
but with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

This kinda suggests that you didn't normalize your database.

To answer your question....

1) do you need to ....
(
SELECT 'A' AS Branch, BranchA.* FROM BranchA WHERE $criteria
) UNION (
SELECT 'B' AS Branch, BranchB.* FROM BranchB WHERE $creiteria
)
2) if you really have to then...
DELETE FROM BranchToT;
INSERT INTO BranchToT SELECT * FROM BranchA WHERE $criteria
REPLACE INTO BranchToT SELECT * FROM BranchB WHERE $criteria
I'll leave you to work out why the third statement in the above might work
better with a REPLACE instead of an INSERT.

C.

[Mike Chirico]

"Ike" <rx*@hotmail.co m> wrote in message
news:LZ******** ********@newsre ad2.news.pas.ea rthlink.net...

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA, but with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

Yes, several tables can be merged into a summary table, and you can still
keep
BranchA, and BranchB...

See below or reference (TIP 8) at the following url:
http://osdn.dl.sourceforge.net/sourc...ADME_mysql.txt

CREATE TABLE BranchA (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MyISAM;

CREATE TABLE BranchB (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MyISAM;

CREATE TABLE BranchSUMMARY_s ummary (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MERGE UNION(log_01,lo g_02) INSERT_METHOD=L AST;
insert into BranchA (a,b) values (1,'log1');
insert into BranchB (a,b) values (1,'log2');

To get combined results

select * from BranchSUMMARY;
Hope this helps.

Regards,

Mike Chirico

[Mike Chirico]

"Ike" <rx*@hotmail.co m> wrote in message
news:LZ******** ********@newsre ad2.news.pas.ea rthlink.net...

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA, but with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

Yes, several tables can be merged into a summary table, and you can still
keep
BranchA, and BranchB...

See below or reference (TIP 8) at the following url:
http://osdn.dl.sourceforge.net/sourc...ADME_mysql.txt

CREATE TABLE BranchA (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MyISAM;

CREATE TABLE BranchB (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MyISAM;

CREATE TABLE BranchSUMMARY_s ummary (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MERGE UNION(log_01,lo g_02) INSERT_METHOD=L AST;
insert into BranchA (a,b) values (1,'log1');
insert into BranchB (a,b) values (1,'log2');

To get combined results

select * from BranchSUMMARY;
Hope this helps.

Regards,

Mike Chirico

[Mike Chirico]

"Ike" <rx*@hotmail.co m> wrote in message
news:LZ******** ********@newsre ad2.news.pas.ea rthlink.net...

Suppose I have a relational database, called "BranchA."

I have a second relational database, of identical structure to BranchA, but with different data, and this one is called BranchB.

Can I merge the two, into, say, a BranchC somehow on occassion?

Yes, several tables can be merged into a summary table, and you can still
keep
BranchA, and BranchB...

See below or reference (TIP 8) at the following url:
http://osdn.dl.sourceforge.net/sourc...ADME_mysql.txt

CREATE TABLE BranchA (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MyISAM;

CREATE TABLE BranchB (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MyISAM;

CREATE TABLE BranchSUMMARY_s ummary (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MERGE UNION(log_01,lo g_02) INSERT_METHOD=L AST;
insert into BranchA (a,b) values (1,'log1');
insert into BranchB (a,b) values (1,'log2');

To get combined results

select * from BranchSUMMARY;
Hope this helps.

Regards,

Mike Chirico

[Mike Chirico]

> CREATE TABLE BranchSUMMARY_s ummary (

That's BranchSUMMARY without "_summary" which was a typo on my part.

CREATE TABLE BranchSUMMARY (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MERGE UNION(log_01,lo g_02) INSERT_METHOD=L AST;

Regards,

Mike Chirico

[Mike Chirico]

> CREATE TABLE BranchSUMMARY_s ummary (

That's BranchSUMMARY without "_summary" which was a typo on my part.

CREATE TABLE BranchSUMMARY (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MERGE UNION(log_01,lo g_02) INSERT_METHOD=L AST;

Regards,

Mike Chirico

[Mike Chirico]

> CREATE TABLE BranchSUMMARY_s ummary (

That's BranchSUMMARY without "_summary" which was a typo on my part.

CREATE TABLE BranchSUMMARY (
pkey int(11) NOT NULL auto_increment,
a int,
b varchar(12),
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) type=MERGE UNION(log_01,lo g_02) INSERT_METHOD=L AST;

Regards,

Mike Chirico