Posts: 1
Registered: ‎01-13-2020

Returning multiple values from stored procedure!!!

I have to write for my homework. We are currently working on the sakila database to get familiar with MySQL functions and procedures. Now I have to write a stored procedure that updates the last_update row of the film table to the current timestamp and returns a resultset containing both the old and new values of film.last_update. I managed to get it somewhat done by returning two distinct select statements from the procedure, but how can I get the select from before the update and after the update in a single resultset to display? Thanks for your help