Cant delete records in MySQL Workbench
By:Roy.LiuLast updated:2019-08-17
In MySQL workbench, issue a simple delete all commands
delete FROM users;
But it shows me following 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 Queries and reconnect.
Solution
By default, MySQL workbench is started in safe mode, and can’t update or delete, without a “WHERE” condition, see the error message.
To fix it, in menu, selects “Edit” -> “Preferences” -> “SQL Queries”, uncheck the “Safe Updates” checkbox.
Done, try reconnect and issue the delete command again.
From:一号门
COMMENTS