SQL更新语句，Error Code: 1175. You are using safe update

转自百度经验Error Code: 1175. You are using safe update

原来的SET SQL_SAFE_UPDATES = 1;

如果条件定语从句where后面跟的不是主键，则会报上面的错，将上面的安全级别设低一点即可，如下：

SET SQL_SAFE_UPDATES = 0;

再执行更新语句，如

SET SQL_SAFE_UPDATES = 0;update project.demand set title="硬盘到了，谁来帮我换个硬盘啊" where title="亲热";

删除null值

delete from comment where c_content is null