Sentry Answers>SQL>

In MySQL how do I fix the error code 1175 during an update in MySQL workbench?

In MySQL how do I fix the error code 1175 during an update in MySQL workbench?

Richard C.

The problemJump To Solution

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 solution

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:

Click to Copy
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.

Click to Copy
SET SQL_SAFE_UPDATES = 0;

To turn it back on again, run:

Click to Copy
SET SQL_SAFE_UPDATES = 1;
  • Community SeriesIdentify, Trace, and Fix Endpoint Regression Issues
  • Syntax.fm logo
    Listen to the Syntax Podcast

    Tasty treats for web developers brought to you by Sentry. Get tips and tricks from Wes Bos and Scott Tolinski.

    SEE EPISODES

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.

© 2024 • Sentry is a registered Trademark
of Functional Software, Inc.