17

Never again...:

DELETE FROM objects WHERE id - #####;

😳...fml

Comments
  • 2
    I see your having a fun day.
  • 3
    Truncate objects; is easier to type, just fyi.
  • 7
    Whenever I have to delete or update data in a database, I always write a select first to see how many rows would I affect to, then reuse the where clause and write the rest.
    It requires more work, but reduces my level of stress when someone asks to change data in production.
  • 0
    @Root and if I remember correctly, cannot be undone
  • 0
    @dozingncoding Normally I do the same, got complacent here 😒
Add Comment