56,687
社区成员
发帖
与我相关
我的任务
分享
insert into b
select userid,bookid,DATEDIFF(curdate(),reachdate),DATEDIFF(curdate(),reachdate)*0.1
from a where reachdate>curdate()
SELECT userid,bookid,DATEDIFF(DATE(NOW()),reachdate) AS days,DATEDIFF(DATE(NOW()),reachdate)*0.1 AS money
FROM a