Re: mysql error 1064
Posted by:
Rick James
Date: November 08, 2013 12:24PM
First, I recommend getting rid of the cursor. It seems like this would do the task in a single pass:
UPDATE arl
JOIN tbl AS t ON t.xformno = arl.xformno
SET xtroll = xtroll + 1;
If so, then work on substituting "tbl", and calling prepare, execute, and deallocate.
Subject
Views
Written By
Posted
31980
November 07, 2013 06:07AM
Re: mysql error 1064
2090
November 08, 2013 12:24PM
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.