MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure doesn't work
Posted by: Rick James
Date: June 17, 2013 10:45PM

It would be a lot less typing, if you simply did

INSERT INTO ... SELECT ...

with the necessary expressions in the SELECT.

You would probably need to move the procedure argument into @variables.

Also, the single INSERT..SELECT would run a lot faster than the CURSOR.

Options: ReplyQuote


Subject
Views
Written By
Posted
3150
June 11, 2013 09:21AM
1059
June 11, 2013 12:34PM
968
June 12, 2013 08:28AM
Re: Procedure doesn't work
975
June 17, 2013 10:45PM
936
June 18, 2013 02:31AM


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.