sqlite(6)运算符

• 算数运算符
• 比较运算符
• 逻辑运算符
• 位运算符

SQLite算数运算符##

实例##

sqlite> .mode line
sqlite> select 10 + 20;
10 + 20 = 30
sqlite> select 10 &＃8211; 20;
10 &＃8211; 20 = -10
sqlite> select 10 * 20;
10 * 20 = 200
sqlite> select 10 / 5;
10 / 5 = 2
sqlite> select 12 % 5;
12 % 5 = 2

SQLite比较运算符##

下面的实例演示了各种SQLite比较运算符的用法。

在这里，我们使用WHERE子句，这将会在后边单独的一个章节中讲解，但现在您需要明白，WHERE子句是用来设置SELECT语句的条件语句。

实例表

下面的SELECT语句列出
了SALARY大于50,000.00的所有记录：

SELECT * FROM COMPANY WHERE SALARY > 50000;
SELECT * FROM COMPANY WHERE SALARY = 20000;
SELECT * FROM COMPANY WHERE SALARY != 20000;
SELECT * FROM COMPANY WHERE SALARY >= 65000;

SQLite逻辑运算符##

实例##

实例

SELECT * FROM COMPANY WHERE AGE >= 25 AND SALARY >= 65000;
SELECT * FROM COMPANY WHERE AGE >= 25 OR SALARY >= 65000;
SELECT * FROM COMPANY WHERE AGE IS NOT NULL;
SELECT * FROM COMPANY WHERE NAME LIKE &＃8216;Ki%&＃8217;;
SELECT * FROM COMPANY WHERE NAME GLOB &＃8216;Ki*&＃8217;;
SELECT * FROM COMPANY WHERE AGE IN ( 25, 27 );
SELECT * FROM COMPANY WHERE AGE NOT IN ( 25, 27 );
SELECT * FROM COMPANY WHERE AGE BETWEEN 25 AND 27;
SELECT AGE FROM COMPANY WHERE EXISTS (SELECT AGE FROM COMPANY WHERE SALARY > 65000);
SELECT * FROM COMPANY WHERE AGE > (SELECT AGE FROM COMPANY WHERE SALARY > 65000);

Selection_004.png

.mode line
select 60 | 13;
select 60 & 13;
select 60 ^ 13;
select (~60)
select (60<<2);
select (60>>2);