mysql update操作 出现incorrect datetime value

Question

    update iportal_wx.inviterelationshipcycle as A,
(select * from iportal_wx.register where register_ctime<current_timestamp()
AND register_ctime>ADDDATE(current_timestamp(),-1)) as B
set A.IsAttentionHNLLGJ='Y'
where A.MDN_PY=B.user_phone;

    时间对象的数据类型均为datetime

Answer 1

 update iportal_wx.inviterelationshipcycle as A
set A.IsAttentionHNLLGJ='Y'
where exists(select 1 from iportal_wx.register where register_ctime<current_timestamp()
AND register_ctime>ADDDATE(current_timestamp(),-1) and A.MDN_PY=user_phone);