600字范文,内容丰富有趣,生活中的好帮手!
600字范文 > 执行update和delete的SQL语句时 报错:Error Code: 1175. You are using safe update mode and you tried to update a

执行update和delete的SQL语句时 报错:Error Code: 1175. You are using safe update mode and you tried to update a

时间:2022-06-24 11:22:08

相关推荐

执行update和delete的SQL语句时 报错:Error Code: 1175. You are using safe update mode and you tried to update a

执行SQL语句时,报错:

13:36:42 delete from users where username='lisi' 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

解决方法:

执行SQL语句:

SET SQL_SAFE_UPDATES = 0;

output:

13:40:53 SET SQL_SAFE_UPDATES = 0 0 row(s) affected 0.000 sec

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。