I Accidentally Deleted 7TB of Videos Before Going to Production

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by nso on Thursday May 05, 2022 @10:13AM (#31273605)

Mine was a DELETE FROM Users; WHERE... Fun was had.

[ Parent | on HN ]

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by codegeek on Thursday May 05, 2022 @10:23AM (#31273737)

Usually the recommendation is to not start writing the DELETE query first. Write the SELECT query first and see the results. If you miss the WHERE clause, you will see that immediately. Then change SELECT * to DELETE. But I assume you have learned that lesson already :)

[ Parent | on HN ]

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by Moru on Thursday May 05, 2022 @10:34AM (#31273873)

Yes, but it can't be stressed enough, always the first time for someone.

[ Parent | on HN ]