When we were in MySQL at school, when we updated or deleted the data, we encountered the following error:
1175 Update and to Update Table WHERE KEY column to option inch - and reconnect. 0.000 sec
The first time you encounter this error is normal, due to the security mechanism of MySQL, the following is the solution:
One: Select the Edit menu above MySQL
Two: Select the Preferences option in the Edit menu, select SQL Editor and the following interface appears:
Three: Remove the selection box in front of safe updates
Four: Reconnect database, then execute SQL to delete
Precautions:
Generally, set sql_safe_updates = 0 is used, and every time we want to delete data or update data.
After changing the settings, you will not be prompted to delete the update data at a later time, it is not good to accidentally delete it.
MySQL Delete data times error Code 1175