Select Code to Download

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

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