Tersus notes employee information 516 MySQL query (time period uniqueness judgment of 2 fields)

Confirm the only time period
The contract of the database starts from (qiDate) value < Enter the value of the end of the value , Changes to the database (biangengDate) value > Value from input value

SELECT * from 16jiage WHERE feiyongleibie=' Package fee ' and qiDate<'2022-01-04' and biangengDate>'2022-01-03'
SELECT * from 16jiage WHERE feiyongleibie=' Package fee ' and qiDate<'2022-01-06' and biangengDate>'2022-01-01'
SELECT * from 16jiage WHERE feiyongleibie=' Package fee ' and qiDate<'2022-01-06' and biangengDate>'2022-01-09'
SELECT * from 16jiage WHERE feiyongleibie=' Package fee ' and qiDate<'2022-01-12' and biangengDate>'2022-01-11'

select * from 16jiage where 01KSid=${1} and qiDate<${3} and biangengDate>${2} and feiyongleibie=${4}
and feiyongxiangmu=${5} and xiangxingchicun=${6} and 13GKidtixiang=${7} and Zsheng=${8} and Zshi=${9}
and Zxian=${10} and Xsheng=${11} and Xshi=${12} and Xxian=${13} and 13GKidhuanxiang=${14}

author ： Chang'an escort agency

Game programming ️, A game development favorite ~

If the picture is not displayed for a long time , Please use Chrome Kernel browser .