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

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

Follow this topic

Isioma Wiz Ofuasia

Last answered:

23 Dec 2021

Posted on:

15 Jun 2021

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

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

23 Dec 2021

Problem with executing the DELETE statement

Submit an answer

related questions