Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Disabling Queries

moazammoazam EntrantInactive User Role Beginner
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

Comments

  • xaprbxaprb Mentor Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.