零基礎(chǔ)學(xué)MySQL數(shù)據(jù)庫管理
定 價：59 元
叢書名：零基礎(chǔ)編程通關(guān)秘籍系列叢書
- 作者：林富榮
- 出版時間：2023/9/1
- ISBN：9787121463464
- 出 版 社：電子工業(yè)出版社
- 中圖法分類：TP311.132.3
- 頁碼：200
- 紙張：
- 版次：01
- 開本：16開
本書是一本全面介紹數(shù)據(jù)庫管理的書籍�；A(chǔ)介紹篇介紹了數(shù)據(jù)庫、SQL、MySQL 以及 數(shù)據(jù)類型等概念，并介紹了 MySQL 的安裝和查詢;實踐入門篇詳細介紹了數(shù)據(jù)庫的創(chuàng)建、查詢、 插入、修改和刪除等語句的使用方法;中高級篇深入介紹了 MySQL 關(guān)鍵字、運算操作、日期 函數(shù)、視圖、操作符等，同時介紹了如何對數(shù)據(jù)庫文件進行備份和恢復(fù);應(yīng)用實戰(zhàn)篇以核酸數(shù) 據(jù)庫系統(tǒng)為例，介紹業(yè)務(wù)流程、系統(tǒng)流程、分布式系統(tǒng)、Redis、核酸數(shù)據(jù)庫系統(tǒng)的設(shè)計與實現(xiàn)、 搜索引擎，以及使用 PHP 程序調(diào)用數(shù)據(jù)庫等內(nèi)容。 本書內(nèi)容新穎、圖文并茂、實例豐富、通俗易懂，可供互聯(lián)網(wǎng)開發(fā)人員、數(shù)據(jù)庫運營人 員以及培訓(xùn)機構(gòu)等相關(guān)人員閱讀，亦可作為初學(xué)者的入門教材。
作者林富榮，出生于廣東省深圳市，20世紀80年代，十余年的計算機科學(xué)與技術(shù)和計算機軟件的互聯(lián)網(wǎng)經(jīng)驗，擁有互聯(lián)網(wǎng)、運營管理和金融的學(xué)習(xí)和實踐經(jīng)驗�，F(xiàn)創(chuàng)立Rysos工作室，任職產(chǎn)品專家，主要從事手工畫作制作、互聯(lián)網(wǎng)網(wǎng)站系統(tǒng)服務(wù)、產(chǎn)品攝影、書籍出版等勞務(wù)工作，是一名互聯(lián)網(wǎng)、電子商務(wù)、運營管理、金融商業(yè)的書籍作家。 參與或主導(dǎo)的軟件產(chǎn)品包括B2C電商系統(tǒng)、C2C團購系統(tǒng)、客戶積分系統(tǒng)、短信收發(fā)系統(tǒng)、CRM和ERP系統(tǒng)、OA系統(tǒng)、員工薪酬系統(tǒng)、證券系統(tǒng)、物流系統(tǒng)、P2P系統(tǒng)、信貸系統(tǒng)、理財系統(tǒng)、BLOG系統(tǒng)、網(wǎng)站流量系統(tǒng)、論壇系統(tǒng)、FICO財務(wù)系統(tǒng)、搜索引擎爬蟲系統(tǒng)。
基礎(chǔ)介紹篇........................................................................... 1
第 1 章 基礎(chǔ)概述... ........................................................................... 2
1.1 數(shù)據(jù)庫... .............................................................................. 2
1.2 SQL... ................................................................................. 7
1.3 MySQL.............................................................................. 9
1.4 數(shù)據(jù)類型... ........................................................................ 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 數(shù)據(jù)庫說明... ..................................................................... 21
3.4.1 數(shù)據(jù)庫..................................................................... 21
3.4.2 數(shù)據(jù)表..................................................................... 22
3.4.3 數(shù)據(jù)字段...... ............................................................ 23
3.4.4 數(shù)據(jù)內(nèi)容...... ............................................................ 23
3.4.5 總結(jié)........................................................................ 24
實踐入門篇 ..................................................................... 25
第4章 數(shù)據(jù)庫創(chuàng)建語句... ............................................................... 26
4.1 查詢數(shù)據(jù)庫的用戶... ............................................................ 26
4.2 創(chuàng)建數(shù)據(jù)庫... ..................................................................... 29
4.3 創(chuàng)建數(shù)據(jù)表和數(shù)據(jù)字段... ...................................................... 31
4.4 創(chuàng)建數(shù)據(jù)內(nèi)容... .................................................................. 34
第5章 數(shù)據(jù)庫查詢語句... ............................................................... 38
5.1 查詢數(shù)據(jù)庫... ..................................................................... 38
5.2 查詢數(shù)據(jù)表... ..................................................................... 40
5.3 查詢數(shù)據(jù)字段... .................................................................. 41
5.4 查詢數(shù)據(jù)內(nèi)容... .................................................................. 43
第6章 數(shù)據(jù)庫插入語句... ............................................................... 46
6.1 插入數(shù)據(jù)字段... .................................................................. 46
6.2 插入數(shù)據(jù)內(nèi)容... .................................................................. 48
6.3 復(fù)制數(shù)據(jù)表... ..................................................................... 53
第7章 數(shù)據(jù)庫修改語句... ............................................................... 56
7.1 修改數(shù)據(jù)庫的名稱... ............................................................ 56
7.2 修改數(shù)據(jù)表的名稱... ............................................................ 60
7.3 修改數(shù)據(jù)字段的名稱... ......................................................... 62
7.4 修改數(shù)據(jù)內(nèi)容... .................................................................. 64
第8章 數(shù)據(jù)庫刪除語句... ............................................................... 66
8.1 刪除數(shù)據(jù)內(nèi)容... .................................................................. 66
8.2 刪除數(shù)據(jù)字段... .................................................................. 69 8.3 刪除數(shù)據(jù)表... ..................................................................... 71
8.4 刪除數(shù)據(jù)庫... ..................................................................... 74
中高級篇........................................................................... 77
第 9 章 MySQL 關(guān)鍵字.....................................................................
9.1 查詢數(shù)據(jù)庫的安裝路徑和編碼方式... .......................................
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 章 日期函數(shù)... ........................................................................ 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 創(chuàng)建視圖... .....................................................................130 12.2 查詢視圖........................................................................ 131 12.3 查詢所有的視圖............................................................... 133 12.4 刪除視圖........................................................................ 135 12.5 創(chuàng)建統(tǒng)計視圖.................................................................. 137
第 13 章 操作符和函數(shù)... .................................................................. 140
13.1 union...操作符... .................................................................. 140 13.2 union...all 操作符.................................................................. 142 13.3 ucase 函數(shù)........................................................................ 143 13.4 lcase 函數(shù)... ..................................................................... 144 13.5 mid 函數(shù)........................................................................... 145 13.6 now函數(shù)... .....................................................................146
第 14 章 備份與恢復(fù)... ..................................................................... 147
14.1 phpMyAdmin軟件備份數(shù)據(jù)庫文件... ....................................147 14.2 phpMyAdmin軟件恢復(fù)數(shù)據(jù)庫文件... ....................................149 14.3 手動備份數(shù)據(jù)庫文件......................................................... 151 14.4 手動恢復(fù)數(shù)據(jù)庫文件......................................................... 152 14.5 寶塔軟件備份數(shù)據(jù)庫文件................................................... 154 14.6 寶塔軟件恢復(fù)數(shù)據(jù)庫文件................................................... 155
應(yīng)用實戰(zhàn)篇..................................................................... 157
第 15 章 核酸數(shù)據(jù)庫系統(tǒng)... ............................................................... 158
15.1 業(yè)務(wù)流程........................................................................158 15.2 系統(tǒng)流程........................................................................ 160 15.3 分布式系統(tǒng)..................................................................... 164
15.3.1 分布式系統(tǒng)概述... ................................................... 164 15.3.2 應(yīng)用場景... ............................................................ 165 15.3.3 規(guī)劃 MySQL 分布式系統(tǒng)... ....................................... 166
15.4 Redis... ........................................................................... 166 15.4.1 Redis概述... .........................................................166 15.4.2 規(guī)劃 Redis 系統(tǒng)... ................................................... 167
15.5 核酸數(shù)據(jù)庫系統(tǒng)的設(shè)計和實現(xiàn)............................................. 168 15.5.1 創(chuàng)建數(shù)據(jù)庫... ......................................................... 168 15.5.2 創(chuàng)建數(shù)據(jù)表和數(shù)據(jù)字段... .......................................... 169 15.5.3 創(chuàng)建數(shù)據(jù)內(nèi)容... ...................................................... 175
15.6 搜索引擎........................................................................ 183 15.7 使用 PHP 程序調(diào)用數(shù)據(jù)庫... ................................................ 187 15.7.1 什么是 PHP... ......................................................... 187 15.7.2 調(diào)用數(shù)據(jù)庫... ......................................................... 188
書單推薦
