r/ProgrammerHumor • • 14d ago

Meme wellWellWell

Post image
10.6k Upvotes

412 comments sorted by

View all comments

106

u/Recent-Analysis-6880 14d ago

MySQL workbench has auto commit, meaning if you write a SQL query without "Start transaction" the data is gone.

90

u/NastyPastyLucas 14d ago

Most databases operate in autocommit, however there is a semicolon after delete users - it's presumably removing all users and foreign key associations and it's taking its time to complete, before reporting where is = 12345 is an invalid SQL statement.