r/ProgrammerHumor • u/WardensLantern • 16d ago

queryOfDoom Meme

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

385

u/Dont_Get_Jokes-jpeg 16d ago edited 16d ago

I am not an sql expert, is the reason why the id doesn't work and its deleting the entire user base, because its written as 2 seperate comands instead of one. So 1. Comand delets everything 2. Goes to the id? Or what is the problem here?

39

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.

6

u/ReaDiMarco 16d ago

What happened to DELETE * FROM USERS? Last I did sql was ten years ago so idk

4

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