关于between and 跟>=

mysql中between and 跟>=<=的效果完全一样，between and相当于>= <=的一种语法糖，mysql内部会翻译成>=<=