i'm trying to append data from one table to another.
Imagine two tables. table A has no id, table B does. Table B has 10 entries in it. Table A has 20 entries.
i'd like to add the data in table A to table B, and for the entries in table A to start incrementing at 11, 12 13 (where table B leaves off in it's unique ids)
the syntax would probably look something like...INSERT INTO tableB id=11, (auto_increment) SELECT * FROM tableA..but i'm not sure..
can someone help? thank you.