Last answered:

13 Apr 2021

Posted on:

13 Apr 2021

0

Resolved: out vs OUT in SQL Procedures

When typing the input and output parameters for a stored procedure, why is that when I type "out" (lower case), MYSQL doesn't ask to enter an output value to call the stored procedure but when I write the code with "OUT" (upper case), MYSQL also asks to enter the output value as well as the input values?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

13 Apr 2021

0

Hi Mohamed!

Thanks for reaching out.

This is indeed a bug relevant to the current version of the software that has been addressed but somehow yet unresolved by the creators of MySQL Workbench. To our knowledge, this is the only bug of this type.
Therefore, please write the letters as shown in the lectures for now. Let's hope that the MySQL creators will finally add the possibility of using capital letters for the IN and OUT keywords as well.

Hope this helps.
Best,
Martin

Submit an answer