Posts by Mauro Piro • 41 points
3 posts
-
0
votes2
answers130
viewsA: How do I Group Text in Mysql
My good friend Alan answered this question, as he has no account, I answered the question: SELECT hora, MAX(CASE WHEN data = curdate() THEN tarefa ELSE NULL END) as campo_1, MAX(CASE WHEN data =…
-
3
votes1
answer36
viewsQ: How do I use today’s date as column title in Mysql
I have the following table: Whereas today is 02/01/2019, while doing the pivot table below: SELECT hora, CASE WHEN data = CURDATE() THEN tarefa ELSE NULL END AS campo_1 FROM tabela WHERE data…
-
0
votes2
answers130
viewsQ: How do I Group Text in Mysql
I’ve tried to find a solution to this case, and I need your help. I have the following table: hora data tarefa 10:00 02/01/19 A 10:00 03/01/19 B 11:00 02/01/19 C Whereas today is 02/01/2019, while…