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
- Go to Edit -> Preferences.
- Switch to 'SQL Queries' tab and uncheck the option ' "Safe Updates" '.
- Reconnect the server by using Query -> Reconnect to the server.
- Execute your query once you reconnect to the server.
0 Comment to "How to remove the safe update option in the MySQL"
Post a Comment