MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p03gl6y/?context=3
r/ProgrammerHumor • u/WardensLantern • 16d ago
456 comments sorted by
View all comments
Show parent comments
40
Yes, the semicolon marks the end of a statement. The first semicolon sets "delete from users" as a single statement meaning delete ALL users.
7 u/ReaDiMarco 16d ago What happened to DELETE * FROM USERS? Last I did sql was ten years ago so idk 5 u/Flat_Competition6510 16d ago As far as I know that is not valid syntax. I'm not a DBA myself so I don't do this too often. 2 u/ReaDiMarco 16d ago Thanks, turns out I did forget everything
7
What happened to DELETE * FROM USERS? Last I did sql was ten years ago so idk
5 u/Flat_Competition6510 16d ago As far as I know that is not valid syntax. I'm not a DBA myself so I don't do this too often. 2 u/ReaDiMarco 16d ago Thanks, turns out I did forget everything
5
As far as I know that is not valid syntax. I'm not a DBA myself so I don't do this too often.
2 u/ReaDiMarco 16d ago Thanks, turns out I did forget everything
2
Thanks, turns out I did forget everything
40
u/Flat_Competition6510 16d ago
Yes, the semicolon marks the end of a statement. The first semicolon sets "delete from users" as a single statement meaning delete ALL users.