I have a table called 'capital' in mysql. I am subtracting 10 from a field called 'pendingCapitalAvailable'. To accomplish this, I am considering using a called procedure that I will call from Matlab. I need to make sure the table is locked until I finish the procedure.
Below is the code I wrote to create the procedure, it does not work and tells me to look at the manual to figure it out. Can you tell me what is wrong with it?