Error in Assignment
in SQL / Introduction to JOINs
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
1 answers ( 0 marked as helpful)
Thanks for reaching out.
Follow these steps before executing these commands. In MySQL Workbench:
- Go to
"SQL Editor"tab and uncheck
Reconnect to Server// logout and then login
- Now execute your SQL query
Hope this helps.