importing rows from another table in MySQL

After a quick way to import data from one table into another within MySQL?

I found this quick and dirty solution which solved a problem i thought would involve a bit more SQL than a single INSERT and SELECT.

INSERT INTO tableFoo.bar  
    SELECT * FROM tableFye.foe;

Probably one of the few cases where you should use SELECT * and not get laughed at by your friendly DBA