Navicat 查数据
提取单行
#select id from (select id from 20191226_test order by id asc) t
#select id from (select id from 20191226_test order by id asc) t where not exists (select 1 from 20191226_test where id=t.id-1)
select TestID from (select TestID from 20191226_test order by TestID asc) t
SELECT * from zt_bug where closedBy='huangpeng' ;
时间范围内的某个字段查询
SELECT * FROM zt_bug WHERE openedDate BETWEEN "2019-10-23 00:00:00" AND "2019-10-23 23:59:59" AND openedBy="huangpeng";
select * from zt_bug where date_format(openedDate,'%Y%m%d') = '20190812' AND openedBy='huangpeng';
查询一个字段
SELECT * FROM zt_bug WHERE openedBy="huangpeng";
查询某一天
select * from zt_bug where date_format(openedDate,'%Y%m%d') = '20190812';
查数
SELECT COUNT(*) FROM test1 WHERE EstimatesRanged="high" AND TestValue >=0.7;
SELECT * FROM test2 WHERE EstimatesRanged ="high" AND TestValue > 0.95 AND TestValue =0.95
select count(*) from test2 WHERE EstimatesRanged ="high" AND TestValue > 0.95 ;
select count(*) from test2 WHERE EstimatesRanged ="high" AND TestValue =0.95 ;
select count(*) from test2;
select * from test2 WHERE TestValue =0.95 ;
SELECT *FROM test1 WHERE TestValue >=0.7;
SELECT COUNT(*) FROM test1 WHERE EstimatesRanged="high" AND TestValue >=0.7;