select into in mysql

The Solution to select into in mysql is


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;

~ Answered on 2013-05-29 09:01:02


Most Viewed Questions: