Last answered:

23 Dec 2021

Posted on:

15 Jun 2021

0

Resolved: Problem with executing the DELETE statement

Hi there. I tried to run this command
DELETE FROM departments_dup
WHERE
    dept_no = 'd002';
which is part of the assignment in this section and I get this error message.
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.
Should I follow the instruction and disable safe mode?
Please help. Thanks

1 answers ( 1 marked as helpful)
Instructor
Posted on:

23 Dec 2021

0

Hi Wiz!
Thanks for reaching out!
Please go to Edit/Preferences/SQL Editor, scroll down and un-tick the Safe Updates box.
Then, reconnect to the database and retry running your query.
Hope this helps.
Best,
Martin

Submit an answer