DROP TABLE IF EXISTS `TestSequence`; CREATE TABLE `TestSequence` ( `num` VARCHAR(10) PRIMARY KEY ) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COLLATE = UTF8MB4_BIN; INSERT INTO `TestSequence`(`num`) VALUES ('0:ZERO'), ('1:ONE'), ('2:TWO'), ('3:THREE'), ('4:FOUR'), ('5:FIVE'), ('6:SIX'), ('7:SEVEN'), ('8:EIGHT'), ('9:NINE'); DROP PROCEDURE IF EXISTS `p_test`; DELIMITER // CREATE PROCEDURE `p_test`() BEGIN set @ss = (SELECT GROUP_CONCAT(TS.`num`) FROM `catdb_dev`.`TestSequence` `TS`); select @ss; END// DELIMITER ; call p_test(); call p_test();