Workerman/MySQL的update無法更新

AccessDenied 更新于2020-05-17

更新例句：

$row = $MDB->update('connect_wx')->cols(array(
                "nickname"=>$data['nickName'],
                "gender"=>$data['gender'],
                "language"=>$data['language'],
                "city"=>$data['city'],
                "province"=>$data['province'],
                "country"=>$data['country'],
                "avatarurl"=>$data['avatarUrl']
            ))->where('openid= :openid')->bindValues(array("openid"=>$data['openId']))->query();

服務(wù)器信息：

Server CenterOS 8
Workerman version:4.0.4
PHP version:7.4.6
MySQL 8.0.20

問題

插入可以，就是更新會(huì)出現(xiàn)問題，無法更新，$row是0

 3502  1 0

1個(gè)回答

AccessDenied 2020-05-17

$MDB->update('connect_wx')->cols(array(
                "nickname"=>$data['nickName'],
                "gender"=>$data['gender'],
                "language"=>$data['language'],
                "city"=>$data['city'],
                "province"=>$data['province'],
                "country"=>$data['country'],
                "avatarurl"=>$data['avatarUrl']
            ))->where('openid= :openid')->bindValue("openid",$data['openId'])->query();

更新沒有問題，是數(shù)據(jù)沒有變化，所以u(píng)pdatedAt 的 CURRENT_TIMESTAMP 沒有更新