Sometimes you think to yourself: duh

Copy a table from 1 database to another was always something I did by exporting the table+data and importing it. Or I used the phpmyadmin tool for it.
Like today, but somehow my eye fell on the SQL syntax phpmyadmin used:

INSERT INTO newdb.newtable
SELECT *
FROM olddb.oldtable;

DUH!

Ofcourse this only works if you have copied the structure of the table already.