--ts天数
update t_sys_login_info a inner join (select DATEDIFF(CURDATE(),login_time) as ts,info_id from t_sys_login_info) b on a.info_id = b.info_id
set a.day_count = b.ts;
一条sql更新表的距离今天的天数字段
最新推荐文章于 2022-03-02 19:41:28 发布
--ts天数
update t_sys_login_info a inner join (select DATEDIFF(CURDATE(),login_time) as ts,info_id from t_sys_login_info) b on a.info_id = b.info_id
set a.day_count = b.ts;