分类：between范围

2021
08-20

mysql中between的边界,范围说明

mysqlbetween的边界范围between的范围是包含两边的边界值eg：idbetween3and7等价与id>=3andid<=7notbetween的范围是不包含边界值eg：idnotbetween3and7等价与id<3orid>7SELECT*FROM`test`whereidBETWEEN3and7;等价于SELECT*FROM`test`whereid>=3andid<=7;-----------------------------------------------------------SELECT*FROM`test`whereidNOTBETWEEN3and7;等价于SELECT... 继续阅读 >