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.