Posts by Luan Nascimento • 1 point
2 posts
-
0
votes1
answer30
viewsQ: JSON return in the desired format from SQL
I am trying to get the following return in Mysql: { matricula : '123', periodo : [ {id : '012016', titulo: 'Janeiro 2016'}, {id : '022016', titulo: 'Fevereiro 2016'}, {id : '032016', titulo: 'Março…
-
-5
votes1
answer77
viewsQ: How do select in Mysql to get this result
I have 3 tables, I would like the return of select comes with value 0 when it is not in the related table. Example of these tables the example shows the option data it contains in the poll table,…
mysqlasked Luan Nascimento 1