SQLite TOTAL_CHANGES() 函数

 SQLite 函数

SQLite TOTAL_CHANGES() 函数返回自当前数据库连接打开以来由 INSERT、UPDATE 或 DELETE 语句引起的行更改数。

语法

复制代码复制代码TOTAL_CHANGES()
1

参数

无需参数。

返回值

返回行数由当前会话的数据库中的 INSERT、UPDATE 或 DELETE 引起的更改

示例:

考虑下面的示例，其中创建了一个名为 Employee 的表。创建表后，TOTAL_CHANGES()函数用于获取由于当前会话在数据库中使用 INSERT、UPDATE 或 DELETE 语句而更改的行数。

复制代码复制代码sqlite> CREATE TABLE Employee (
  EmpID INTEGER PRIMARY KEY, 
  Name VARCHAR(50));

sqlite> SELECT TOTAL_CHANGES();
+-----------------+
| TOTAL_CHANGES() |
+-----------------+
|               0 |
+-----------------+

sqlite> INSERT INTO Employee(Name) Values ('John');

sqlite> INSERT INTO Employee(Name) Values ('Marry');

sqlite> SELECT TOTAL_CHANGES();
+-----------------+
| TOTAL_CHANGES() |
+-----------------+
|               2 |
+-----------------+

sqlite> INSERT INTO Employee(Name) Values ('Kim') , ('Jo');

sqlite> SELECT TOTAL_CHANGES();
+-----------------+
| TOTAL_CHANGES() |
+-----------------+
|               4 |
+-----------------+

sqlite> SELECT * FROM Employee;
+-------+-------+
| EmpID | Name  |
+-------+-------+
| 1     | John  |
| 2     | Marry |
| 3     | Kim   |
| 4     | Jo    |
+-------+-------+

sqlite> UPDATE Employee SET Name = 'Suresh' WHERE EmpID = 4;

sqlite> SELECT TOTAL_CHANGES();
+-----------------+
| TOTAL_CHANGES() |
+-----------------+
|               5 |
+-----------------+

sqlite> SELECT * FROM Employee;
+-------+--------+
| EmpID | Name   |
+-------+--------+
| 1     | John   |
| 2     | Marry  |
| 3     | Kim    |
| 4     | Suresh |
+-------+--------+

sqlite> DELETE FROM Employee WHERE EmpID = 4;

sqlite> SELECT TOTAL_CHANGES();
+-----------------+
| TOTAL_CHANGES() |
+-----------------+
|               6 |
+-----------------+

sqlite> SELECT * FROM Employee;
+-------+-------+
| EmpID | Name  |
+-------+-------+
| 1     | John  |
| 2     | Marry |
| 3     | Kim   |
+-------+-------+
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77