Home » MySQL copy table to another database

MySQL copy table to another database

Published December 16, 2014 by Praveen Anaparthi

Syntax to copy one existent MySQL table from one database to another database:

  CREATE TABLE `new_database`.`table` SELECT * FROM `old_database`.`table`;

Syntax to copy one existent MySQL table to another table in the same database:

  CREATE TABLE `database`.`table` SELECT * FROM `database`.`table`;

That’s it.

Published in PHP / MySQL

0 0 votes

Article Rating