1175 🐬 MySQL

MySQL ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

MySQL Workbench’s safe updates mode blocked an UPDATE/DELETE without a key-based WHERE.

Seen on: MySQL

Meaning

sql_safe_updates protects against accidental full-table changes. It’s on by default in Workbench.

Common causes

  • UPDATE/DELETE without WHERE
  • WHERE on a non-indexed column

⚡ Quick fix

  1. Add a key-based WHERE
  2. Temporarily SET SQL_SAFE_UPDATES = 0 for intentional bulk changes
  3. Turn it off in Workbench preferences

Detailed fix by platform

MySQL

  1. SET SQL_SAFE_UPDATES = 0; UPDATE products SET active = 1; SET SQL_SAFE_UPDATES = 1;

How to diagnose

  1. Statement — WHERE uses an indexed column?
  2. Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.