mysql一些使用心得
2022/4/3 19:19:45
本文主要是介绍mysql一些使用心得,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
- 单个包含可以使用 LOCATE(要查找的字符串,字段)
- 多个可以使用 字段 REGEXP '字符串1|字符串2|....'
- 替换函数 REPLACE(字段,原字符串,新字符串)
- group_concat会被截取
SET SESSION group_concat_max_len=5120;
SET GLOBAL group_concat_max_len=5120;
group_concat_max_len = 5120
SELECT temp. product, complaint_Content AS complaintContent, itemType, yy, COUNT( DATE_SUB( acceptance_Time, INTERVAL -8 HOUR) = '2021-6-16' OR NULL) AS dayCount, COUNT( YEARWEEK( DATE_SUB( acceptance_Time, INTERVAL -8 HOUR), 1) = YEARWEEK( '2021-6-16', 1) OR NULL) AS weekCount, gy, IF( COUNT( tl. id) > 0, '1', '0' ) as press FROM ( SELECT product, acceptance_Time, complaint_Content, itemType, IFNULL( GROUP_CONCAT( yy. yy ORDER BY yy. yy DESC SEPARATOR '' ), '' ) AS yy, IFNULL( GROUP_CONCAT( gy. gy ORDER BY gy. gy DESC SEPARATOR '' ), '' ) AS gy FROM tb_c_complaint c LEFT JOIN ( SELECT swift_number, CONCAT_WS( ' ', create_Date, add_comment, u. chinese_name) AS gy FROM tb_c_fun_reason tr LEFT JOIN tb_m_user u ON u. user_Id = tr. user_Id ) gy ON gy. swift_number = c. swift_Number LEFT JOIN ( SELECT swift_number, CONCAT_WS( ' ', create_Date, add_comment, u. chinese_name) AS yy FROM tb_c_reason tr LEFT JOIN tb_m_user u ON u. user_Id = tr. user_Id ) yy ON c. swift_number = yy. swift_number WHERE product IN ( SELECT group_name FROM tb_b_fn_group_mem WHERE group_type = 'yw' AND depart_id = 0 ) AND acceptance_Time BETWEEN DATE_SUB( SUBDATE( '2021-6-16', IF( DATE_FORMAT( '2021-6-16', '%w' )= 0, 7, DATE_FORMAT( '2021-6-16', '%w' ) )-1), INTERVAL 8 HOUR) AND DATE_SUB( SUBDATE( '2021-6-16', IF( DATE_FORMAT( '2021-6-16', '%w' )= 0, 7, DATE_FORMAT( '2021-6-16', '%w' ) )-7), INTERVAL -16 HOUR) GROUP BY c. swift_Number ORDER BY acceptance_Time DESC ) temp LEFT JOIN tb_b_press_log tl on tl. item_type = temp. itemType AND tl. press_time> DATE_ADD( CURDATE( ), INTERVAL - DAY( CURDATE( ) )+ 1 DAY) AND (ac_msg!= '' OR st_msg!= '' OR cbc_msg!= '' ) WHERE 1= 1 GROUP BY temp. itemType;
这篇关于mysql一些使用心得的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-04-26MySQL查出时间比实际晚8小时的解决方案
- 2024-04-01JPA不识别MySQL的枚举类型
- 2024-03-30mysql数据库表卡死解决方法
- 2024-03-15MySQL多数据源笔记5-ShardingJDBC实战
- 2024-03-11natural join mysql
- 2024-03-11关于VS2017,VS2015 中利用 EF使用Mysql 不显示数据源问题解决方案
- 2024-02-26mysql 阿里云xb后缀备份文件恢复-icode9专业技术文章分享
- 2024-02-22docker mysql 5.7
- 2024-02-18从 20 多套 MySQL 到 1 套 TiDB丨骏伯网络综合运营管理平台应用实践
- 2024-02-07mysql 外键索引入门介绍,为什么工作中很少有人使用?