Disabling Queries

MySQL & MariaDB Other MySQL® Questions
1

Hello,
I read in high performance mysql book that its possible to block such queries.

DELETE FROM table;
UPDATE TABLE SET X=10;

any query that updates full table and also full table scan queries.

Any hint would be really helpful.

Thanks

2

There is a --safe-updates option for the mysql command-line client, but that only works if you’re connecting through the command-line client.