insert MySQL table data into a new table of a new database

[idorjee]

Hi,
Is there any way I could insert the data from my current database table to a new table in a new database easily without the need to insert them one-by-one?
I'd appreciate it.

[bartonc]

Hi,
Is there any way I could insert the data from my current database table to a new table in a new database easily without the need to insert them one-by-one?
I'd appreciate it.

To copy a table for the current (default) database:

DROP DATABASE IF EXISTS dbName;
CREATE DATABASE dbName;
CREATE TABLE dbName.tableName LIKE tableName;
INSERT INTO dbName.tableName SELECT * FROM tableName;

[mwasif]

To copy a table for the current (default) database:

DROP DATABASE IF EXISTS dbName;
CREATE DATABASE dbName;
CREATE TABLE dbName.tableName LIKE tableName;
INSERT INTO dbName.tableName SELECT * FROM tableName;

These commands will DROP the database dbName and create a empty database with the same name. If you already have the database, then you don't need to execute these commands.

DROP DATABASE IF EXISTS dbName;
CREATE DATABASE dbName;
 

The following command will select the data from old database and insert into the new one.

INSERT INTO dbName.tableName SELECT * FROM tableName;
 

If you have not created the destination (new database), then simply use bartonc's commands.

[idorjee]

thanks so much for both of you.