123,123

內(nèi)容簡(jiǎn)介

　　本書是一本全面介紹數(shù)據(jù)庫管理的書籍?；A(chǔ)介紹篇介紹了數(shù)據(jù)庫、SQL、MySQL 以及數(shù)據(jù)類型等概念，并介紹了 MySQL 的安裝和查詢;實(shí)踐入門篇詳細(xì)介紹了數(shù)據(jù)庫的創(chuàng)建、查詢、插入、修改和刪除等語句的使用方法;中高級(jí)篇深入介紹了 MySQL 關(guān)鍵字、運(yùn)算操作、日期函數(shù)、視圖、操作符等，同時(shí)介紹了如何對(duì)數(shù)據(jù)庫文件進(jìn)行備份和恢復(fù);應(yīng)用實(shí)戰(zhàn)篇以核酸數(shù) 據(jù)庫系統(tǒng)為例，介紹業(yè)務(wù)流程、系統(tǒng)流程、分布式系統(tǒng)、Redis、核酸數(shù)據(jù)庫系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)、搜索引擎，以及使用 PHP 程序調(diào)用數(shù)據(jù)庫等內(nèi)容。本書內(nèi)容新穎、圖文并茂、實(shí)例豐富、通俗易懂，可供互聯(lián)網(wǎng)開發(fā)人員、數(shù)據(jù)庫運(yùn)營(yíng)人員以及培訓(xùn)機(jī)構(gòu)等相關(guān)人員閱讀，亦可作為初學(xué)者的入門教材。

作者簡(jiǎn)介

　　作者林富榮，出生于廣東省深圳市，20世紀(jì)80年代，十余年的計(jì)算機(jī)科學(xué)與技術(shù)和計(jì)算機(jī)軟件的互聯(lián)網(wǎng)經(jīng)驗(yàn)，擁有互聯(lián)網(wǎng)、運(yùn)營(yíng)管理和金融的學(xué)習(xí)和實(shí)踐經(jīng)驗(yàn)?，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ùn)營(yíng)管理、金融商業(yè)的書籍作家。參與或主導(dǎo)的軟件產(chǎn)品包括B2C電商系統(tǒng)、C2C團(tuán)購系統(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)、理財(cái)系統(tǒng)、BLOG系統(tǒng)、網(wǎng)站流量系統(tǒng)、論壇系統(tǒng)、FICO財(cái)務(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
實(shí)踐入門篇 ..................................................................... 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
中高級(jí)篇........................................................................... 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 章運(yùn)算操作... ........................................................................ 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 查詢當(dāng)前的日期和時(shí)間... ...................................................121 11.2 查詢當(dāng)前的日期... ............................................................122 11.3 查詢當(dāng)前的時(shí)間... ............................................................123 11.4 查詢當(dāng)年的第一天... .........................................................123 11.5 查詢當(dāng)年的最后一天... ......................................................125 11.6 查詢當(dāng)前周的第一天... ......................................................126 11.7 查詢當(dāng)前周的最后一天... ...................................................127
第 12 章視圖... .............................................................................. 129
12.1 創(chuàng)建視圖... .....................................................................130 12.2 查詢視圖........................................................................ 131 12.3 查詢所有的視圖.......