MySQL Update field value prompts you is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to Disab Le Safe mode

1 Introduction

When the where statement is missing from the update field, MySQL prompts for the error code:

Error code:1175. You is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to disable safe mode , toggle the option in Preferences, SQL Queries and reconnect. 0.000 sec

2 Solutions

SET SQL_SAFE_UPDATES = 0;
update table name set field 1 = field 2 + 1;
SET SQL_SAFE_UPDATES = 1; 

3 Summary

This article is used only as a record.

MySQL Update field value prompts you is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to Disab Le Safe mode