Re: Calling sp from myPhpAdmin vs MySqlWorkbench

[Alex Mendy]

Peter, the version of phpMyAdmin I am using is 4.2.7deb0.1
I've created this stored procedure. If I execute it in MySqlWorkbench and pass NULL for all params, I get results back. The same returns nothing in phpMyAdmin. This is quite frustrating.

----------------------------------
CREATE DEFINER=`root`@`localhost` PROCEDURE `TestProcedure`(IN `Param1` INT, IN `Param2` DECIMAL, IN `Param3` FLOAT)
BEGIN
SELECT 'A' AS Test1;
SELECT 'B' AS Test2;
SELECT 'C' AS Test3;
END;
----------------------------------