mycat等值查询与范围查询

98 阅读1分钟

id between 1 and 2

id in(1,2,3)

id = 1

 

where条件通过 1<= id and id <=3在1.6系列会全表扫描