Answers for "how to create table from other tables in mysql"

how to create a table structure from another table in mysql

CREATE TABLE new_tbl LIKE orig_tbl;  //(creates an empty table only definition is
                                        same.)

mysql create table from select statement

select * into <NEW_TABLE_NAME> from <OLD_TABLE>;