Re: Calling sp from myPhpAdmin vs MySqlWorkbench
Posted by:
Alex Mendy
Date: December 20, 2014 07:30PM
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;
----------------------------------
Subject
Views
Written By
Posted
2662
December 19, 2014 01:10PM
1241
December 19, 2014 03:03PM
1107
December 19, 2014 08:24PM
1237
December 19, 2014 08:34PM
Re: Calling sp from myPhpAdmin vs MySqlWorkbench
1194
December 20, 2014 07:30PM
1265
December 22, 2014 03:52AM
1492
December 22, 2014 06:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.