copy the structure of one table to another in a mysql database 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