Posts by lucas gobira • 13 points
2 posts
-
1
votes1
answer28
viewsQ: Update the last record with WHERE MYSQL
I wanted to make UPDATE in the last record of the table, where the agent column is equal to "4827" I tried to use this way but error occurs: UPDATE login_agent SET data_hora_login_saida = 'DATA_FIM'…
-
0
votes1
answer30
viewsQ: Sum values from a column in the table where the date repeats, in a SUB-SELECT
Dates are different in your hours as this example: +---------------------+-------------------+-------+ | DATA | callid | tempo | +---------------------+-------------------+-------+ | 2021-08-01…