java基础 20.1.3 SQL BETWEEN 操作符

1、查看数据库中的表的信息。

2、SELECT column_name(s)FROM table_nameWHERE column_name BETWEEN value1 AND value2;

3、SELECT * FROM `user` WHERE age BETWEEN 11 AND 11.这样写就和age =11是一样的效果

4、SELECT * FROM `user` WHERE age NOT BETWEEN 11 AND 11；使用not代表不在这之间，这个意思就是不是年龄为11的

5、SELECT * FROM `user` WHERE age NOT BETWEEN 11 AND 13；不包含11到13之间的