SELECT COUNT(1) FROM table -- UPDATE table SET col='val' WHERE 1=1 | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		password4321 on May 5, 2022 \| parent \| context \| favorite \| on: I Accidentally Deleted 7TB of Videos Before Going ... `SELECT COUNT(1) FROM table -- UPDATE table SET col='val' WHERE 1=1`

worble on May 5, 2022 [–]

    BEGIN TRANSACTION 
    UPDATE table SET col='val' WHERE 1=1
    ROLLBACK

password4321 on May 5, 2022 | | [–]

Definitely better, when you can afford the overhead!

tomrod on May 5, 2022 | | [–]

Exactly!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact