Error in Assignment
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)
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