Append Help?

[Anon]

Hi All,

I have a table with data in it, and i would like to have a php script to append that
data from that table onto the end of another table - depending on ID.

At the moment i have it set up as "update", but that mucks up because sometimes ID's double up from one table to the other.

Ive had a bit of a hunt round for the syntax to append (not sure if this is
even the function i should be using) but havent had much luck.

Can anyone point me in the right direction?

Many Thanks

Dave

[Anon]

Depends a bit on what kind of database you have. Assuming MySQL (or any other ANSI SQL), you can use;

INSERT INTO newTable (field1, field2, field3) SELECT oldField1, oldField2, oldField3 FROM oldTable;

Or, if you use oracle, sybase or similar, you might want to look at SELECT INTO table (can't remember this by head).