Resolved: Problem with executing the DELETE statement
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Bar and Line Chart - Python - How to Create a Bar and Line Chart
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)
Martin Ganchev
Instructor
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