New to Mysql;
I have created a stored procedure. Using a cursor I traverse the first table.
For each row in the cursor I need to determine the correct row in another table to update.
Using a select statement with data from the cursor I identify the primary key to this the target table and update it. I extract row counts from the target table as I go to check that the correct number of rows are being updated (i.e. 1 each time)....

you can use the following:

select greatest(100,67 ,876,76,234,100 98) from dual;

can be used in any sql statement , just list the relevant comments inside the greatest () function