Skip to content

Instantly share code, notes, and snippets.

@yfuruyama
Created May 20, 2014 09:02
Show Gist options
  • Save yfuruyama/44dbe5c784855105a6a5 to your computer and use it in GitHub Desktop.
Save yfuruyama/44dbe5c784855105a6a5 to your computer and use it in GitHub Desktop.
DELIMITER //
CREATE PROCEDURE grouping(IN _sql varchar(128), IN _col varchar(32))
BEGIN
SET @sql =
CONCAT(
CONCAT(
CONCAT(
CONCAT(
'SELECT @in := GROUP_CONCAT(t.',
_col
),
' SEPARATOR \',\') FROM ('
),
_sql
),
') as t;'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
END;
//
DELIMITER ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment