Feb 152010
Copy existing table schema to a new table
Answer:
To copy the table schema of an existing table to a new table, without copying its data:
mysql> CREATE TABLE new_table LIKE old_table;
Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.
Copy existing table schema to a new table
Answer:
To copy the table schema of an existing table to a new table, without copying its data:
mysql> CREATE TABLE new_table LIKE old_table;
