首页 > 代码库 > mysql 语句不能update的解决办法

mysql 语句不能update的解决办法

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;

update member set member_passwd=‘e10adc3949ba59abbe56e057f20f883e‘,member_paypwd=‘e10adc3949ba59abbe56e057f20f883e‘  


mysql 语句不能update的解决办法