Merge Tables

[dirk mauroo]

Hoi,

What is the easiest way to merge tables in the same database ?

Thanks

Dirk

[Larry Woods]

This should do it:

INSERT INTO table1 SELECT * FROM table2;

This would add the records from table2 into (append) table1 ASSUMING the same schema for both tables.

Larry Woods

'dirk wrote:

Hoi,

What is the easiest way to merge tables in the same database ?

Thanks

Dirk

[ashwin]

Addition to Larry Woods SQL query, you need to consider these-

INSERT IGNORE INTO table1

SELECT * FROM table2;

which allows those rows in table1 to supersede those in table2 that have a matching primary key, while still inserting rows with new primary keys.

Refer MySQL docs: http://dev.mysql.com/doc/refman/5.5/en/insert-select.html

Alternatively,

REPLACE INTO table1

SELECT * FROM table2;

will update those rows already in table1 with the corresponding row from table2, while inserting rows with new primary keys.

Refer: http://dev.mysql.com/doc/refman/5.5/en/replace.html

[peterlaursen]

or “INSERT INTO .. ON DUPLICATE KEY …”. Point is that if you have Primary/unique Keys in the tables you will need to handle the conflict somehow.

[Author]

Posts