Resolved: Problem with executing the DELETE statement
Hi there. I tried to run this command
DELETE FROM departments_dup
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