SQL 查询记录
at 2019.11.11 ca CMS by admin
select user_id as 用户ID, count(user_id) as 数量, sum(time_limit)as 投资时间总长度 , sum(amount/(12/time_limit))as 试算 from investments group by user_id having user_id = 18
select user_infos.user_id ,user_infos.name , staff.tourism_fund as 旅游基金 , entry_time as 入职时间,staff.turn_positive_time as 转正时间, TIMESTAMPDIFF(month,turn_positive_time,SYSDATE())as 入职多少个月 FROM staff,user_infos where user_infos.user_id = staff.user_id
删除表数据
Delete from 表名 where 1=1
版权声明
本文仅代表作者观点,不代表XX立场。
本文系作者授权XX发表,未经许可,不得转载。
gw
回复真实代发、物流单号、快递单号购买www.danhw.com