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:

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.

Be Sociable, Share!

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>