SQL语句中between and 范围

最新推荐文章于 2024-10-30 10:57:55 发布

weixin_34357436

最新推荐文章于 2024-10-30 10:57:55 发布

阅读量467

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 java python

原文链接：https://my.oschina.net/u/737187/blog/309648

2019独角兽企业重金招聘Python工程师标准>>>

经过验证 SQL语句中的between 范围1 and 范伟2
语句是包括的范围1和范围2的

SQL> create table test
  2  (
  3  test1 number(2)
  4  );

表已创建。


SQL> insert into test values(1);

已创建 1 行。

SQL> insert into test values(2);

已创建 1 行。

SQL> insert into test values(10);

已创建 1 行。

SQL> commit;

提交完成。


SQL> select * from test where test1 between 1 and 10;

     TEST1
----------
         1
         2
        10

mysql> use mldn
Database changed

mysql> create table test
    -> (
    ->   test1 int
    -> );
Query OK, 0 rows affected (0.69 sec)

mysql> insert into test values(1);
Query OK, 1 row affected (0.10 sec)

mysql> insert into test values(2);
Query OK, 1 row affected (0.00 sec)

mysql> insert into test values(10);
Query OK, 1 row affected (0.00 sec)

[size=xx-large]观察此处：[/size]
mysql> select * from test where test1 between 1 and 10;
+-------+
| test1 |
+-------+
|     1 |
|     2 |
|    10 |
+-------+
3 rows in set (0.07 sec)

mysql> alter table test modify test1 varchar(10);
Query OK, 3 rows affected (0.27 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> insert into test values('a');
Query OK, 1 row affected (0.04 sec)

mysql> insert into test values('d');
Query OK, 1 row affected (0.02 sec)

mysql> insert into test values('z');
Query OK, 1 row affected (0.02 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

[size=xx-large]观察此处：[/size]
mysql> select * from test where test1 between 'a' and 'z';
+-------+
| test1 |
+-------+
| a     |
| d     |
| z     |
+-------+
3 rows in set (0.02 sec)

转载于:https://my.oschina.net/u/737187/blog/309648