clone table structure mysql
snippet in sql

clone table structure mysql

user3722

CREATE TABLE foo SELECT * FROM bar LIMIT 0

Or
CREATE TABLE foo SELECT * FROM bar WHERE 1=0