MySQL SELECT INTO Equivalent?

mysql, sql

Solution

See CREATE TABLE ... AS SELECT .... Note that this will not recreate indexes and foreign keys, as was already noted.

Problem

In SQL Server, I can copy tables or temporary tables to new table, using a `SELECT* INTO..` syntax. Someone know how can I make this same action in MySQL?

Original source