you tried to update a table without a WHERE that uses a KEY column
一个简单的update死活执行不了
17:04:36 update brick.pay_info set need_pay =debt +pay_now 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. 0.000 sec
原来是因为mysql有个安全模式,安全模式下必须要通过主键才能update操作
接触安全模式后即可执行:SET SQL_SAFE_UPDATES = 0;
恢复安全模式:SET SQL_SAFE_UPDATES = 1;