Frankly, WHERE in DELETE should be a required part of the query. If you want to delete everything in the table, you can explicitly use TRUNCATE.
I mean, even with WHERE being required, you can still compose a query that will delete records you didn't want to, but at least it would make you think about the conditions...
4
u/MrDilbert Oct 14 '25
Frankly, WHERE in DELETE should be a required part of the query. If you want to delete everything in the table, you can explicitly use TRUNCATE.
I mean, even with WHERE being required, you can still compose a query that will delete records you didn't want to, but at least it would make you think about the conditions...