Quick Tip: Wrap Your SQL Queries In Transactions

I found this to be amazing so I thought I would share it.

If you're running a query that might cause data loss on the fly (maybe a delete or an update) you can wrap the query in a transaction to make sure you don't mess up data:

start transaction;
update table set thing=1 where 1=1;
-- Double check results here.

commit; 
-- or
rollback;

Learned via reddit