Monday, June 22, 2009

"select * into" in mysql

"select * into" is not allowed in mysql. Here is an example to get around this limitation:

CREATE TABLE newtable SELECT * FROM oldtable


originally found here

No comments: