TERSUS笔记员工信息516Mysql查询(时间段的唯一性判断)

确认唯一时间段

数据库的合同起(qiDate)值<输入值止的值，数据库的变更止(biangengDate)值>输入值起的值

SELECT * from 16jiage WHERE feiyOngleibie='套餐费用' and qiDate<'2022-01-04' and biangengDate>'2022-01-03'

SELECT * from 16jiage WHERE feiyOngleibie='套餐费用' and qiDate<'2022-01-06' and biangengDate>'2022-01-01'

SELECT * from 16jiage WHERE feiyOngleibie='套餐费用' and qiDate<'2022-01-06' and biangengDate>'2022-01-09'

SELECT * from 16jiage WHERE feiyOngleibie='套餐费用' 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}