MySQL: how to change table view?

Question

MySQL

The situation is this. There is a table like

date       3 6 9 12 15 18 21 24     
2015.01.01      3 2 5 2 5 7 2 4
2015.01.02      9 3 1 3 4 6 4 1
2015.01.03      0 2 3 1 5 6 3 4

The table needs to look like this:

date            time              numbers
2015.01.01            03:00:00       3
2015.01.01            06:00:00       2
2015.01.01            09:00:00       5
2015.01.01            12:00:00       2
2015.01.01            15:00:00       5
2015.01.01            18:00:00       7
2015.01.01            21:00:00       2
2015.01.01            24:00:00       4
2015.01.02            03:00:00       9
2015.01.02            06:00:00       3

Answer 1

As an option
, I think, further by analogy, add yourself