Posts by Michel VM • 31 points
2 posts
-
1
votes2
answers465
viewsA: UPDATE in Mysql based on the last date of a column
sorry for the delay in returning. Kurole, your reply helped me to find the solution to my problem, thank you. Follows solution below: UPDATE Cliente C SET C.status = 'Alerta' WHERE (SELECT…
-
2
votes2
answers465
viewsQ: UPDATE in Mysql based on the last date of a column
I am trying to update a table in Mysql (Client table status field) based on the last date that this client was visited (Schedule table gendering field), passing as parameter the number of days that…