safe update

来源:互联网 发布:基于c语言的win32api 编辑:程序博客网 时间:2024/06/02 04:14

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 Queries and reconnect.0.016 sec


使用mysql客户端报的错。


SET SQL_SAFE_UPDATES = 0;
delete from tbl_sum;

这样就可以了。


0 0
原创粉丝点击