1175 MySQL Origin: Data OSI layer 7 · Application Last updated 15 Oct 2026

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.

Exact message you may see You are using safe update mode
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 not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

08P01 — ERROR: bind message supplies 2 parameters, but prepared statement requires 1 (PostgreSQL)08P011093 — MySQL ERROR 1093 (HY000): You can't specify target table 'x' for update in FROM clause (MySQL)10931241 — MySQL ERROR 1241 (21000): Operand should contain 1 column(s) (MySQL)124142804 — ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression. (PostgreSQL)4280442P10 — ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification (PostgreSQL)42P1042P18 — ERROR: could not determine data type of parameter $1 (PostgreSQL)42P18NonUniqueResultException — IncorrectResultSizeDataAccessException: query did not return a unique result: 2 (Java)NonUniqueResultExcept…1175

Explore the map of this error Full error map →

🧠 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.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.