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?

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

Follow this topic

Mohamed Aymaan Zahir

Last answered:

13 Apr 2021

Posted on:

13 Apr 2021

Resolved: out vs OUT in SQL Procedures

in SQL / Welcome to SQL

1 answers ( 1 marked as helpful)

Martin Ganchev

Instructor

Posted on:

13 Apr 2021

Helpful answer

Resolved: out vs OUT in SQL Procedures

Submit an answer

related questions