MySQL Forums
Forum List  »  Newbie

SELECT INTO
Posted by: Laurens Ham
Date: June 09, 2011 11:43AM

Hi All,

I have a huge SELECT INTO table (FIELDS) SELECT query.

The thing is, it copy's like 3000 rows at a time to another table.
I need those rows deleted from the table where it has been taken from.

I am sure some people know a convenient solution for this.

Thanks in advance,
Cheers

Options: ReplyQuote


Subject
Written By
Posted
SELECT INTO
June 09, 2011 11:43AM
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.