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;

Recent Posts:

Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.