当前位置:Gxlcms > mysql > mysqlupdate操作出现incorrectdatetimevalue

mysqlupdate操作出现incorrectdatetimevalue

时间:2021-07-01 10:21:17 帮助过:92人阅读

mysqlupdate

    update iportal_wx.inviterelationshipcycle as A,(select * from iportal_wx.register where register_ctimeADDDATE(current_timestamp(),-1)) as Bset A.IsAttentionHNLLGJ='Y'where A.MDN_PY=B.user_phone;    时间对象的数据类型均为datetime

人气教程排行