News for hackers. Stuff that matters.

A comment on I Accidentally Deleted 7TB of Videos Before Going to Production. Parent comment

Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by password4321 on Thursday May 05, 2022 @07:36AM (#31272051) 

   SELECT COUNT(1) FROM table 
   -- UPDATE table SET col='val'
   WHERE 1=1
[ Parent | on HN ]
Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by worble on Thursday May 05, 2022 @07:37AM (#31272065) 

    BEGIN TRANSACTION 
    UPDATE table SET col='val' WHERE 1=1
    ROLLBACK
[ Parent | on HN ]
Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by password4321 on Thursday May 05, 2022 @09:00AM (#31272761)
Definitely better, when you can afford the overhead!
[ Parent | on HN ]
Re:I Accidentally Deleted 7TB of Videos Before Going to Prod... by tomrod on Thursday May 05, 2022 @08:11AM (#31272324)
Exactly!
[ Parent | on HN ]