my $sth = $dbh->prepare("insert into $table select * from $oldtable");

##</code><code>##

INSERT INTO `$db`.`$table` VALUES ( '', 'author', '', SELECT * FROM `$db`.`$oldtable` )