Merging two tables

[Mr Chris]

Hi All,

 

Say I have two identical tables:

 

articles_one

 

id

headline

text

 

articles_two

 

id

headline

text

 

And they each have 1,000 records in them with id being the primary key for each table.

 

Is there any way I can take articles_two and place all the records in articles_one despite them each having the same primary key id's?

 

Thanks

[fenway]

Nope... not unless you change the IDs.

[beebum]

Try this:

 

INSERT INTO articles_one (headline, text) SELECT headline, text FROM articles_two);

 

Keep in mind, this will give new IDs to the data from articles_two.