在好例子网，分享、交流、成长！
您当前所在位置：首页 → Python 开发实例 → Python语言基础 → sqlite_教程(sqlite_tutorial.pdf)

sqlite_教程(sqlite_tutorial.pdf)

Python语言基础

下载此实例
  • 开发语言：Python
  • 实例大小：1.48M
  • 下载次数：16
  • 浏览次数：196
  • 发布时间：2020-02-28
  • 实例类别：Python语言基础
  • 发 布 人：primaldual
  • 文件格式：.pdf
  • 所需积分：2
 相关标签： SQLite sql 教程
网友评论 举报投诉 收藏该页

实例介绍

【实例简介】

【实例截图】

from clipboard

【核心代码】

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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
Table of Contents
About the Tutorial ............................................................................................................................................ i
Audience........................................................................................................................................................... i
Prerequisites..................................................................................................................................................... i
Disclaimer & Copyright..................................................................................................................................... i
Table of Contents ............................................................................................................................................ ii
SQLITE BASICS ............................................................................................................................. 1
SQLite ─ Overview.....................................................................................................................................2
What is SQLite? ...............................................................................................................................................2
Why SQLite? ....................................................................................................................................................2
SQLite ─ A Brief History ...................................................................................................................................3
SQLite Limitations............................................................................................................................................3
SQLite Commands ...........................................................................................................................................3
SQLite ─ Installation..................................................................................................................................5
Install SQLite on Windows...............................................................................................................................5
Install SQLite on Linux .....................................................................................................................................5
Install SQLite on Mac OS X...............................................................................................................................6
SQLite ─ Commands..................................................................................................................................7
SQLite ─ Syntax .......................................................................................................................................11
SQLite ─ Data Type..................................................................................................................................18
SQLite Storage Classes...................................................................................................................................18
SQLite Affinity Type .......................................................................................................................................18
SQLite Affinity and Type Names....................................................................................................................19
SQLite ─ CREATE Database ......................................................................................................................21
The .dump Command ....................................................................................................................................22
SQLite ─ ATTACH Database .....................................................................................................................23
SQLite ─ DETACH Database .....................................................................................................................24
SQLite ─ CREATE Table ............................................................................................................................25
SQLite ─ DROP Table ...............................................................................................................................27
SQLite ─ INSERT Query ............................................................................................................................28
SQLite ─ SELECT Query ............................................................................................................................31
SQLite ─ Operators..................................................................................................................................34
What is an Operator in SQLite? .....................................................................................................................34
SQLite Arithmetic Operators .........................................................................................................................34
SQLite Comparison Operators.......................................................................................................................35
SQLite Logical Operators ...............................................................................................................................38
SQLite Bitwise Operators...............................................................................................................................42
SQLite
iii
SQLite ─ Expressions ...............................................................................................................................44
SQLite - Boolean Expression ..........................................................................................................................44
SQLite - Numeric Expression .........................................................................................................................45
SQLite - Date Expression................................................................................................................................45
SQLite ─ WHERE Clause ...........................................................................................................................46
SQLite ─ AND & OR Operators.................................................................................................................50
The AND Operator.........................................................................................................................................50
The OR Operator ...........................................................................................................................................51
SQLite ─ UPDATE Query ..........................................................................................................................53
SQLite ─ DELETE Query............................................................................................................................55
SQLite ─ LIKE Clause ................................................................................................................................57
SQLite ─ GLOB Clause..............................................................................................................................60
SQLite ─ LIMIT Clause..............................................................................................................................63
SQLite ─ ORDER BY Clause.......................................................................................................................65
SQLite ─ GROUP BY Clause ......................................................................................................................67
SQLite ─ HAVING Clause..........................................................................................................................70
SQLite ─ DISTINCT Keyword ....................................................................................................................72
ADVANCED SQLITE .................................................................................................................... 74
SQLite ─ PRAGMA ...................................................................................................................................75
auto_vacuum Pragma....................................................................................................................................75
cache_size Pragma ........................................................................................................................................76
case_sensitive_like Pragma ...........................................................................................................................76
count_changes Pragma .................................................................................................................................76
database_list Pragma ....................................................................................................................................76
encoding Pragma...........................................................................................................................................76
freelist_count Pragma ...................................................................................................................................77
index_info Pragma.........................................................................................................................................77
index_list Pragma ..........................................................................................................................................77
journal_mode Pragma...................................................................................................................................77
max_page_count Pragma..............................................................................................................................78
page_count Pragma.......................................................................................................................................78
page_size Pragma..........................................................................................................................................78
parser_trace Pragma .....................................................................................................................................78
recursive_triggers Pragma.............................................................................................................................79
schema_version Pragma................................................................................................................................79
secure_delete Pragma...................................................................................................................................79
sql_trace Pragma...........................................................................................................................................79
synchronous Pragma .....................................................................................................................................80
temp_store Pragma.......................................................................................................................................80
SQLite
iv
temp_store_directory Pragma ......................................................................................................................80
user_version Pragma.....................................................................................................................................81
writable_schema Pragma ..............................................................................................................................81
SQLite ─ Constraints................................................................................................................................82
NOT NULL Constraint.....................................................................................................................................82
DEFAULT Constraint ......................................................................................................................................83
UNIQUE Constraint........................................................................................................................................83
PRIMARY KEY Constraint ...............................................................................................................................84
CHECK Constraint ..........................................................................................................................................84
Dropping Constraint ......................................................................................................................................85
SQLite ─ JOINS.........................................................................................................................................86
The CROSS JOIN.............................................................................................................................................87
The INNER JOIN .............................................................................................................................................88
The OUTER JOIN ............................................................................................................................................89
SQLite ─ UNION Clause............................................................................................................................90
The UNION ALL Clause...................................................................................................................................92
SQLite ─ NULL Values..............................................................................................................................94
SQLite ─ ALIAS Syntax .............................................................................................................................97
SQLite ─ Triggers...................................................................................................................................100
Listing Triggers.............................................................................................................................................102
Dropping Triggers........................................................................................................................................103
SQLite ─ Indexes....................................................................................................................................104
The CREATE INDEX Command .....................................................................................................................104
The DROP INDEX Command ........................................................................................................................106
SQLite – INDEXED BY Clause..................................................................................................................107
SQLite ─ ALTER TABLE Command ..........................................................................................................109
SQLite ─ TRUNCATE TABLE Command ...................................................................................................111
SQLite ─ Views ......................................................................................................................................112
Creating Views.............................................................................................................................................112
Dropping Views ...........................................................................................................................................113
SQLite ─ Transactions............................................................................................................................114
Properties of Transactions...........................................................................................................................114
Transaction Control .....................................................................................................................................114
SQLite ─ Subqueries..............................................................................................................................117
Subqueries with SELECT Statement.............................................................................................................117
Subqueries with INSERT Statement.............................................................................................................118
Subqueries with UPDATE Statement...........................................................................................................119
Subqueries with DELETE Statement ............................................................................................................120
SQLite ─ AUTOINCREMENT ...................................................................................................................121
SQLite
v
SQLite ─ Injection..................................................................................................................................123
Preventing SQL Injection .............................................................................................................................123
SQLite ─ EXPLAIN ..................................................................................................................................125
SQLite ─ VACUUM.................................................................................................................................127
Manual VACUUM ........................................................................................................................................127
Auto-VACCUM .............................................................................................................................................127
SQLite ─ Date & Time ............................................................................................................................129
Time Strings.................................................................................................................................................129
Modifiers .....................................................................................................................................................130
Formatters...................................................................................................................................................130
SQLite ─ Useful Functions......................................................................................................................133
SQLite COUNT Function...............................................................................................................................134
SQLite MAX Function...................................................................................................................................135
SQLite MIN Function....................................................................................................................................135
SQLite AVG Function ...................................................................................................................................135
SQLite SUM Function...................................................................................................................................136
SQLite RANDOM Function ...........................................................................................................................136
SQLite ABS Function ....................................................................................................................................136
SQLite UPPER Function................................................................................................................................136
SQLite LOWER Function...............................................................................................................................137
SQLite LENGTH Function .............................................................................................................................137
SQLite sqlite_version Function ....................................................................................................................138
SQLITE INTERFACES ................................................................................................................. 139
SQLite ─ C/C   ......................................................................................................................................140
C/C   Interface APIs....................................................................................................................................140
Connect to Database ...................................................................................................................................141
Create a Table..............................................................................................................................................142
INSERT Operation ........................................................................................................................................143
SELECT Operation ........................................................................................................................................145
UPDATE Operation ......................................................................................................................................147
DELETE Operation........................................................................................................................................149
SQLite ─ Java.........................................................................................................................................152
Installation...................................................................................................................................................152
Connect to Database ...................................................................................................................................152
Create a Table..............................................................................................................................................153
INSERT Operation ........................................................................................................................................154
SELECT Operation ........................................................................................................................................155
UPDATE Operation ......................................................................................................................................157
DELETE Operation........................................................................................................................................159
SQLite ─ PHP .........................................................................................................................................162
Installation...................................................................................................................................................162
PHP Interface APIs.......................................................................................................................................162
Connect to Database ...................................................................................................................................163
Create a Table..............................................................................................................................................164
SQLite
vi
INSERT Operation ........................................................................................................................................165
SELECT Operation ........................................................................................................................................166
UPDATE Operation ......................................................................................................................................168
DELETE Operation........................................................................................................................................169
SQLite ─ Perl .........................................................................................................................................172
Installation...................................................................................................................................................172
DBI Interface APIs........................................................................................................................................172
Connect to Database ...................................................................................................................................174
Create a Table..............................................................................................................................................175
INSERT Operation ........................................................................................................................................176
SELECT Operation ........................................................................................................................................177
UPDATE Operation ......................................................................................................................................179
DELETE Operation........................................................................................................................................180
SQLite ─ Python ....................................................................................................................................183
Installation...................................................................................................................................................183
Python sqlite3 module APIs.........................................................................................................................183
Connect to Database ...................................................................................................................................186
Create a Table..............................................................................................................................................186
INSERT Operation ........................................................................................................................................187
SELECT Operation ........................................................................................................................................188
UPDATE Operation ......................................................................................................................................189
DELETE Operation........................................................................................................................................190

标签： SQLite sql 教程

实例下载地址

sqlite_教程(sqlite_tutorial.pdf)

不能下载？内容有错？ 点击这里报错 + 投诉 + 提问

好例子网口号：伸出你的我的手 — 分享！

相关软件

相关文章

网友评论

我要评论

发表评论

(您的评论需要经过审核才能显示)

查看所有0条评论>>

小贴士

感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。

  • 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  • 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
  • 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
  • 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。

关于好例子网

本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明

;
报警