http://stackoverflow.com/questions/16809393/select-into-in-mysql
Use the CREATE TABLE SELECT syntax.
http://dev.mysql.com/doc/refman/5.0/en/create-table-select.html
CREATE TABLE new_tbl SELECT * FROM orig_tbl;
原文:http://www.cnblogs.com/chucklu/p/6393755.html