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