3 ms·
begin; update example_table ... -- > 1 row changed commit; begin; update example_table ... -- > 1,000 rows changed rollback; I know it's n
by surprisetalk 4y ago
begin;
update example_table ...
-- > 1 row changed
commit;
begin;
update example_table ...
-- > 1,000 rows changed
rollback;
I know it's not exactly what you're asking, but you can use transactions to prevent "YOLO query" situations.