how to Create a new table from an another table with Copy its Values in mysql

We create the testTable1 table from the user table.

CREATE TABLE testTable1 AS (SELECT * FROM profile);

DISPLAY




DESCRIPTION


We create the testTable1 from the user table. All the records in the user table will be created in the testTable1. We use the describe to describe the table structure.