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 -> Query Editor and reconnect.
调用存储过程时报错:
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
Solution:
执行如下:
SET SQL_SAFE_UPDATES = 0;
再调及调试通过。这是因为再更新表,插入数据时报错。