MySQL copy data from one table to another table in SQL statement

This section is looking for a new job, today's interview, to do a set of questions, which encountered such a sentence, copy all the data from one table to another table of SQL?

Originally I rarely use, also did not pay attention to this problem, after interview I surf the internet to check, come back to write with my own hand, test under, indeed have. Now I'm recording.

This statement is: INSERT INTO A select * from B; This statement changes according to needs, the field must be consistent;

The other is MySQL copy table structure and data to a new table: CREATE table new Table SELECT * from old table; example SQL statement: CREATE TABLE new_table SELECT * from old_table

MySQL copy data from one table to another table in SQL statement