4 ms·
This 'default' behaviour strikes me as one of SQL's worst faults. If you want to delete all rows, you should be made to explicitly type out that intention.
by MaxBarraclough 9y ago
This 'default' behaviour strikes me as one of SQL's worst faults.
If you want to delete all rows, you should be made to explicitly type out that intention.
- donatj 9y agoI'd say require a WHERE on deletes. If you want "WHERE true" that's fine, but require a WHERE.
- JoeMalt 9y agoIf you start the MySQL Monitor with --i-am-a-dummy, this is enforced automatically
- MaxBarraclough 9y agoInteresting, thanks. As far as I can tell, there's nothing like that in Postgres.