mariadb

Create procedure CREATE PROCEDURE pivot (tablename VARCHAR(64), groupname VARCHAR(64), pivotname VARCHAR(64), valuename VARCHAR(64)) BEGIN SELECT CONCAT(‘CREATE VIEW to_columnslist AS\n’, ‘SELECT DISTINCT CONCAT(\’`\’, `’, pivotname,’`, \’` VARCHAR(255) path \\\’$.”\’, ‘, pivotname,’, \'”\\\’\’) line\n’, ‘FROM ‘, tablename) INTO @sql; PREPARE stmt FROM @sql; EXECUTE stmt; DROP PREPARE stmt; SELECT CONCAT( ‘SELECT to_json.`’, groupname,’`, parsed.*’, ‘\n’, ‘FROM (SELECT … Read more