copy structure of table in mysql code example
Example: clone table structure mysql
CREATE TABLE foo SELECT * FROM bar LIMIT 0
Or
CREATE TABLE foo SELECT * FROM bar WHERE 1=0
CREATE TABLE foo SELECT * FROM bar LIMIT 0
Or
CREATE TABLE foo SELECT * FROM bar WHERE 1=0