# 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

**Code:** `1175` · **Category:** MySQL · **Seen on:** MySQL

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

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

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/mysql/1175-safe-update-mode)
