MySQL SELECT INTO Equivalent?

I开发者_运维技巧n 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?

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