Safe Update still working
Desite the fact that I unabled the safe update as mentioned in the first video of this section, It is still preventing me from doing an update statement without where condition. Is there any explanation or help?
Thanks for reaching out!
Even if you've disabled safe updates in MySQL Workbench, it's possible that it's still being enforced at the server level. MySQL Server has a system variable
called sql_safe_updates which, when enabled, restricts
DELETE statements similarly to Workbench's safe updates mode.
To see if this variable is enabled at the server level, you can run the following command:
SHOW VARIABLES LIKE 'sql_safe_updates';
If the value is ON, you can turn it off for your current session using:
Hope this helps.