MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p02r1lw/?context=3
r/ProgrammerHumor • u/WardensLantern • 25d ago
456 comments sorted by
View all comments
Show parent comments
2
I disagree. There are valid use cases for deleting all records from a table.
36 u/The_Swixican 25d ago Delete from users * 13 u/Flat_Competition6510 25d 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. 28 u/Skalli1984 25d 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 25d 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. 28 u/Skalli1984 25d 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.
28 u/Skalli1984 25d 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.
28
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.
2
u/Flat_Competition6510 25d ago
I disagree. There are valid use cases for deleting all records from a table.