Shaillly的博客

第一种：简单叠加 SELECT ip_block, COUNT(*) as zong, count(ip_status = 1 OR NULL) as kong, COUNT(ip_status = 2 OR NULL) as yong, COUNT(ip_status = 3 OR NULL) as xiao, ip_node as node FROM ip_manger GROUP BY ...

日期范围： select * from test where create_time between '2019-07-30' and '2019-07-31'; select * from test where create_time >= '2019-07-30' and date <= '201-07-31' 日期增减 当天0点的日期增减1天 INSERT int...

+= CONCAT(substring(vmcode,13,4),'-',substring(vmcode,17,2) INSERT into allhost select vmcode,CONCAT(substring(vmcode,13,4),'-',substring(vmcode,17,2),'-',substring(vmcode,20,2)),end_time from ho...