取消安全
SET SQL_SAFE_UPDATES=0;
修改内容 查询非空和不为ab12345678的password 改为ab12345678
UPDATE `ht_trade`.User SET password='$2b$10$.b9EqgiWXMBGVIKdCa.TQOWLqwfkvLE9FOQrgY1BDFjA/EVKy0LXm' WHERE password!='' AND password<>'$2b$10$.b9EqgiWXMBGVIKdCa.TQOWLqwfkvLE9FOQrgY1BDFjA/EVKy0LXm';
打开安全
SET SQL_SAFE_UPDATES=1;