mysql
虫二HLX
----本人很玻璃心 你反驳我 我就骂你----
展开
-
mysql拆分字符串
SELECTSUBSTRING_INDEX(SUBSTRING_INDEX(keep_watch_route.staff_user_id,',',help_topic_id+1),',',-1) AS numFROMkeep_watch_route,mysql.help_topicWHERE keep_watch_route.`status`='0' andhelp_topic_id < LENGTH(keep_watch_route.staff_user_id)-LENGTH(R...原创 2020-07-15 14:02:42 · 266 阅读 · 0 评论 -
mysql身份证号手机号脱敏
mysql身份证号脱敏:(CASE WHEN people.idcard_no !='' THEN CONCAT(LEFT(people.idcard_no,6), '******' ,RIGHT(people.idcard_no,2)) ELSE '' END) idcard_nomysql手机号脱敏:REPLACE(a.mobile,SUBSTR(a.mobile,4,4), '****') AS mobile原创 2020-06-20 16:25:55 · 381 阅读 · 0 评论 -
mysql 查询当前月份所有天数
select B.days from (SELECT one.datys + two.datys AS days FROM (SELECT 00 datys UNION ALL SELECT 01 datys UNION ALL SELECT 02 datys UNION ALL SELECT 03 datys UNION ALL SELECT 04 datys UNION ALL SELECT 05 datys UNION ALL SELECT 06 datys UNION ALL SEL...原创 2020-06-17 14:40:45 · 1825 阅读 · 0 评论