Pivot daily row to columns

SET @sql = NULL;
SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'max(case when tglentry = ''', tglentry,'''
      then status end) AS ',
      replace(tglentry,' ', '')
    )
  ) INTO @sql
from breakdown;

SET @sql = CONCAT('SELECT pt.tglentry,pt.nopol, ', @sql, ' from breakdown pt

group by pt.nopol');

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