Announcement

Announcement Module
Collapse
No announcement yet.

Disabling Queries

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Disabling Queries

    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.

    Comment

    Working...
    X