>I want to create two similar tables in MySQL.
>
>is it possible to copy from one table to another, instead of create the table manually?
>
>thanks

If you just want to create an empty table structure:

CREATE TABLE new_table LIKE original_table;

If you want to capture table data, you may create the table, as above, and then

INSERT INTO new_table SELECT * FROM original_table;

or execute it in one go (but not all table definitions are recreated this way):

CREATE TABLE new_table SELECT * FROM original_table;