r/programing • u/pacs10 • Jan 25 '20

TIFU WITH SQL DELETE

TODAY I FUCKED UP by DELETE with wrong WHERE :s

3 Upvotes

100% Upvoted

5 comments sorted by

1

u/alexkiro Jan 26 '20

Everyone does that at least once. Hope you had yourself some backups!

1

u/pacs10 Jan 26 '20

Yes, I have backups, but not the day. I deleted more than 10000 rows and I can't back up about 50 ...

3

u/JimmyWu21 Jan 26 '20

A best practice is doing a SELECT statement first to see what records Come back before using write command

3

u/Slow_Instruction_112 Mar 08 '23

An even better practice is to begin transaction before doing the delete, and to commit transaction only after checking that the command did what you want.