MySQL Forums
Forum List  »  Newbie

Re: SELECT INTO
Posted by: Peter Brawley
Date: June 09, 2011 01:55PM

MySQL does not support SELECT INTO tablename. Perhaps your query does SELECT INTO OUTFILE...? That wouldn't be a convenient way to start building another table. To create a table from a SELECT in MySQL, write ...

DROP TABLE IF EXISTS tablename;
CREATE tablename SELECT ...

Then to delete those rows, turn the SELECT statement into a DELETE statement.

PB

Options: ReplyQuote


Subject
Written By
Posted
June 09, 2011 11:43AM
Re: SELECT INTO
June 09, 2011 01:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.