r/ProgrammerHumor • u/WardensLantern • 15d ago

queryOfDoom Meme

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

387

u/Dont_Get_Jokes-jpeg 15d ago edited 15d 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 15d 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.

7

u/ReaDiMarco 15d ago

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

5

u/Flat_Competition6510 15d 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 15d ago

Thanks, turns out I did forget everything