Merging Two Tables

[w2k]

I have two tables (with identical structure) which I want to combine/merge. How should I do it?

Actually these are two blogs of mine which I plan to merge. Only the itemid column needs to change.

[peterlaursen]

The SQL 'UNION' clause is for this.

Code:

CREATE TABLE new_table SELECT * from old_table1 UNION SELECT * from old_table2;

Note that if you have an autoincrement PK in old_tables the new table will not have a PK. You must then add it using ALTER TABLE. If there are dublicates you may need to drop the PK-column and recreate it.

[w2k]

Thanks Peter, I realised about the PK bit just as your postscript came in. It works like a breeze. Thanks a ton.

[Author]

Posts