删除数据时会报错:
You are using safe update mode and you tried to update a table without a WHERE clause that uses a KEY column.”
原因是在safe mode下,要强制安全,
要取消这个限制,可以:
SET SQL_SAFE_UPDATES=0;
即可
MySQL safe mode
最新推荐文章于 2021-05-11 14:10:45 发布
删除数据时会报错:
You are using safe update mode and you tried to update a table without a WHERE clause that uses a KEY column.”
原因是在safe mode下,要强制安全,
要取消这个限制,可以:
SET SQL_SAFE_UPDATES=0;
即可