dynamic mysql pivot table

Asked Apr 22 '19 at 02:54

Active Apr 22 '19 at 03:43

Viewed 39 times

I have a table that looks like this:

----------------------------------------------------
| rlcode       | rldate     | rltimein  | rltimeout |
-----------------------------------------------------
| 369.18.01633 | 2019-01-02 | 16:47:13  | 08:30:41  |          
| 369.18.01633 | 2019-01-03 | 08:31:49  | 17:03:59  |          
| 369.18.01633 | 2019-01-04 | 08:23:16  | 16:42:07  |  
-----------------------------------------------------

How can I make a view like this with dynamic pivot table?

 -----------------------------------------------------------
| rlcode       | 2019-01-02     | 2019-01-03  | 2019-01-04 |
------------------------------------------------------------
| 369.18.01633 | Present        | Present     | Present    | 
-------------------------------------------------------------

edited Apr 22 '19 at 03:43

Kiran Desai

1,463
2
15
33

asked Apr 22 '19 at 02:54

Agis R Herdiana

Does rltimeout have any relevance to the result? It doesn't seem to. – P.Salmon Apr 22 '19 at 06:45
right.. for present values, taken from timein which is not null – Agis R Herdiana Apr 22 '19 at 06:59
Google mysql pivot - here's an example https://stackoverflow.com/questions/12598120/mysql-pivot-table-query-with-dynamic-columns – P.Salmon Apr 22 '19 at 07:07
thank you for the example given, but for this case I need the date range specified – Agis R Herdiana Apr 22 '19 at 07:27

dynamic mysql pivot table

0 Answers0