SET SQL_SAFE_UPDATES = 0

来源:互联网 发布:selenium java 编辑:程序博客网 时间:2024/05/16 17:25
09:30:52update zjzc.ProductRepaymentPlan set settlementDate = '2015-06-05' where productSn = 87Error 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.0.016 secSET SQL_SAFE_UPDATES = 0;update zjzc.ProductRepaymentPlanset settlementDate = '2015-06-05'where productSn = 87;

0 0
原创粉丝点击