News for hackers. Stuff that matters.

A comment on SQL queries don't start with SELECT. Parent comment

Re:SQL queries don't start with SELECT by nimrody on Friday October 04, 2019 @07:25AM (#21156563)
Start all your sessions with "BEGIN TRANSACTION".

Then if you make an error you can always ROLLBACK. If it looks OK -- COMMIT.

[ Parent | on HN ]
Re:SQL queries don't start with SELECT by scarface74 on Friday October 04, 2019 @08:25AM (#21156898)
And then you use MySQL Workbench and forget to turn off autocommmit....
[ Parent | on HN ]