Error in Assignment

Question

Hi kindly advise when I am doing the assignment and deleting the departments_dup 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 Editor and reconnect.

I am also unable to get that option when I go in the desired path as well

Kindly advise what needs to be done

Answer 1

Hi Gaurav!
Thanks for reaching out.

Follow these steps before executing these commands. In MySQL Workbench:

Go to Edit --> Preferences
Click "SQL Editor" tab and uncheck"Safe Updates"checkbox
Query --> Reconnect to Server // logout and then login
Now execute your SQL query

Hope this helps.
Best,
Tsvetelin

Error in Assignment

Submit an answer

related questions