Copy table with data

You can copy a table with data by using the CREATE TABLE statement with the SELECT statement.

Syntax :

mysql> create table new_table_name as select * from old_table_name;

Example :

create database