Posted on Monday 1st April 2019
By default MySQL Workbench has Safe Mode enabled, which prevents sql's which dont target a primary key.
"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"
Example of this would be
UPDATE tbl_users SET user_name = ''In some situaltions you may need to do blanket SQL's such as above, I first ran into this when sanitizing a database for use in a dev enviroment.
In MySQL Workbench