When running an update command against a MySQL database, such as UPDATE Person SET Age=11;
, you might get the error SQL Error [1175] [HY000]: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
. This could be in MySQL Workbench, or any other database GUI client, such as DBeaver. The error comes from the MySQL server, not the client.
The first solution is to obey the error, and change your update query to use a where clause that acts only on rows with a specific Id, such as:
UPDATE Person SET Age=11 WHERE Id = 5;
If however you do want to update every row in the table, you can disable safe mode. Run the query below before running your update command. It changes the variable SQL_SAFE_UPDATES
, which applies per session, so you need to run it every time you log in.
SET SQL_SAFE_UPDATES = 0;
To turn it back on again, run:
SET SQL_SAFE_UPDATES = 1;
Loved by over 4 million developers and more than 90,000 organizations worldwide, Sentry provides code-level observability to many of the world’s best-known companies like Disney, Peloton, Cloudflare, Eventbrite, Slack, Supercell, and Rockstar Games. Each month we process billions of exceptions from the most popular products on the internet.