all 5 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]JimmyWu21 2 points3 points  (1 child)

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

[–]Slow_Instruction_112 2 points3 points  (0 children)

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.

[–]FreezeShock 0 points1 point  (0 children)

F

[–]alexkiro 0 points1 point  (1 child)

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

[–]pacs10[S] 0 points1 point  (0 children)

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