在尝试执行数据库更新语句时报错:
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.
mysql在执行删除更新语句时报这种错误,是因为在mysql在safe-updates模式中,执行:
SET SQL_SAFE_UPDATES = 0;
语句,更改数据库模式即可。