时间:2021-07-01 10:21:17 帮助过:92人阅读
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