Hi Priyan/Selena,
Try this one,may be this could help u to solve your
GROUP_CONCAT() Issue,
Quote:
DROP PROCEDURE IF EXISTS sp_test_groupconcat;
CREATE PROCEDURE sp_test_groupconcat()
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT 'Just to Check the GROUP_CONCAT() Issue'
sp_test_groupconcat:
BEGIN
DECLARE vQuery TEXT;
DECLARE vQuery1 TEXT;
DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK;END;
SET vQuery:= 'SELECT CAST(GROUP_CONCAT(table_id)AS BINARY) INTO @vId FROM table1';
SET @vQuery := vQuery;
-- SELECT @vQuery;
PREPARE vSqlQuery FROM @vQuery;
EXECUTE vSqlQuery;
-- DEALLOCATE PREPARE vSqlQuery;
SET vQuery1:= CONCAT('SELECT * FROM table2 WHERE table1_id IN (',@vId ,')');
SET @vQuery1 := vQuery1;
SELECT @vQuery1;
PREPARE vSqlQuery1 FROM @vQuery1;
EXECUTE vSqlQuery1;
DEALLOCATE PREPARE vSqlQuery1;
END sp_test_groupconcat;
CALL sp_test_groupconcat();
|