MySQL Error Code: 1175

来源:互联网 发布:淘宝博库图书专营店 编辑:程序博客网 时间:2024/05/17 07:25

delete from user where username = '222'


编译报错:

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.


解决方法:
SET SQL_SAFE_UPDATES=0;

delete from user where username = '222'

0 0
原创粉丝点击