MySQL pivot tables - rows to colums

Question

This Query

SELECT
    Student.StudentID,
    student.`Name`,
    attendance.Date,
    CASE
WHEN attendance.StudentID IS NOT NULL THEN
    'Present'
ELSE
    'Absent'
END AS Attendance_Status
FROM
    student
LEFT JOIN attendance ON student.StudentID = attendance.StudentID

give me this result

How can I get a result similar to this

@Sean I am building a web application so I will be doing this in PHP — Ali Shaikh, Apr 02 '15 at 20:49

score -1 · Accepted Answer · answered Apr 07 '15 at 14:43

Solved by this answer

SELECT student.StudentID, student.Name,

IF ( ( SELECT DISTINCT 1 FROM attendance WHERE attendance.StudentID = student.StudentID AND date = '2015-09-07' ) = 1, 'Present', 'Absent' ) AS 2015-09-07,

IF ( ( SELECT DISTINCT 1 FROM attendance WHERE attendance.StudentID = student.StudentID AND date = '2015-09-14' ) = 1, 'Present', 'Absent' ) AS 2015-09-14,

student.WorkshopID FROM student

by @Hitesh Mundra

I'm sorry but there's no way this is the answer with what you've put in the request above. — Dresden, Jun 03 '16 at 00:45

MySQL pivot tables - rows to colums

1 Answers1