MySQL
hxhh
分享一些工作实用技巧和干货,共勉
展开
-
SQL根据身份证,统计用户的省份
根据身份证 fcredit_id, 截取前两位,统计用户的省份 select sum(case when SUBSTRING(fcredit_id,1,2)='11' then 1 else 0 end) as beijing, sum(case when SUBSTRING(fcredit_id,1,2)='12' then 1 else 0 end) as tainjing, sum...原创 2019-12-17 17:39:39 · 1594 阅读 · 0 评论 -
No suitable driver found for jdbc:mysql://192.168.25.121:3306/spark
INFO TaskSetManager: Lost task 1.0 in stage 4.0 (TID 7) on executor localhost: java.sql.SQLException (No suitable driver found for jdbc:mysql://192.168.25.121:3306/spark) [duplicate 1] 18/10/16 18:13:...原创 2018-10-16 18:18:21 · 2131 阅读 · 1 评论