How to create table same as another table?

Question: How to create table same as another table?(same structure)

Answer:Consider you are having a table named mysql_interview .

To make a same structured table use the following statment

$> CREATE TABLE your_new_tablename like mysql_interview