Apr-04-2021, 07:33 AM
(Apr-04-2021, 03:00 AM)vj78 Wrote: Code below does not workwhat does this exactly mean? Do you get any error? What version of MySQL do you use?
Did you check compatibility note:
Quote:Compatibility note: It appears that the mere act of executing the CALL statement produces an empty result set, which appears after any result sets which might be generated by the stored procedure. Thus, you will always need to use nextset() to advance result sets.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs