I am a MSSQL user and now I am converting my database to MySQL I am writing the following query in MySQL select into new tbl from tbl And I get the following error Error Undeclared variable new tbl How such a query should be properly written in MySQL

select into in mysql

Use the CREATE TABLE SELECT syntax.

CREATE TABLE new_tbl SELECT * FROM orig_tbl;

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