摘要：
select resolvedDate from zt_bug WHERE product = '189' and date_format(resolvedDate,'%Y-%m-%d')=date_format(DATE_SUB(CURDATE(), INTERVAL 1 DAY),'%Y-%m- 阅读全文
摘要：
import pymysql,xlwt,os sql1='''SELECT type, count( * ) AS 激活数量, sum( IF ( severity = 1, 1, 0 ) ) AS 1级数量, sum( IF ( severity = 2, 1, 0 ) ) AS 2级数量, su 阅读全文
摘要：
import pymysql,xlwtdef export_excel(table_name): host,user,passwd,db='192.168.1.10','root','zentao_123','zentao' coon=pymysql.connect(host=host,user=u 阅读全文
摘要：
import pymysql,xlwt def export_excel(table_name): host,user,passwd,db='192.168.1.152','root','myjcyf','us_sys' coon=pymysql.connect(host=host,user=use 阅读全文
摘要：
select count(*) from zt_bug WHERE date_format(openedDate,'%Y-%m-%d')=date_format(NOW(),'%Y-%m-%d') 阅读全文
摘要：
SELECT type, count( * ) AS 激活数量, sum( IF ( severity = 1, 1, 0 ) ) AS 1级数量, sum( IF ( severity = 2, 1, 0 ) ) AS 2级数量, sum( IF ( severity = 3, 1, 0 ) ) 阅读全文
摘要：
https://blog.csdn.net/HibonLi/article/details/72897486 SELECT count( * ) as 激活数量,GROUP_CONCAT(a.type separator ';') ,d.severity='1' as 1级BUG,d.severit 阅读全文