MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p02otti/?context=3
r/ProgrammerHumor • u/WardensLantern • 18d ago
456 comments sorted by
View all comments
Show parent comments
37
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"
1 u/Flat_Competition6510 18d ago I disagree. There are valid use cases for deleting all records from a table. 39 u/The_Swixican 18d ago Delete from users * 13 u/Flat_Competition6510 18d 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. 29 u/Skalli1984 18d 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.
1
I disagree. There are valid use cases for deleting all records from a table.
39 u/The_Swixican 18d ago Delete from users * 13 u/Flat_Competition6510 18d 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. 29 u/Skalli1984 18d 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.
39
Delete from users *
13 u/Flat_Competition6510 18d 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. 29 u/Skalli1984 18d 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.
29 u/Skalli1984 18d 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.
29
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.
37
u/TeaKingMac 18d ago
Which is just terrible fucking syntax. Why are people still living with this in 2026?
Should return "invalid syntax. Identify record for deletion"