How to clone a table in SQL !!

Couple of commands for cloning a table in MySQL

Already existing tables :

"Employee" table :

For creating table use command :

CREATE TABLE TEST LIKE EMPLOYEE;

For inserting the values use command :

INSERT INTO TEST SELECT * FROM EMPLOYEE ; 

RESULTANT TABLE :