How to append tables in Mysql

For those of you that have puzzled over how to append tables in Mysql like an Access ‘Append’ query, start here:

1
insert into table1 select * from table2;<br />
insert into table1 select * from table2;<br />

Where table1 and table2 are identical. This might fail if you use an auto-incrementing counter on both.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.