零基礎學MySQL數據庫管理

基礎介紹篇........................................................................... 1
第 1 章 基礎概述... ........................................................................... 2
1.1 數據庫... .............................................................................. 2
1.2 SQL... ................................................................................. 7
1.3 MySQL.............................................................................. 9
1.4 數據類型... ........................................................................ 10
第 2 章 MySQL 的安裝..................................................................... 12
2.1 AppServ 概述... .................................................................. 12
2.2 使用 AppServ 安裝 MySQL... ................................................ 13
第3章 MySQL 查詢... ..................................................................... 16
3.1 文件夾查詢 MySQL... ......................................................... 16
3.2 MySQL 命令查詢 MySQL...................................................... 17
3.3 phpMyAdmin 軟件查詢 MySQL... .......................................... 19
3.4 數據庫說明... ..................................................................... 21
3.4.1 數據庫..................................................................... 21
3.4.2 數據表..................................................................... 22
3.4.3 數據字段...... ............................................................ 23
3.4.4 數據內容...... ............................................................ 23
3.4.5 總結........................................................................ 24
實踐入門篇 ..................................................................... 25
第4章 數據庫創建語句... ............................................................... 26
4.1 查詢數據庫的用戶... ............................................................ 26
4.2 創建數據庫... ..................................................................... 29
4.3 創建數據表和數據字段... ...................................................... 31
4.4 創建數據內容... .................................................................. 34
第5章 數據庫查詢語句... ............................................................... 38
5.1 查詢數據庫... ..................................................................... 38
5.2 查詢數據表... ..................................................................... 40
5.3 查詢數據字段... .................................................................. 41
5.4 查詢數據內容... .................................................................. 43
第6章 數據庫插入語句... ............................................................... 46
6.1 插入數據字段... .................................................................. 46
6.2 插入數據內容... .................................................................. 48
6.3 復制數據表... ..................................................................... 53
第7章 數據庫修改語句... ............................................................... 56
7.1 修改數據庫的名稱... ............................................................ 56
7.2 修改數據表的名稱... ............................................................ 60
7.3 修改數據字段的名稱... ......................................................... 62
7.4 修改數據內容... .................................................................. 64
第8章 數據庫刪除語句... ............................................................... 66
8.1 刪除數據內容... .................................................................. 66
8.2 刪除數據字段... .................................................................. 69 8.3 刪除數據表... ..................................................................... 71
8.4 刪除數據庫... ..................................................................... 74
中高級篇........................................................................... 77
第 9 章 MySQL 關鍵字.....................................................................
9.1 查詢數據庫的安裝路徑和編碼方式... .......................................
78
789.2 flush...privileges... ............................................................... 80
9.3 limit... .............................................................................. 81 9.4 between... ........................................................................ 84 9.5 通配符... ........................................................................... 86 9.6 and... .............................................................................. 87
9.7 or... ................................................................................. 88
9.8 primary...key........................................................................ 89
9.9 desc................................................................................. 92
9.10 asc... .............................................................................. 94
9.11 like... .............................................................................. 94
9.12 IN................................................................................. 95
9.13 select... ........................................................................... 97
9.14 as................................................................................. 98
9.15 not...null... ........................................................................ 99
9.16 join... .............................................................................. 102
9.17 left...join... ........................................................................103
9.18 right...join........................................................................... 10
9.20 default.............................................................................. 107
第 10 章 運算操作... ........................................................................ 110
10.1 加法... ...........................................................................110 10.2 減法.............................................................................. 112 10.3 乘法.............................................................................. 113 10.4 除法.............................................................................. 114 10.5 求和.............................................................................. 115 10.6 求平均值........................................................................ 117 10.7 查詢最小值..................................................................... 118 10.8 查詢最大值..................................................................... 119第 11 章 日期函數... ........................................................................ 121
11.1 查詢當前的日期和時間... ...................................................121 11.2 查詢當前的日期... ............................................................122 11.3 查詢當前的時間... ............................................................123 11.4 查詢當年的第一天... .........................................................123 11.5 查詢當年的最後一天... ......................................................125 11.6 查詢當前周的第一天... ......................................................126 11.7 查詢當前周的最後一天... ...................................................127
第 12 章 視圖... .............................................................................. 129
12.1 創建視圖... .....................................................................130 12.2 查詢視圖........................................................................ 131 12.3 查詢所有的視圖............................................................... 133 12.4 刪除視圖........................................................................ 135 12.5 創建統計視圖.................................................................. 137
第 13 章 操作符和函數... .................................................................. 140
13.1 union...操作符... .................................................................. 140 13.2 union...all 操作符.................................................................. 142 13.3 ucase 函數........................................................................ 143 13.4 lcase 函數... ..................................................................... 144 13.5 mid 函數........................................................................... 145 13.6 now函數... .....................................................................146
第 14 章 備份與恢復... ..................................................................... 147
14.1 phpMyAdmin軟件備份數據庫文件... ....................................147 14.2 phpMyAdmin軟件恢復數據庫文件... ....................................149 14.3 手動備份數據庫文件......................................................... 151 14.4 手動恢復數據庫文件......................................................... 152 14.5 寶塔軟件備份數據庫文件................................................... 154 14.6 寶塔軟件恢復數據庫文件................................................... 155
應用實戰篇..................................................................... 157
第 15 章 核酸數據庫系統... ............................................................... 158
15.1 業務流程........................................................................158 15.2 系統流程........................................................................ 160 15.3 分佈式系統..................................................................... 164
15.3.1 分佈式系統概述... ................................................... 164 15.3.2 應用場景... ............................................................ 165 15.3.3 規劃 MySQL 分佈式系統... ....................................... 166
15.4 Redis... ........................................................................... 166 15.4.1 Redis概述... .........................................................166 15.4.2 規劃 Redis 系統... ................................................... 167
15.5 核酸數據庫系統的設計和實現............................................. 168 15.5.1 創建數據庫... ......................................................... 168 15.5.2 創建數據表和數據字段... .......................................... 169 15.5.3 創建數據內容... ...................................................... 175
15.6 搜索引擎........................................................................ 183 15.7 使用 PHP 程序調用數據庫... ................................................ 187 15.7.1 什麼是 PHP... ......................................................... 187 15.7.2 調用數據庫... ......................................................... 188