- 博客(1)
- 资源 (23)
- 收藏
- 关注
原创 用户统计 - mysql根据身份证号计算用户年龄
下边一大片没啥重要的也就这一句经常用到 SELECT DATE_FORMAT(NOW(), '%Y') - SUBSTRING( '152822198700000000',7,4) AS age #1、关于回款 #(1)以回款日期进行查询(日期可改),查询每个注册来源渠道的来源名称、回款人数、回款金额、回款日期(排除代理人数据) SELECT um.`sou
2017-09-27 14:19:20 6850
手机号码归属地sql(mysql,SQLServer)两个版本
手机号码归属地sql(mysql,SQLServer)两个版本
insert into app_mobile_attribute_info VALUES (1,"1300000","山东","济南","中国联通","0531","250000"
),(2,"1300001","江苏","常州","中国联通","0519","213000"
),(3,"1300002","安徽","巢湖","中国联通","0565","238000"
)
2018-05-07
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人