UPDATE `test` SET singer_expired_at = UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(purchase_audit_at),INTERVAL 15 DAY)),merchant_expired_at=UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(purchase_audit_at),INTERVAL 18 DAY))
WHERE purchase_audit_at>0
mysql时间戳添加XX天
最新推荐文章于 2022-06-11 11:52:53 发布