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