phdphd Posted August 19, 2013 Share Posted August 19, 2013 Hi All, I do not understand why the following stored procedure does not work. DELIMITER $$ DROP PROCEDURE IF EXISTS `proc` $$ CREATE PROCEDURE `proc` ( ) BEGIN DECLARE result LONGTEXT; SET SESSION group_concat_max_len =4294967295; SET result = (SELECT GROUP_CONCAT( DISTINCT ids ORDER BY ids ASC SEPARATOR ',' ) FROM table1); INSERT INTO `table2 ` (`id`, `concat`) VALUES (NULL, result); END $$ DELIMITER ; When I run it, I get no error, but the insert instruction seems ignored. This insert instruction bears a variable, but even though I use a hard-coded value in it instead of the "result" variable, it still gets ignored (whereas it would work if executed alone). Please note that when executed alone the SELECT GROUP_CONCAT instruction DOES return a concatenation. Thanks for your help! Link to comment https://forums.phpfreaks.com/topic/281363-my-stored-procedure-returns-no-error-but-actually-does-no-work/ Share on other sites More sharing options...
phdphd Posted August 19, 2013 Author Share Posted August 19, 2013 Shame on me ! It does work ! Just forgot to test il with CALL... Link to comment https://forums.phpfreaks.com/topic/281363-my-stored-procedure-returns-no-error-but-actually-does-no-work/#findComment-1445852 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.