mysql update操作 出现incorrect datetime value

    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
查看全部
coolpig379
coolpig379
2015/06/07 06:49
  • update
  • mysql
  • 点赞
  • 收藏
  • 回答
    私信

1个回复