Posts by Altieri • 56 points
2 posts
-
2
votes2
answers287
viewsA: How to monitor database changes without making abusive queries
You can use Triggers. Trigger is a procedure that is invoked before or after a DML request (Insert, update or delete) happen. It is worth mentioning that the Trigger is always attached to a table.…
-
2
votes3
answers2936
viewsA: Check last record of an sql table
The clause WHERE will restrict the search to the number you put in ?. To query correct in that case would be: SELECT * FROM tabela ORDER BY id DESC LIMIT 1;…