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
|
查看所有表
.tables
查看表结构
.schema users
pragma table_info(api_request_quota_group);
查看表数据
select * from api_user;
创建数据库
sudo sqlite3 test.db
创建表
CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
age INTEGER,
email TEXT UNIQUE
);
插入数据
INSERT INTO users (name, age, email) VALUES ('Alice', 25, 'alice@example.com');
查询数据
SELECT * FROM users;
更新数据
UPDATE users SET age = 26 WHERE name = 'Alice';
删除数据
DELETE FROM users WHERE name = 'Alice';
删除表
DROP TABLE users;
|