MySQL Forums
Forum List  »  Stored Procedures

Re: Display all the records from table using cursor
Posted by: kaji Pasa
Date: September 22, 2017 10:11PM

I need to update the table A column A.a based on the value of a particular column from another table B column B.a .So i am trying to fetch all the rows from A (but now i am getting only first row), check if the value of the column A.a falls in the condition to update or not. If the column value needs to be updated, the update that column else move to next row.

For this requirement i am trying to create the cursor.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Display all the records from table using cursor
859
September 22, 2017 10:11PM


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.