Create table from existing

[Anon]

Hey still looking to see if anyone knows how to create a new table using the select statement to populate it with data from an existing table

thanks Rob

[Anon]

Actually, the syntax is SELECT INTO, but i dunno MySQL (if this is your system), supports this sentence.

Take a look here:

http://www.mysql.com/doc/A/N/ANSI_diff_SELECT_INTO_TABLE.html

fLIPIS