MySQL: Error Code: 1175 You are using safe update mode




Update my_table
Set name = 'abc';


Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect.

MySQL 1175 error occurs when you are using Update query in safe mode, there are two solutions to fix this:


  1. Turn off Safe Mode by executing the query: SET SQL_SAFE_UPDATES=0; on you MySQL Workbeanch.

  2. Use the update query with WHERE clause.

To turn on Safe Mode again: SET SQL_SAFE_UPDATES=1;


Topics Coverage:


🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.

Follow Us: GitHub | Facebook | Twitter | Instagram