in reply to Re^2: Perl/MySQL table data copy
in thread Perl/MySQL table data copy

you won't get the error if you preface the * with the table name (or alias). For instance:
SELECT 'test', `$db`.`$oldtable`.* FROM `$db`.`$oldtable`
works.

However, MySQL warns not to rely on column order when selecting data with select *

So you should be able to do:
INSERT INTO `$db`.`$table` SELECT '', 'author', '', `$db`.`$oldtable`.* FROM `$db`.`$oldtable`