?? manual_toc.html
字號(hào):
</ul>
</li>
</ul>
</li>
<li><a NAME="Compatibility" HREF="manual_Compatibility.html#Compatibility">5 MySQL 與標(biāo)準(zhǔn)的兼容性？</a><ul>
<li><a NAME="Extensions_to_ANSI" HREF="manual_Compatibility.html#Extensions_to_ANSI">5.1
MySQL對(duì)ANSI SQL92 的擴(kuò)充</a></li>
<li><a NAME="Ansi_mode" HREF="manual_Compatibility.html#Ansi_mode">5.2 以ANSI模式運(yùn)行 MySQL </a></li>
<li><a NAME="Differences_from_ANSI" HREF="manual_Compatibility.html#Differences_from_ANSI">5.3
MySQL相比ANSI SQL92的差別</a></li>
<li><a NAME="Missing_functions" HREF="manual_Compatibility.html#Missing_functions">5.4 MySQL 缺乏的功能</a><ul>
<li><a NAME="Missing_Sub-selects" HREF="manual_Compatibility.html#Missing_Sub-selects">5.4.1
子選擇(Sub-selects)</a></li>
<li><a NAME="Missing_SELECT_INTO_TABLE" HREF="manual_Compatibility.html#Missing_SELECT_INTO_TABLE">5.4.2 SELECT INTO TABLE</a></li>
<li><a NAME="Missing_Transactions" HREF="manual_Compatibility.html#Missing_Transactions">5.4.3
事務(wù)(Transactions)</a></li>
<li><a NAME="Missing_Triggers" HREF="manual_Compatibility.html#Missing_Triggers">5.4.4
存儲(chǔ)過程和觸發(fā)器</a></li>
<li><a NAME="Missing_Foreign_Keys" HREF="manual_Compatibility.html#Missing_Foreign_Keys">5.4.5
外鍵(Foreign Keys)</a><ul>
<li><a NAME="Broken_Foreign_KEY" HREF="manual_Compatibility.html#Broken_Foreign_KEY">5.4.5.1
不使用外鍵的理由</a></li>
</ul>
</li>
<li><a NAME="Missing_Views" HREF="manual_Compatibility.html#Missing_Views">5.4.6 視圖(Views)</a></li>
<li><a NAME="Missing_comments" HREF="manual_Compatibility.html#Missing_comments">5.4.7 '--'作為一個(gè)
注解的開始</a></li>
</ul>
</li>
<li><a NAME="Standards" HREF="manual_Compatibility.html#Standards">5.5 MySQL 遵循什么標(biāo)準(zhǔn)？</a></li>
<li><a NAME="Commit-rollback" HREF="manual_Compatibility.html#Commit-rollback">5.6
怎樣處理沒有提交/回卷(COMMIT / ROLLBACK)</a></li>
</ul>
</li>
<li><a NAME="Privilege_system" HREF="manual_Privilege_system.html#Privilege_system">6 MySQL 存取權(quán)限系統(tǒng)</a><ul>
<li><a NAME="What_Privileges" href="manual_Privilege_system.html#What_Privileges">6.1
權(quán)限系統(tǒng)做什么</a></li>
<li><a NAME="User_names" HREF="manual_Privilege_system.html#User_names">6.2 MySQL用戶名和口令</a></li>
<li><a NAME="Connecting" HREF="manual_Privilege_system.html#Connecting">6.3 與MySQL服務(wù)器連接</a></li>
<li><a NAME="Password_security" HREF="manual_Privilege_system.html#Password_security">6.4
使你的口令安全</a></li>
<li><a NAME="Privileges_provided" HREF="manual_Privilege_system.html#Privileges_provided">6.5
MySQL 提供的權(quán)限</a></li>
<li><a NAME="Privileges" href="manual_Privilege_system.html#Privileges">6.6
權(quán)限系統(tǒng)工作原理</a></li>
<li><a NAME="Connection_access" HREF="manual_Privilege_system.html#Connection_access">6.7
存取控制,階段1:連接證實(shí)</a></li>
<li><a NAME="Request_access" HREF="manual_Privilege_system.html#Request_access">6.8
存取控制,階段2:請(qǐng)求證實(shí)</a></li>
<li><a NAME="Privilege_changes" HREF="manual_Privilege_system.html#Privilege_changes">6.9
權(quán)限更改何時(shí)生效</a></li>
<li><a NAME="Default_privileges" HREF="manual_Privilege_system.html#Default_privileges">6.10
建立初始的 MySQL權(quán)限</a></li>
<li><a NAME="Adding_users" HREF="manual_Privilege_system.html#Adding_users">6.11 向MySQL增加新用戶權(quán)限</a></li>
<li><a NAME="Passwords" HREF="manual_Privilege_system.html#Passwords">6.12
怎樣設(shè)置口令</a></li>
<li><a NAME="Access_denied" HREF="manual_Privilege_system.html#Access_denied">6.13
存取拒絕(Access Denied)錯(cuò)誤的原因</a></li>
<li><a NAME="Security" HREF="manual_Privilege_system.html#Security">6.14 怎樣使MySQL安全以對(duì)抗解密高手(cracker)</a></li>
</ul>
</li>
<li><a NAME="Reference" HREF="manual_Reference.html#Reference">7 MySQL 語(yǔ)言參考</a><ul>
<li><a NAME="Literals" HREF="manual_Reference.html#Literals">7.1 文字:怎樣寫字符串和數(shù)字</a><ul>
<li><a NAME="String_syntax" HREF="manual_Reference.html#String_syntax">7.1.1 字符串</a></li>
<li><a NAME="Number_syntax" HREF="manual_Reference.html#Number_syntax">7.1.2 數(shù)字</a></li>
<li><a NAME="Hexadecimal_values" HREF="manual_Reference.html#Hexadecimal_values">7.1.3
十六進(jìn)制值</a></li>
<li><a NAME="NULL_values" HREF="manual_Reference.html#NULL_values">7.1.4 NULL值</a></li>
<li><a NAME="Legal_names" HREF="manual_Reference.html#Legal_names">7.1.5
數(shù)據(jù)庫(kù)，表，索引，列和別名的命名</a><ul>
<li><a NAME="Name_case_sensitivity" HREF="manual_Reference.html#Name_case_sensitivity">7.1.5.1
名字的大小寫敏感性</a></li>
</ul>
</li>
</ul>
</li>
<li><a NAME="Variables" HREF="manual_Reference.html#Variables">7.2 用戶變量</a></li>
<li><a NAME="Column_types" HREF="manual_Reference.html#Column_types">7.3 列類型</a><ul>
<li><a NAME="Storage_requirements" HREF="manual_Reference.html#Storage_requirements">7.3.1
列類型的存儲(chǔ)要求</a></li>
<li><a NAME="Numeric_types" HREF="manual_Reference.html#Numeric_types">7.3.5 數(shù)字類型</a></li>
<li><a NAME="Date_and_time_types" HREF="manual_Reference.html#Date_and_time_types">7.3.6
日期和時(shí)間類型</a><ul>
<li><a NAME="Y2K_issues" HREF="manual_Reference.html#Y2K_issues">7.3.6.1
問題和日期類型</a></li>
<li><a NAME="DATETIME" HREF="manual_Reference.html#DATETIME">7.3.6.2 DATETIME,DATE和TIMESTAMP類型</a></li>
<li><a NAME="TIME" HREF="manual_Reference.html#TIME">7.3.6.3 TIME類型</a></li>
<li><a NAME="YEAR" HREF="manual_Reference.html#YEAR">7.3.6.4 YEAR類型</a></li>
</ul>
</li>
<li><a NAME="String_types" HREF="manual_Reference.html#String_types">7.3.7 字符串類型</a><ul>
<li><a NAME="CHAR" HREF="manual_Reference.html#CHAR">7.3.7.1 CHAR和VARCHAR類型</a></li>
<li><a NAME="BLOB" HREF="manual_Reference.html#BLOB">7.3.7.2 BLOB和TEXT類型</a></li>
<li><a NAME="ENUM" HREF="manual_Reference.html#ENUM">7.3.7.3 ENUM類型</a></li>
<li><a NAME="SET" HREF="manual_Reference.html#SET">7.3.7.4 SET類型</a></li>
</ul>
</li>
<li><a NAME="Choosing_types" HREF="manual_Reference.html#Choosing_types">7.3.8
為列選擇正確的類型</a></li>
<li><a NAME="Indexes" HREF="manual_Reference.html#Indexes">7.3.9 列索引</a></li>
<li><a NAME="Multiple-column_indexes" HREF="manual_Reference.html#Multiple-column_indexes">7.3.10
多列索引</a></li>
<li><a NAME="Other-vendor_column_types" HREF="manual_Reference.html#Other-vendor_column_types">7.3.11
使用來自其他數(shù)據(jù)庫(kù)引擎的列類型</a></li>
</ul>
</li>
<li><a NAME="Functions" HREF="manual_Reference.html#Functions">7.4 用在SELECT和WHERE子句的函數(shù)</a><ul>
<li><a NAME="Grouping_functions" HREF="manual_Reference.html#Grouping_functions">7.4.1
分組函數(shù)</a></li>
<li><a NAME="Arithmetic_functions" HREF="manual_Reference.html#Arithmetic_functions">7.4.2
常用的算術(shù)運(yùn)算</a></li>
<li><a NAME="Bit_functions" HREF="manual_Reference.html#Bit_functions">7.4.3 位函數(shù)</a></li>
<li><a NAME="Logical_functions" HREF="manual_Reference.html#Logical_functions">7.4.4
邏輯運(yùn)算</a></li>
<li><a NAME="Comparison_functions" HREF="manual_Reference.html#Comparison_functions">7.4.5
比較運(yùn)算符</a></li>
<li><a NAME="String_comparison_functions" HREF="manual_Reference.html#String_comparison_functions">7.4.6 字符串比較函數(shù)</a></li>
<li><a NAME="Casts" HREF="manual_Reference.html#Casts">7.4.7 類型轉(zhuǎn)換運(yùn)算符</a></li>
<li><a NAME="Control_flow_functions" HREF="manual_Reference.html#Control_flow_functions">7.4.8
控制流函數(shù)</a></li>
<li><a NAME="Mathematical_functions" HREF="manual_Reference.html#Mathematical_functions">7.4.9
數(shù)學(xué)函數(shù)</a></li>
<li><a NAME="String_functions" HREF="manual_Reference.html#String_functions">7.4.10
字符串函數(shù)</a></li>
<li><a NAME="Date_and_time_functions" HREF="manual_Reference.html#Date_and_time_functions">7.4.11
日期和時(shí)間函數(shù)</a></li>
<li><a NAME="Miscellaneous_functions" HREF="manual_Reference.html#Miscellaneous_functions">7.4.12
其他函數(shù)</a></li>
<li><a NAME="Group_by_functions" HREF="manual_Reference.html#Group_by_functions">7.4.13 與GROUP
BY子句一起使用的函數(shù)</a></li>
</ul>
</li>
<li><a NAME="CREATE_DATABASE" HREF="manual_Reference.html#CREATE_DATABASE">7.5 CREATE
DATABASE (創(chuàng)建數(shù)據(jù)庫(kù))句法</a></li>
<li><a NAME="DROP_DATABASE" HREF="manual_Reference.html#DROP_DATABASE">7.6 DROP DATABASE (拋棄數(shù)據(jù)庫(kù))句法</a></li>
<li><a NAME="CREATE_TABLE" HREF="manual_Reference.html#CREATE_TABLE">7.7 CREATE TABLE (創(chuàng)建表)句法</a><ul>
<li><a NAME="Silent_column_changes" HREF="manual_Reference.html#Silent_column_changes">7.7.1
隱含(silent)的列指定變化</a></li>
</ul>
</li>
<li><a NAME="ALTER_TABLE" HREF="manual_Reference.html#ALTER_TABLE">7.8 ALTER TABLE (改變表)句法</a></li>
<li><a NAME="OPTIMIZE_TABLE" HREF="manual_Reference.html#OPTIMIZE_TABLE">7.9 OPTIMIZE TABLE
(優(yōu)化表) 句法</a></li>
<li><a NAME="DROP_TABLE" HREF="manual_Reference.html#DROP_TABLE">7.10 DROP TABLE (拋棄表)句法</a></li>
<li><a NAME="DELETE" HREF="manual_Reference.html#DELETE">7.11 DELETE (刪除)句法</a></li>
<li><a NAME="SELECT" HREF="manual_Reference.html#SELECT">7.12 SELECT (精選)句法</a></li>
<li><a NAME="JOIN" HREF="manual_Reference.html#JOIN">7.13 JOIN (聯(lián)接)句法</a></li>
<li><a NAME="INSERT" HREF="manual_Reference.html#INSERT">7.14 INSERT (插入)句法</a></li>
<li><a NAME="REPLACE" HREF="manual_Reference.html#REPLACE">7.15 REPLACE (替換)句法</a></li>
<li><a NAME="LOAD_DATA" HREF="manual_Reference.html#LOAD_DATA">7.16 LOAD DATA INFILE (裝載數(shù)據(jù)到文件)句法</a></li>
<li><a NAME="UPDATE" HREF="manual_Reference.html#UPDATE">7.17 UPDATE (更新)句法</a></li>
<li><a NAME="USE" HREF="manual_Reference.html#USE">7.18 USE (使用)句法</a></li>
<li><a NAME="FLUSH" HREF="manual_Reference.html#FLUSH">7.19 FLUSH (清除緩存）句法</a></li>
<li><a NAME="KILL" HREF="manual_Reference.html#KILL">7.20 KILL (殺滅)句法</a></li>
<li><a NAME="SHOW" HREF="manual_Reference.html#SHOW">7.21 SHOW (顯示)句法(得到關(guān)于表,列等的信息）</a></li>
<li><a NAME="EXPLAIN" HREF="manual_Reference.html#EXPLAIN">7.22 EXPLAIN (解釋)句法(得到關(guān)于SELECT的信息)</a></li>
<li><a NAME="DESCRIBE" HREF="manual_Reference.html#DESCRIBE">7.23 DESCRIBE (描述)句法(得到列的信息）</a></li>
<li><a NAME="LOCK_TABLES" HREF="manual_Reference.html#LOCK_TABLES">7.24 LOCK TABLES/UNLOCK
TABLES (鎖定表/解鎖表)句法</a></li>
<li><a NAME="SET_OPTION" HREF="manual_Reference.html#SET_OPTION">7.25 SET OPTION (設(shè)置選項(xiàng))句法</a></li>
<li><a NAME="GRANT" HREF="manual_Reference.html#GRANT">7.26 GRANT (授權(quán))和REVOKE (撤回)句法</a></li>
<li><a NAME="CREATE_INDEX" HREF="manual_Reference.html#CREATE_INDEX">7.27 CREATE INDEX (創(chuàng)建索引)句法</a></li>
<li><a NAME="DROP_INDEX" HREF="manual_Reference.html#DROP_INDEX">7.28 DROP INDEX (拋棄索引)句法</a></li>
<li><a NAME="Comments" HREF="manual_Reference.html#Comments">7.29 注釋句法</a></li>
<li><a NAME="CREATE_FUNCTION" HREF="manual_Reference.html#CREATE_FUNCTION">7.30 CREATE
FUNCTION/DROP FUNCTION (創(chuàng)建函數(shù)/拋棄函數(shù))句法</a></li>
<li><a NAME="Reserved_words" HREF="manual_Reference.html#Reserved_words">7.31 MySQL對(duì)保留字很挑剔嗎？</a></li>
</ul>
</li>
<li><a NAME="Tutorial" HREF="manual_Tutorial.html#Tutorial">8 MySQL 教程</a><ul>
<li><a NAME="Connecting-disconnecting" HREF="manual_Tutorial.html#Connecting-disconnecting">8.1
聯(lián)接和斷開服務(wù)器</a></li>
<li><a NAME="Entering_queries" HREF="manual_Tutorial.html#Entering_queries">8.2 輸入查詢</a></li>
<li><a NAME="Examples" HREF="manual_Tutorial.html#Examples">8.3 常用查詢的例子</a><ul>
<li><a NAME="example-Maximum-column" HREF="manual_Tutorial.html#example-Maximum-column">8.3.1
列的最大值</a></li>
<li><a NAME="example-Maximum-row" HREF="manual_Tutorial.html#example-Maximum-row">8.3.2
擁有某個(gè)列的最大值的行</a></li>
<li><a NAME="example-Maximum-column-group" HREF="manual_Tutorial.html#example-Maximum-column-group">8.3.3 列的最大值:按組:只有值</a></li>
<li><a NAME="example-Maximum-column-group-row" HREF="manual_Tutorial.html#example-Maximum-column-group-row">8.3.4
擁有某個(gè)字段的組間最大值的行</a></li>
<li><a NAME="example-Foreign_keys" HREF="manual_Tutorial.html#example-Foreign_keys">8.3.5
使用外鍵</a></li>
</ul>
</li>
<li><a NAME="Database_use" HREF="manual_Tutorial.html#Database_use">8.4
創(chuàng)建并使用一個(gè)數(shù)據(jù)庫(kù)</a><ul>
<li><a NAME="Creating_database" HREF="manual_Tutorial.html#Creating_database">8.4.1
創(chuàng)建并選用一個(gè)數(shù)據(jù)庫(kù)</a></li>
<li><a NAME="Creating_tables" HREF="manual_Tutorial.html#Creating_tables">8.4.2
創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)表</a></li>
<li><a NAME="Loading_tables" HREF="manual_Tutorial.html#Loading_tables">8.4.3
將數(shù)據(jù)裝入數(shù)據(jù)庫(kù)表</a></li>
<li><a NAME="Retrieving_data" HREF="manual_Tutorial.html#Retrieving_data">8.4.4
從一個(gè)數(shù)據(jù)庫(kù)表檢索信息</a><ul>
<li><a NAME="Selecting_all" HREF="manual_Tutorial.html#Selecting_all">8.4.4.1
選擇所有數(shù)據(jù)</a></li>
<li><a NAME="Selecting_rows" HREF="manual_Tutorial.html#Selecting_rows">8.4.4.2
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -