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;

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap