MySQL Forums
Forum List  »  Full-Text Search

For cur_var in (Select * from xyz where ..) loop
Posted by: Amit Mangalwedhe
Date: July 03, 2008 05:52AM

like in oracle cursors

For cur_var in (Select * from xyz where ..) loop
insert into pqr values (cur_var.col1,cur_var.col2)
end loop

how to implement this in mysql?

Options: ReplyQuote


Subject
Views
Written By
Posted
For cur_var in (Select * from xyz where ..) loop
6370
July 03, 2008 05:52AM


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.