Navicat 查数据Mysql

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;