Mysql pivot like functionality in code

Question

I am tackling a problem where I have to convert Table 1 to Table 2 using mysql

Table 2 structure is only define. How can I go about this? I have tried using union statement but am unable to convert Has on Monday to Monday as the column value

fthiella · Accepted Answer · 2015-11-17 19:20:12Z

2

You should write your query as this:

SELECT student, class, 'Monday' AS weekday
FROM table_1
WHERE has_on_monday='T'
UNION ALL
SELECT student, class, 'Tuesday' AS weekday
FROM table_1
WHERE has_on_tuesday='T'
UNION ALL
....

if you want to insert the result to table_2, use a INSERT query:

INSERT INTO table_2 (student, class, weekday)
SELECT ...the select query above...

answered Nov 17, 2015 at 19:20

fthiella

49.2k15 gold badges96 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql pivot like functionality in code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related