How to remove the safe update option in the MySQL

As we all know that MySQL by default doesnt allow the user to perform operations on the tables. This is also called as Error 1175. ( 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.). The user needs to change the preferences before he start working on the updates. Please go through the following actions

1. Go to Edit -> Preferences.
2. Switch to 'SQL Queries' tab and uncheck the option ' "Safe Updates" '.
3. Reconnect the server by using Query -> Reconnect to the server.
4. Execute your query once you reconnect to the server.

Share this