Re: Calling sp from myPhpAdmin vs MySqlWorkbench

[Alex Mendy]

I am not too sure about using Delimiter. To be honest, I am a MS-SQL guy and never experienced these kind of discrepancies with MS-SQL. All I know, the following call returns data when executed from MySQL Workbench and returns nothing when executed from phpMyAdmin:
---------------------------------
call dbname.TestProcedure(null, null, null);
---------------------------------

Furthermore, I developed simple console app in C# that makes a call to the same proc and was able to fetch all result-sets correctly w/o specifying delimiters. To me this indicates that phpMyAdmin is a culprit. Hence, I will stick with MySql Workbench and avoid phpMyAdmin.

Thank you!