in reply to Re^2: Perl/MySQL table data copyin thread Perl/MySQL table data copy
SELECT 'test', `$db`.`$oldtable`.* FROM `$db`.`$oldtable` [download]
INSERT INTO `$db`.`$table` SELECT '', 'author', '', `$db`.`$oldtable`.* FROM `$db`.`$oldtable` [download]