How to copy the structure of some fields from one table to another (MySQL)?

Question

MySQL

There are 2 tables, they have, respectively, different structures.
Foreign keys and indexes are missing.
The tables are empty.
How can I export part of the fields from one table to another?

Answer 1

stackoverflow.com/questions/1834472/copy-table-wit...

Try:

CREATE TABLE foo SELECT * FROM bar LIMIT 0
Or:

CREATE TABLE foo SELECT * FROM bar WHERE 1=0