Hi all,
Not sure if this question is one I should be asking here, if not, I am sorry.
I am using mySQL (5.0.37) an am using a stored function to implement Oracle like sequence numbers.
I am having a little issue with the update.
So I was wondering if the use of BEGIN creates a lock on the table at the start of the stored function, so that while the function is executing no other function can update the sequence table.
I think this might be wishful thinking because it dosnt know what table I am trying to work with until it encounters the update
I will continue searching mySQL and if I find any answers will post them back here for the record.
thanks
G