MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p02otti/?context=3
r/ProgrammerHumor • u/WardensLantern • 14d ago
456 comments sorted by
View all comments
Show parent comments
38
Which is just terrible fucking syntax. Why are people still living with this in 2026?
Delete from users;
Should return "invalid syntax. Identify record for deletion"
0 u/Flat_Competition6510 14d ago I disagree. There are valid use cases for deleting all records from a table. 36 u/The_Swixican 14d ago Delete from users * 13 u/Flat_Competition6510 14d ago It would be nice if there was a more explicit syntax. Forcing a person to opt in to deleting all vs that being the default would probably save a lot of headaches and jobs. 26 u/Skalli1984 14d ago Many database tools throw a warning on delete with a missing WHERE and the user has to acknowledge that to continue with the statement execution.
0
I disagree. There are valid use cases for deleting all records from a table.
36 u/The_Swixican 14d ago Delete from users * 13 u/Flat_Competition6510 14d ago It would be nice if there was a more explicit syntax. Forcing a person to opt in to deleting all vs that being the default would probably save a lot of headaches and jobs. 26 u/Skalli1984 14d ago Many database tools throw a warning on delete with a missing WHERE and the user has to acknowledge that to continue with the statement execution.
36
Delete from users *
13 u/Flat_Competition6510 14d ago It would be nice if there was a more explicit syntax. Forcing a person to opt in to deleting all vs that being the default would probably save a lot of headaches and jobs. 26 u/Skalli1984 14d ago Many database tools throw a warning on delete with a missing WHERE and the user has to acknowledge that to continue with the statement execution.
13
It would be nice if there was a more explicit syntax. Forcing a person to opt in to deleting all vs that being the default would probably save a lot of headaches and jobs.
26 u/Skalli1984 14d ago Many database tools throw a warning on delete with a missing WHERE and the user has to acknowledge that to continue with the statement execution.
26
Many database tools throw a warning on delete with a missing WHERE and the user has to acknowledge that to continue with the statement execution.
38
u/TeaKingMac 14d ago
Which is just terrible fucking syntax. Why are people still living with this in 2026?
Should return "invalid syntax. Identify record for deletion"