We will use the following commands to copy one table in a database to other database
CREATE TABLE new_table_name LIKE old_table_name;
then you populate it with the data from the old table with:
INSERT INTO new_table_name SELECT * FROM old_table_name;
CREATE TABLE new_table_name LIKE old_table_name;
then you populate it with the data from the old table with:
INSERT INTO new_table_name SELECT * FROM old_table_name;
Comments