2

I have a query like that

SELECT
GROUP_CONCAT(DISTINCT
CONCAT('MAX(IF(`TraineeID` = ', `TraineeID`, ',"P","A"))AS ID', `TraineeID`)
) INTO @sql
FROM tbl_attn_temp;
SET @sql = CONCAT('SELECT DATE_FORMAT(Date,"%d-%m-%Y")AS Date, ', @sql, ' 
FROM tbl_attn_temp
GROUP BY tbl_attn_temp.Date');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

When I execute this query in a mysql clinent software (Here i use HeidiSQL) it returns data as bellow enter image description here

But when I execute this query in phpmyadmin it returns empty data. Have a look here enter image description here

Now how can I solve this issue.

Nur Uddin
  • 2,778
  • 6
  • 16
  • 22

0 Answers0