php - Multiple line query in laravel
760
I am trying to execute multiple line query. I'm quite new to laravel. Here is my example query.
SET @sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'MAX(IF(`order` = ', `order`, ',data,NULL)) AS data', `order`)
) INTO @sql
FROM TableName;
SET @sql = CONCAT('SELECT ID, ', @sql, '
FROM TableName
GROUP BY ID');
PREPARE stmt FROM @sql;
EXECUTE stmt;
Answer
Solution:
I was trying to dynamically converts columns into row, that's why I was using multiple queries. But then I manually write single query since there were only 4 unique entries in my order table, so it become more simple. Thanks for help..