站内搜索: 请输入搜索关键词
当前页面: 在线文档首页 > MySQL 5.1参考手册中文版

Index - MySQL 5.1参考手册中文版

绱㈠紩

绗﹀彿

! (logical NOT)锛�閫昏緫鎿嶄綔绗�
!= (not equal)锛�姣旇緝鍑芥暟鍜屾搷浣滅
"锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
% (modulo)锛�鏁板鍑芥暟
% (wildcard character)锛�瀛楃涓�
& (bitwise AND)锛�浣嶅嚱鏁�
&& (logical AND)锛�閫昏緫鎿嶄綔绗�
() (parentheses)锛�鍦嗘嫭鍙�
(Control-Z) \Z锛�瀛楃涓�
* (multiplication)锛�绠楁湳鎿嶄綔绗�
+ (addition)锛�绠楁湳鎿嶄綔绗�
- (subtraction)锛�绠楁湳鎿嶄綔绗�
- (unary minus)锛�绠楁湳鎿嶄綔绗�
--password option锛�浣夸綘鐨勫瘑鐮佸畨鍏�
-p option锛�浣夸綘鐨勫瘑鐮佸畨鍏�
.my.cnf file锛�浣跨敤閫夐」鏂囦欢锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�锛�鎷掔粷璁块棶閿欒鐨勫師鍥�锛�浣夸綘鐨勫瘑鐮佸畨鍏�锛�鍦ㄥ鏈嶅姟鍣ㄧ幆澧冧腑浣跨敤瀹㈡埛绔▼搴�
.mysql_history file锛�閫夐」
.pid (process ID) file锛�寤虹珛琛ㄧ淮鎶よ鍒�
/ (division)锛�绠楁湳鎿嶄綔绗�
/etc/passwd锛�浣縈ySQL鍦ㄦ敾鍑昏�呴潰鍓嶄繚鎸佸畨鍏�锛�SELECT璇硶
< (less than)锛�姣旇緝鍑芥暟鍜屾搷浣滅
<<锛�鏍规嵁澶╄绠楄闂噺
<< (left shift)锛�浣嶅嚱鏁�
<= (less than or equal)锛�姣旇緝鍑芥暟鍜屾搷浣滅
<=> (equal to)锛�姣旇緝鍑芥暟鍜屾搷浣滅
<> (not equal)锛�姣旇緝鍑芥暟鍜屾搷浣滅
= (equal)锛�姣旇緝鍑芥暟鍜屾搷浣滅
> (greater than)锛�姣旇緝鍑芥暟鍜屾搷浣滅
>= (greater than or equal)锛�姣旇緝鍑芥暟鍜屾搷浣滅
>> (right shift)锛�浣嶅嚱鏁�
\" (double quote)锛�瀛楃涓�
\' (single quote)锛�瀛楃涓�
\0 (ASCII 0)锛�瀛楃涓�
\b (backspace)锛�瀛楃涓�
\n (linefeed)锛�瀛楃涓�
\n (newline)锛�瀛楃涓�
\r (carriage return)锛�瀛楃涓�
\t (tab)锛�瀛楃涓�
\Z (Control-Z) ASCII 26锛�瀛楃涓�
\\ (escape)锛�瀛楃涓�
^ (bitwise XOR)锛�浣嶅嚱鏁�
_ (wildcard character)锛�瀛楃涓�
`锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
| (bitwise OR)锛�浣嶅嚱鏁�
|| (logical OR)锛�閫昏緫鎿嶄綔绗�
~锛�浣嶅嚱鏁�

A

aborted clients锛�閫氫俊閿欒鍜屽け鏁堣繛鎺�
aborted connection锛�閫氫俊閿欒鍜屽け鏁堣繛鎺�
ABS()锛�鏁板鍑芥暟
access control锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
access denied errors锛�鎷掔粷璁块棶
access privileges锛�MySQL璁块棶鏉冮檺绯荤粺
Access program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
account privileges
adding锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
accounts
anonymous user锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
root锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
ACID锛�浜嬪姟鍜屽師瀛愭搷浣�锛�InnoDB姒傝堪
ACLs锛�MySQL璁块棶鏉冮檺绯荤粺
ACOS()锛�鏁板鍑芥暟
ActiveState Perl锛�鍦╓indows涓嬪畨瑁匒ctiveState Perl
ADDDATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
adding
character sets锛�娣诲姞鏂扮殑瀛楃闆�
native functions锛�娣诲姞鏂扮殑鍥烘湁鍑芥暟
new account privileges锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
new functions锛�涓篗ySQL娣诲姞鏂板嚱鏁�
new user privileges锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
new users锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL锛�婧愮爜瀹夎姒傝堪
procedures锛�涓篗ySQL娣诲姞鏂版楠�
user-defined functions锛�娣诲姞鏂扮殑鑷畾涔夊嚱鏁�
addition (+)锛�绠楁湳鎿嶄綔绗�
ADDTIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
ADO program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
AES_DECRYPT()锛�鍔犲瘑鍑芥暟
AES_ENCRYPT()锛�鍔犲瘑鍑芥暟
age
calculating锛�鏃ユ湡璁＄畻
alias锛�涓庡垪鍒悕鏈夊叧鐨勯棶棰�
alias names
case sensitivity锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
aliases
for expressions锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY
for tables锛�SELECT璇硶
in GROUP BY clauses锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY
in ORDER BY clauses锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY
names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
on expressions锛�SELECT璇硶
ALL锛�SELECT璇硶
ALLOW_INVALID_DATES SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
ALTER COLUMN锛�ALTER TABLE璇硶
ALTER DATABASE锛�ALTER DATABASE璇硶
ALTER FUNCTION锛�ALTER PROCEDURE鍜孉LTER FUNCTION
ALTER PROCEDURE锛�ALTER PROCEDURE鍜孉LTER FUNCTION
ALTER SCHEMA锛�ALTER DATABASE璇硶
ALTER TABLE锛�ALTER TABLE璇硶锛�涓嶢LTER TABLE鏈夊叧鐨勯棶棰�
ALTER VIEW锛�ALTER VIEW璇硶
altering
database锛�ALTER DATABASE璇硶
schema锛�ALTER DATABASE璇硶
ANALYZE TABLE锛�ANALYZE TABLE璇硶
AND
bitwise锛�浣嶅嚱鏁�
logical锛�閫昏緫鎿嶄綔绗�
anonymous user锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
ANSI mode
running锛�鍦ˋNSI妯″紡涓嬭繍琛孧ySQL
ANSI SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
ANSI_QUOTES SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
answering questions
etiquette锛�鍦ㄩ偖浠跺垪琛ㄤ笂鍥炵瓟闂鐨勬寚鍗�
Apache锛�涓嶢pache涓�璧蜂娇鐢∕ySQL
API's
list of锛�鏀寔MySQL鐨勮蒋浠跺寘
APIs锛�API鍜屽簱
Perl锛�MySQL Perl API
approximate-value literals锛�绮惧害鏁板
ARCHIVE storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�ARCHIVE瀛樺偍寮曟搸
ARCHIVE table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�ARCHIVE瀛樺偍寮曟搸
Area()锛�Polygon鍑芥暟锛�MultiPolygon鍑芥暟
argument processing锛�UDF鍙傞噺澶勭悊
arithmetic expressions锛�绠楁湳鎿嶄綔绗�
arithmetic functions锛�浣嶅嚱鏁�
AS锛�SELECT璇硶锛�JOIN璇硶
AsBinary()锛�Geometry鏍煎紡杞崲鍑芥暟
ASCII()锛�瀛楃涓插嚱鏁�
ASIN()锛�鏁板鍑芥暟
AsText()锛�Geometry鏍煎紡杞崲鍑芥暟
ATAN()锛�鏁板鍑芥暟
ATAN2()锛�鏁板鍑芥暟
attackers
security against锛�浣縈ySQL鍦ㄦ敾鍑昏�呴潰鍓嶄繚鎸佸畨鍏�
AUTO-INCREMENT
ODBC锛�濡備綍鍦∣DBC涓幏鍙朅UTO_INCREMENT鍒楃殑鍊�
AUTO_INCREMENT锛�浣跨敤AUTO_INCREMENT
and NULL values锛�涓嶯ULL鍊兼湁鍏崇殑闂
AVG()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
AVG(DISTINCT)锛�GROUP BY锛堣仛鍚堬級鍑芥暟

B

backslash
escape character锛�鏂囧瓧鍊�
backspace (\b)锛�瀛楃涓�
BACKUP TABLE锛�BACKUP TABLE璇硶
backups锛�鏁版嵁搴撳浠�
database锛�BACKUP TABLE璇硶
batch
mysql option锛�閫夐」
batch mode锛�鍦ㄦ壒澶勭悊妯″紡涓嬩娇鐢╩ysql
BDB storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�BDB (BerkeleyDB)瀛樺偍寮曟搸
BDB table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�BDB (BerkeleyDB)瀛樺偍寮曟搸
BDB tables锛�浜嬪姟鍜屽師瀛愭搷浣�
BdMPolyFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
BdMPolyFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
BdPolyFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
BdPolyFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
BEGIN锛�START TRANSACTION锛孋OMMIT鍜孯OLLBACK璇硶锛�BEGIN ... END澶嶅悎璇彞
XA transactions锛�XA浜嬪姟SQL璇硶
benchmark suite锛�MySQL鍩哄噯濂椾欢
BENCHMARK()锛�淇℃伅鍑芥暟
benchmarks锛�浣跨敤鑷繁鐨勫熀鍑�
BerkeleyDB storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�BDB (BerkeleyDB)瀛樺偍寮曟搸
BerkeleyDB table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�BDB (BerkeleyDB)瀛樺偍寮曟搸
BETWEEN ... AND锛�姣旇緝鍑芥暟鍜屾搷浣滅
Big5 Chinese character encoding锛�鎼滅储涓殑澶у皬鍐欐晱鎰熸��
BIGINT data type锛�鏁板�肩被鍨嬫杩�
BIN()锛�瀛楃涓插嚱鏁�
BINARY锛�Cast鍑芥暟鍜屾搷浣滅
BINARY data type锛�瀛楃涓茬被鍨嬫杩�锛�BINARY鍜孷ARBINARY绫诲瀷
binary distributions锛�MySQL AB缂栬瘧鐨凪ySQL浜岃繘鍒剁増鏈�
installing锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL
on Linux锛�Linux浜岃繘鍒跺垎鍙戠増璇存槑
binary log锛�浜岃繘鍒舵棩蹇�
BIT data type锛�鏁板�肩被鍨嬫杩�
BitKeeper tree锛�浠庡紑鍙戞簮鐮佹爲瀹夎
BIT_AND()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
BIT_COUNT锛�鏍规嵁澶╄绠楄闂噺
BIT_COUNT()锛�浣嶅嚱鏁�
bit_functions
example锛�鏍规嵁澶╄绠楄闂噺
BIT_LENGTH()锛�瀛楃涓插嚱鏁�
BIT_OR锛�鏍规嵁澶╄绠楄闂噺
BIT_OR()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
BIT_XOR()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
BLACKHOLE storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�BLACKHOLE瀛樺偍寮曟搸
BLACKHOLE table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�BLACKHOLE瀛樺偍寮曟搸
BLOB
inserting binary data锛�瀛楃涓�
size锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
BLOB columns
default values锛�BLOB鍜孴EXT绫诲瀷
indexing锛�鍒楃储寮�锛�CREATE TABLE璇硶
BLOB data type锛�瀛楃涓茬被鍨嬫杩�锛�BLOB鍜孴EXT绫诲瀷
BOOL data type锛�鏁板�肩被鍨嬫杩�
BOOLEAN data type锛�鏁板�肩被鍨嬫杩�
Borland Builder 4 program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
Borland C++ compiler锛�Borland C++
Boundary()锛�閫氱敤鍑犱綍鍑芥暟
brackets
square锛�鍒楃被鍨�
buffer sizes
client锛�API鍜屽簱
mysqld server锛�璋冭妭鏈嶅姟鍣ㄥ弬鏁�
Buffer()锛�Spatial 鎿嶄綔绗�
bug reports
criteria for锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
bugs
known锛�MySQL涓殑宸茬煡浜嬪疁
reporting锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
bugs database锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
bugs.mysql.com锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
building
client programs锛�鍒涘缓瀹㈡埛绔▼搴�

C

C API
data types锛�MySQL C API
functions锛�C API鍑芥暟姒傝堪
linking problems锛�涓嶤 API鏈夊叧鐨勯棶棰�
C Prepared statement API
functions锛�C API棰勫鐞嗚鍙ュ嚱鏁版杩�
C++ APIs锛�MySQL C++ API
C++ Builder锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
C++ compiler
gcc锛�鍏稿瀷閰嶇疆閫夐」
C++ compiler cannot create executables锛�澶勭悊MySQL缂栬瘧闂
C:\my.cnf file锛�鍦ㄥ鏈嶅姟鍣ㄧ幆澧冧腑浣跨敤瀹㈡埛绔▼搴�
CACHE INDEX锛�CACHE INDEX璇硶
caches
clearing锛�FLUSH Syntax
calculating
dates锛�鏃ユ湡璁＄畻
calendar锛�MySQL浣跨敤浠�涔堟棩鍘嗭紵
CALL锛�CALL璇彞
calling sequences for aggregate functions
UDF锛�瀵逛簬鑱氬悎鍑芥暟鐨刄DF璋冪敤椤哄簭
calling sequences for simple functions
UDF锛�瀵逛簬绠�鍗曞嚱鏁扮殑UDF璋冪敤椤哄簭
can't create/write to file锛�鏃犳硶鍒涘缓鏂囦欢锛忓啓鍏ユ枃浠�
carriage return (\r)锛�瀛楃涓�
CASE锛�鎺у埗娴佺▼鍑芥暟锛�CASE璇彞
case sensitivity
in identifiers锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
in names锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
in searches锛�鎼滅储涓殑澶у皬鍐欐晱鎰熸��
in string comparisons锛�瀛楃涓叉瘮杈冨嚱鏁�
case-sensitivity
in access checking锛�鏉冮檺绯荤粺宸ヤ綔鍘熺悊
of database names锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�
of table names锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�
CAST锛�Cast鍑芥暟鍜屾搷浣滅
cast functions锛�Cast鍑芥暟鍜屾搷浣滅
cast operators锛�Cast鍑芥暟鍜屾搷浣滅
casts锛�姣旇緝鍑芥暟鍜屾搷浣滅锛�Cast鍑芥暟鍜屾搷浣滅
CC environment variable锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂锛�鐜鍙橀噺
cc1plus problems锛�澶勭悊MySQL缂栬瘧闂
CEILING()锛�鏁板鍑芥暟
Centroid()锛�MultiPolygon鍑芥暟
CFLAGS environment variable锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂锛�鐜鍙橀噺
CHANGE MASTER TO锛�CHANGE MASTER TO璇硶
ChangeLog锛�MySQL鍙樻洿鍙�
changes
log锛�MySQL鍙樻洿鍙�
MySQL 5.1锛�5.1.x鐗堜腑鐨勫彉鏇存儏鍐碉紙寮�鍙戯級
changes to privileges锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
changing
column锛�ALTER TABLE璇硶
column order锛�濡備綍鏇存敼琛ㄤ腑鐨勫垪椤哄簭
field锛�ALTER TABLE璇硶
table锛�ALTER TABLE璇硶锛�涓嶢LTER TABLE鏈夊叧鐨勯棶棰�
changing socket location锛�鍏稿瀷閰嶇疆閫夐」锛�鑷姩鍚姩鍜屽仠姝ySQL锛�濡備綍淇濇姢鎴栨洿鏀筂ySQL濂楁帴瀛楁枃浠�/tmp/mysql.sock
CHAR data type锛�瀛楃涓茬被鍨嬫杩�锛�String绫诲瀷
CHAR VARYING data type锛�瀛楃涓茬被鍨嬫杩�
CHAR()锛�瀛楃涓插嚱鏁�
CHARACTER data type锛�瀛楃涓茬被鍨嬫杩�
character sets锛�鍏稿瀷閰嶇疆閫夐」锛�鏁版嵁鍜屾帓搴忕敤瀛楃闆�
adding锛�娣诲姞鏂扮殑瀛楃闆�
Character sets锛�瀛楃闆嗘敮鎸�
CHARACTER VARYING data type锛�瀛楃涓茬被鍨嬫杩�
character-sets-dir
mysql option锛�閫夐」
characters
multi-byte锛�澶氬瓧鑺傚瓧绗︽敮鎸�
CHARACTER_LENGTH()锛�瀛楃涓插嚱鏁�
CHARACTER_SETS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA CHARACTER_SETS琛�
CHARSET()锛�淇℃伅鍑芥暟
CHAR_LENGTH()锛�瀛楃涓插嚱鏁�
check options
myisamchk锛�鐢ㄤ簬myisamchk鐨勬鏌ラ�夐」
CHECK TABLE锛�CHECK TABLE璇硶
checking
tables for errors锛�濡備綍妫�鏌yISAM琛ㄧ殑閿欒
checksum errors锛�Solaris娉ㄦ剰浜嬮」
CHECKSUM TABLE锛�CHECKSUM TABLE璇硶
Chinese锛�鎼滅储涓殑澶у皬鍐欐晱鎰熸��
choosing
a MySQL version锛�閫夋嫨瑕佸畨瑁呯殑MySQL鍒嗗彂鐗�
choosing types锛�閫夋嫨姝ｇ‘鐨勫垪绫诲瀷
clearing
caches锛�FLUSH Syntax
client programs
building锛�鍒涘缓瀹㈡埛绔▼搴�
client tools锛�API鍜屽簱
clients
debugging锛�璋冭瘯MySQL瀹㈡埛绔�
threaded锛�濡備綍鐢熸垚绾跨▼寮忓鎴风
CLOSE锛�Cursor CLOSE Statement
closing
tables锛�MySQL濡備綍鎵撳紑鍜屽叧闂〃
COALESCE()锛�姣旇緝鍑芥暟鍜屾搷浣滅
COERCIBILITY()锛�淇℃伅鍑芥暟
ColdFusion program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
collating
strings锛�瀛楃涓叉瘮杈冩敮鎸�
COLLATION()锛�淇℃伅鍑芥暟
COLLATIONS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA COLLATIONS琛�
COLLATION_CHARACTER_SET_APPLICABILITY
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY琛�
column
changing锛�ALTER TABLE璇硶
column comments锛�CREATE TABLE璇硶
column names
case sensitivity锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
columns
changing锛�濡備綍鏇存敼琛ㄤ腑鐨勫垪椤哄簭
indexes锛�鍒楃储寮�
names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
other types锛�浣跨敤鏉ヨ嚜鍏朵粬鏁版嵁搴撳紩鎿庣殑鍒楃被鍨�
selecting锛�閫夋嫨鐗规畩鍒�
storage requirements锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
types锛�鍒楃被鍨�
COLUMNS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA COLUMNS琛�
COLUMN_PRIVILEGES
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA COLUMN_PRIVILEGES琛�
command syntax锛�鏈墜鍐岄噰鐢ㄧ殑鎯緥
command-line history
mysql锛�閫夐」
command-line options锛�mysqld鍛戒护琛岄�夐」
mysql锛�閫夐」
mysqladmin锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
commands
for binary distribution锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL
replication masters锛�鐢ㄤ簬鎺у埗涓绘湇鍔″櫒鐨凷QL璇彞
replication slaves锛�鐢ㄤ簬鎺у埗浠庢湇鍔″櫒鐨凷QL璇彞
commands out of sync锛�鍛戒护涓嶅悓姝�
Comment syntax锛�娉ㄩ噴璇硶
comments
adding锛�娉ㄩ噴璇硶
starting锛�鈥�--鈥欎綔涓烘敞閲婅捣濮嬫爣璁�
COMMIT锛�浜嬪姟鍜屽師瀛愭搷浣�锛�START TRANSACTION锛孋OMMIT鍜孯OLLBACK璇硶
XA transactions锛�XA浜嬪姟SQL璇硶
comparison operators锛�姣旇緝鍑芥暟鍜屾搷浣滅
compatibility
with mSQL锛�瀛楃涓叉瘮杈冨嚱鏁�
with ODBC锛�璇嗗埆绗﹂檺鍒舵潯浠�锛�鏁板�肩被鍨嬫杩�锛�姣旇緝鍑芥暟鍜屾搷浣滅锛�CREATE TABLE璇硶锛�JOIN璇硶
with Oracle锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�锛�GROUP BY锛堣仛鍚堬級鍑芥暟锛�DESCRIBE璇硶锛堣幏鍙栨湁鍏冲垪鐨勪俊鎭級
with PostgreSQL锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�
with standard SQL锛�MySQL鏍囧噯鐨勫吋瀹规��
with Sybase锛�USE璇硶
compiler
C++ gcc锛�鍏稿瀷閰嶇疆閫夐」
compiling
on Windows锛�鍦╓indows涓嬬紪璇慚ySQL瀹㈡埛绔�
optimizing锛�绯荤粺鍥犵礌鍜屽惎鍔ㄥ弬鏁扮殑璋冭妭
problems锛�澶勭悊MySQL缂栬瘧闂
speed锛�缂栬瘧鍜岄摼鎺ユ�庢牱褰卞搷MySQL鐨勯�熷害
statically锛�鍏稿瀷閰嶇疆閫夐」
user-defined functions锛�缂栬瘧鍜屽畨瑁呯敤鎴峰畾涔夌殑鍑芥暟
compliance
Y2K锛�2000骞村吋瀹规��
composite subpartitioning锛�瀛愬垎鍖�
compress
mysql option锛�閫夐」
COMPRESS()锛�瀛楃涓插嚱鏁�
compressed tables锛�鍘嬬缉琛ㄧ壒鎬�
CONCAT()锛�瀛楃涓插嚱鏁�
CONCAT_WS()锛�瀛楃涓插嚱鏁�
concurrent inserts锛�閿佸畾鏂规硶
Conditions锛�DECLARE鏉′欢
config-file
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
config.cache锛�澶勭悊MySQL缂栬瘧闂
config.cache file锛�澶勭悊MySQL缂栬瘧闂
configuration files锛�鎷掔粷璁块棶閿欒鐨勫師鍥�
configuration options锛�鍏稿瀷閰嶇疆閫夐」
configure
running after prior invocation锛�澶勭悊MySQL缂栬瘧闂
configure option
--with-charset锛�鍏稿瀷閰嶇疆閫夐」
--with-collation锛�鍏稿瀷閰嶇疆閫夐」
--with-extra-charsets锛�鍏稿瀷閰嶇疆閫夐」
--with-low-memory锛�澶勭悊MySQL缂栬瘧闂
configure script锛�鍏稿瀷閰嶇疆閫夐」
connecting
remotely with SSH锛�鐢⊿SH浠ヨ繙绋嬫柟寮忎粠Windows杩炴帴鍒癕ySQL
to the server锛�杩炴帴涓庢柇寮�鏈嶅姟鍣�锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�
verification锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
connection
aborted锛�閫氫俊閿欒鍜屽け鏁堣繛鎺�
CONNECTION_ID()锛�淇℃伅鍑芥暟
Connector/JDBC锛�杩炴帴鍣�
Connector/ODBC锛�杩炴帴鍣�锛�MySQL Connector/ODBC
reporting problems锛�濡備綍閫氭姤MyODBC闂鎴栫己闄�
杩炴帴鍣�
MySQL锛�杩炴帴鍣�
connect_timeout variable锛�閫夐」锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
constant table锛�EXPLAIN璇硶锛堣幏鍙栧叧浜嶴ELECT鐨勪俊鎭級锛�MySQL鎬庢牱浼樺寲WHERE瀛愬彞
constraints锛�MySQL澶勭悊绾︽潫鐨勬柟寮�
CONSTRAINTS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA TABLE_CONSTRAINTS琛�
Contains()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
contributing companies
list of锛�MySQL鏀寔浜哄憳
contributors
list of锛�MySQL璐＄尞浜�
control access锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
control flow functions锛�鎺у埗娴佺▼鍑芥暟
CONV()锛�瀛楃涓插嚱鏁�
conventions
typographical锛�鏈墜鍐岄噰鐢ㄧ殑鎯緥
CONVERT锛�Cast鍑芥暟鍜屾搷浣滅
CONVERT TO锛�ALTER TABLE璇硶
CONVERT_TZ()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
ConvexHull()锛�Spatial 鎿嶄綔绗�
copying databases锛�灏哅ySQL鏁版嵁搴撴嫹璐濆埌鍙︿竴鍙版満鍣�
copying tables锛�CREATE TABLE璇硶
COS()锛�鏁板鍑芥暟
COT()锛�鏁板鍑芥暟
COUNT()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
COUNT(DISTINCT)锛�GROUP BY锛堣仛鍚堬級鍑芥暟
counting
table rows锛�璁℃暟琛�
crash锛�璋冭瘯MySQL鏈嶅姟鍣�
recovery锛�灏唌yisamchk鐢ㄤ簬宕╂簝鎭㈠
repeated锛�濡傛灉MySQL渚濈劧宕╂簝锛屽簲浣滀簺浠�涔�
crash-me锛�MySQL鍩哄噯濂椾欢
crash-me program锛�涓哄彲绉绘鎬ц璁″簲鐢ㄧ▼搴�锛�MySQL鍩哄噯濂椾欢
CRC32()锛�鏁板鍑芥暟
CREATE DATABASE锛�CREATE DATABASE璇硶
CREATE FUNCTION锛�CREATE PROCEDURE鍜孋REATE FUNCTION锛�CREATE FUNCTION/DROP FUNCTION璇硶
CREATE INDEX锛�CREATE INDEX璇硶
CREATE PROCEDURE锛�CREATE PROCEDURE鍜孋REATE FUNCTION
CREATE SCHEMA锛�CREATE DATABASE璇硶
CREATE TABLE锛�CREATE TABLE璇硶
CREATE USER锛�CREATE USER璇硶
CREATE VIEW锛�CREATE VIEW璇硶
creating
bug reports锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
database锛�CREATE DATABASE璇硶
databases锛�鍒涘缓骞朵娇鐢ㄦ暟鎹簱
default startup options锛�浣跨敤閫夐」鏂囦欢
schema锛�CREATE DATABASE璇硶
tables锛�鍒涘缓琛�
creating user accounts锛�CREATE USER璇硶
CROSS JOIN锛�JOIN璇硶
Crosses()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
CR_SERVER_GONE_ERROR锛�MySQL鏈嶅姟鍣ㄤ笉鍙敤
CR_SERVER_LOST_ERROR锛�MySQL鏈嶅姟鍣ㄤ笉鍙敤
CSV storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�CSV瀛樺偍寮曟搸
CSV table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�CSV瀛樺偍寮曟搸
CURDATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
CURRENT_DATE锛�鏃ユ湡鍜屾椂闂村嚱鏁�
CURRENT_TIME锛�鏃ユ湡鍜屾椂闂村嚱鏁�
CURRENT_TIMESTAMP锛�鏃ユ湡鍜屾椂闂村嚱鏁�
CURRENT_USER()锛�淇℃伅鍑芥暟
鍏夋爣锛�鍏夋爣
CURTIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
customer support
mailing address锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
customers
of MySQL锛�鎴戜滑宸插皢MySQL鐢ㄥ湪浣曞锛�
CXX environment variable锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂锛�鐜鍙橀噺
CXXFLAGS environment variable锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂锛�鐜鍙橀噺

D

data
character sets锛�鏁版嵁鍜屾帓搴忕敤瀛楃闆�
loading into tables锛�灏嗘暟鎹鍏ヨ〃涓�
retrieving锛�浠庤〃妫�绱俊鎭�
size锛�浣夸綘鐨勬暟鎹敖鍙兘灏�
data type
BIGINT锛�鏁板�肩被鍨嬫杩�
BINARY锛�瀛楃涓茬被鍨嬫杩�锛�BINARY鍜孷ARBINARY绫诲瀷
BIT锛�鏁板�肩被鍨嬫杩�
BLOB锛�瀛楃涓茬被鍨嬫杩�锛�BLOB鍜孴EXT绫诲瀷
BOOL锛�鏁板�肩被鍨嬫杩�锛�浣跨敤鏉ヨ嚜鍏朵粬鏁版嵁搴撳紩鎿庣殑鍒楃被鍨�
BOOLEAN锛�鏁板�肩被鍨嬫杩�锛�浣跨敤鏉ヨ嚜鍏朵粬鏁版嵁搴撳紩鎿庣殑鍒楃被鍨�
CHAR锛�瀛楃涓茬被鍨嬫杩�锛�String绫诲瀷
CHAR VARYING锛�瀛楃涓茬被鍨嬫杩�
CHARACTER锛�瀛楃涓茬被鍨嬫杩�
CHARACTER VARYING锛�瀛楃涓茬被鍨嬫杩�
DATE锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
DATETIME锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
DEC锛�鏁板�肩被鍨嬫杩�
DECIMAL锛�鏁板�肩被鍨嬫杩�锛�绮惧害鏁板
DOUBLE锛�鏁板�肩被鍨嬫杩�
DOUBLE PRECISION锛�鏁板�肩被鍨嬫杩�
ENUM锛�瀛楃涓茬被鍨嬫杩�锛�ENUM绫诲瀷
FIXED锛�鏁板�肩被鍨嬫杩�
FLOAT锛�鏁板�肩被鍨嬫杩�
GEOMETRY锛�MySQL绌洪棿鏁版嵁绫诲瀷
GEOMETRYCOLLECTION锛�MySQL绌洪棿鏁版嵁绫诲瀷
INT锛�鏁板�肩被鍨嬫杩�
INTEGER锛�鏁板�肩被鍨嬫杩�
LINESTRING锛�MySQL绌洪棿鏁版嵁绫诲瀷
LONG锛�BLOB鍜孴EXT绫诲瀷
LONGBLOB锛�瀛楃涓茬被鍨嬫杩�
LONGTEXT锛�瀛楃涓茬被鍨嬫杩�
MEDIUMBLOB锛�瀛楃涓茬被鍨嬫杩�
MEDIUMINT锛�鏁板�肩被鍨嬫杩�
MEDIUMTEXT锛�瀛楃涓茬被鍨嬫杩�
MULTILINESTRING锛�MySQL绌洪棿鏁版嵁绫诲瀷
MULTIPOINT锛�MySQL绌洪棿鏁版嵁绫诲瀷
MULTIPOLYGON锛�MySQL绌洪棿鏁版嵁绫诲瀷
NATIONAL CHAR锛�瀛楃涓茬被鍨嬫杩�
NCHAR锛�瀛楃涓茬被鍨嬫杩�
NUMERIC锛�鏁板�肩被鍨嬫杩�
POINT锛�MySQL绌洪棿鏁版嵁绫诲瀷
POLYGON锛�MySQL绌洪棿鏁版嵁绫诲瀷
REAL锛�鏁板�肩被鍨嬫杩�
SET锛�瀛楃涓茬被鍨嬫杩�锛�SET绫诲瀷
SMALLINT锛�鏁板�肩被鍨嬫杩�
TEXT锛�瀛楃涓茬被鍨嬫杩�锛�BLOB鍜孴EXT绫诲瀷
TIME锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�TIME绫诲瀷
TIMESTAMP锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
TINYBLOB锛�瀛楃涓茬被鍨嬫杩�
TINYINT锛�鏁板�肩被鍨嬫杩�
TINYTEXT锛�瀛楃涓茬被鍨嬫杩�
VARBINARY锛�瀛楃涓茬被鍨嬫杩�锛�BINARY鍜孷ARBINARY绫诲瀷
VARCHAR锛�瀛楃涓茬被鍨嬫杩�锛�String绫诲瀷
VARCHARACTER锛�瀛楃涓茬被鍨嬫杩�
YEAR锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�YEAR绫诲瀷
data types锛�鍒楃被鍨�
C API锛�MySQL C API
overview锛�鍒楃被鍨嬫杩�
database
altering锛�ALTER DATABASE璇硶
creating锛�CREATE DATABASE璇硶
deleting锛�DROP DATABASE璇硶
mysql option锛�閫夐」
database design锛�璁捐閫夋嫨
Database information
obtaining锛�SHOW璇硶
database metadata锛�INFORMATION_SCHEMA淇℃伅鏁版嵁搴�
database names
case sensitivity锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
case-sensitivity锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�
DATABASE()锛�淇℃伅鍑芥暟
databases
backups锛�鏁版嵁搴撳浠�
copying锛�灏哅ySQL鏁版嵁搴撴嫹璐濆埌鍙︿竴鍙版満鍣�
creating锛�鍒涘缓骞朵娇鐢ㄦ暟鎹簱
defined锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
information about锛�鑾峰緱鏁版嵁搴撳拰琛ㄧ殑淇℃伅
names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
replicating锛�MySQL涓殑澶嶅埗
selecting锛�鍒涘缓骞堕�夋嫨鏁版嵁搴�
symbolic links锛�鍦║nix涓婁娇鐢ㄩ拡瀵规暟鎹簱鐨勭鍙烽摼鎺�
using锛�鍒涘缓骞朵娇鐢ㄦ暟鎹簱
DataJunction锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
DATE锛�浣跨敤DATE鍒楁柟闈㈢殑闂
date and time functions锛�鏃ユ湡鍜屾椂闂村嚱鏁�
Date and Time types锛�鏃ユ湡鍜屾椂闂寸被鍨�
date calculations锛�鏃ユ湡璁＄畻
DATE columns
problems锛�浣跨敤DATE鍒楁柟闈㈢殑闂
DATE data type锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
date functions
Y2K compliance锛�2000骞村吋瀹规��
date types锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
Y2K issues锛�Y2K浜嬪疁鍜屾棩鏈熺被鍨�
date values
problems锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
DATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DATEDIFF()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DATETIME data type锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
DATE_ADD()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DATE_FORMAT()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DATE_SUB()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DAY()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DAYNAME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DAYOFMONTH()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DAYOFWEEK()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
DAYOFYEAR()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
db table
sorting锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
DB2 SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
DBI interface锛�MySQL Perl API
DBI->quote锛�瀛楃涓�
DBI->trace锛�鍦╣db鐜涓嬭皟璇昺ysqld
DBI/DBD interface锛�MySQL Perl API
DBI_TRACE environment variable锛�鍦╣db鐜涓嬭皟璇昺ysqld锛�鐜鍙橀噺
DBI_USER environment variable锛�鐜鍙橀噺
DBUG package锛�DBUG杞欢鍖�
DEALLOCATE PREPARE锛�鐢ㄤ簬棰勫鐞嗚鍙ョ殑SQL璇硶
debug
mysql option锛�閫夐」
debug-info
mysql option锛�閫夐」
debugging
client锛�璋冭瘯MySQL瀹㈡埛绔�
server锛�璋冭瘯MySQL鏈嶅姟鍣�
DEC data type锛�鏁板�肩被鍨嬫杩�
decimal arithmetic锛�绮惧害鏁板
DECIMAL data type锛�鏁板�肩被鍨嬫杩�锛�绮惧害鏁板
decimal point锛�鍒楃被鍨�
DECLARE锛�DECLARE璇彞
DECODE()锛�鍔犲瘑鍑芥暟
decode_bits myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
DEFAULT
constraint锛�瀵规棤鏁堟暟鎹殑绾︽潫
default
privileges锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
default hostname锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�
default installation location锛�瀹夎甯冨眬
default options锛�浣跨敤閫夐」鏂囦欢
DEFAULT value clause锛�CREATE TABLE璇硶
default values锛�MySQL璁捐灞�闄愪笌鎶樿》锛�CREATE TABLE璇硶锛�INSERT璇硶
BLOB and TEXT columns锛�BLOB鍜孴EXT绫诲瀷
implicit锛�CREATE TABLE璇硶
suppression锛�瀵规棤鏁堟暟鎹殑绾︽潫
DEFAULT()锛�鍏朵粬鍑芥暟
default-character-set
mysql option锛�閫夐」
defaults
embedded锛�涓庡祵鍏ュ紡鏈嶅姟鍣ㄤ竴璧蜂娇鐢ㄧ殑閫夐」
DEGREES()锛�鏁板鍑芥暟
DELAYED锛�INSERT DELAYED璇硶
delayed_insert_limit锛�INSERT DELAYED璇硶
DELETE锛�DELETE璇硶
deleting
database锛�DROP DATABASE璇硶
foreign key锛�ALTER TABLE璇硶锛�FOREIGN KEY绾︽潫
function锛�CREATE FUNCTION/DROP FUNCTION璇硶
index锛�ALTER TABLE璇硶锛�DROP INDEX璇硶
primary key锛�ALTER TABLE璇硶
rows锛�浠庣浉鍏宠〃鍒犻櫎琛�
schema锛�DROP DATABASE璇硶
table锛�DROP TABLE璇硶
user锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
users锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
deletion
mysql.sock锛�濡備綍淇濇姢鎴栨洿鏀筂ySQL濂楁帴瀛楁枃浠�/tmp/mysql.sock
Delphi program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
derived tables锛�FROM瀛愬彞涓殑瀛愭煡璇�
DESC锛�DESCRIBE璇硶锛堣幏鍙栨湁鍏冲垪鐨勪俊鎭級
DESCRIBE锛�鑾峰緱鏁版嵁搴撳拰琛ㄧ殑淇℃伅锛�DESCRIBE璇硶锛堣幏鍙栨湁鍏冲垪鐨勪俊鎭級
design
choices锛�璁捐閫夋嫨
issues锛�MySQL涓殑宸茬煡浜嬪疁
limitations锛�MySQL璁捐灞�闄愪笌鎶樿》
DES_DECRYPT()锛�鍔犲瘑鍑芥暟
DES_ENCRYPT()锛�鍔犲瘑鍑芥暟
developers
list of锛�鎰熻阿
development source tree锛�浠庡紑鍙戞簮鐮佹爲瀹夎
Difference()锛�Spatial 鎿嶄綔绗�
digits锛�鍒楃被鍨�
Dimension()锛�閫氱敤鍑犱綍鍑芥暟
directory structure
default锛�瀹夎甯冨眬
DISCARD TABLESPACE锛�ALTER TABLE璇硶锛�浣跨敤鎸夎〃鐨勮〃绌洪棿
disconnecting
from the server锛�杩炴帴涓庢柇寮�鏈嶅姟鍣�
Disjoint()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
disk full锛�MySQL澶勭悊纾佺洏婊＄殑鏂瑰紡
disk issues锛�纾佺洏浜嬪疁
disks
splitting data across锛�鍦╓indows骞冲彴涓婁娇鐢ㄥ叧浜庢暟鎹簱鐨勭鍙烽摼鎺�
display size锛�鍒楃被鍨�
display triggers锛�SHOW TRIGGERS璇硶
display width锛�鍒楃被鍨�
displaying
information
Cardinality锛�SHOW INDEX璇硶
Collation锛�SHOW INDEX璇硶
SHOW锛�SHOW璇硶锛�SHOW COLUMNS璇硶锛�SHOW INDEX璇硶锛�SHOW OPEN TABLES璇硶锛�SHOW TABLES璇硶
table status锛�SHOW TABLE STATUS璇硶
Distance()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
DISTINCT锛�閫夋嫨鐗规畩鍒�锛�MySQL濡備綍浼樺寲DISTINCT锛�GROUP BY锛堣仛鍚堬級鍑芥暟锛�SELECT璇硶
DISTINCTROW锛�SELECT璇硶
DIV锛�绠楁湳鎿嶄綔绗�
division (/)锛�绠楁湳鎿嶄綔绗�
DNS锛�MySQL濡備綍浣跨敤DNS
DO锛�DO璇硶
DocBook XML
documentation source format锛�鍏充簬鏈墜鍐�
Documenters
list of锛�璧勬枡鍛樺拰璇戝憳
DOUBLE data type锛�鏁板�肩被鍨嬫杩�
DOUBLE PRECISION data type锛�鏁板�肩被鍨嬫杩�
double quote (\")锛�瀛楃涓�
downgrading锛�闄嶇骇MySQL
downloading锛�鎬庢牱鑾峰緱MySQL
DROP DATABASE锛�DROP DATABASE璇硶
DROP FOREIGN KEY锛�ALTER TABLE璇硶锛�FOREIGN KEY绾︽潫
DROP FUNCTION锛�DROP PROCEDURE鍜孌ROP FUNCTION锛�CREATE FUNCTION/DROP FUNCTION璇硶
DROP INDEX锛�ALTER TABLE璇硶锛�DROP INDEX璇硶
DROP PRIMARY KEY锛�ALTER TABLE璇硶
DROP PROCEDURE锛�DROP PROCEDURE鍜孌ROP FUNCTION
DROP SCHEMA锛�DROP DATABASE璇硶
DROP TABLE锛�DROP TABLE璇硶
DROP USER锛�DROP USER璇硶
DROP VIEW锛�DROP VIEW璇硶
dropping
user锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
DUAL锛�SELECT璇硶
DUMPFILE锛�SELECT璇硶
dynamic table characteristics锛�鍔ㄦ�佽〃鐗规��

E

Eiffel Wrapper锛�MySQL Eiffel Wrapper
ELT()锛�瀛楃涓插嚱鏁�
email lists锛�The MySQL閭欢鍒楄〃
embedded MySQL server library锛�libmysqld锛屽祵鍏ュ紡MySQL鏈嶅姟鍣ㄥ簱
ENCODE()锛�鍔犲瘑鍑芥暟
ENCRYPT()锛�鍔犲瘑鍑芥暟
encryption functions锛�鍔犲瘑鍑芥暟
END锛�BEGIN ... END澶嶅悎璇彞
EndPoint()锛�LineString鍑芥暟
entering
queries锛�杈撳叆鏌ヨ
ENUM
size锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
ENUM data type锛�瀛楃涓茬被鍨嬫杩�锛�ENUM绫诲瀷
Envelope()锛�閫氱敤鍑犱綍鍑芥暟
environment variable
CC锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂
CFLAGS锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂
CXX锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂
CXXFLAGS锛�鍏稿瀷閰嶇疆閫夐」锛�澶勭悊MySQL缂栬瘧闂
HOME锛�閫夐」
LD_RUN_PATH锛�Linux婧愮爜鍒嗗彂鐗堣鏄�锛�Solaris娉ㄦ剰浜嬮」
MYSQL_DEBUG锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
MYSQL_HISTFILE锛�閫夐」
MYSQL_HOST锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�
MYSQL_PWD锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
MYSQL_TCP_PORT锛�鍦║nix涓繍琛屽涓湇鍔″櫒锛�鍦ㄥ鏈嶅姟鍣ㄧ幆澧冧腑浣跨敤瀹㈡埛绔▼搴�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
MYSQL_UNIX_PORT锛�鍦║nix涓繍琛屽涓湇鍔″櫒锛�鍦ㄥ鏈嶅姟鍣ㄧ幆澧冧腑浣跨敤瀹㈡埛绔▼搴�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
PATH锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL锛�璋冪敤MySQL绋嬪簭
USER锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�
Environment variable
CC锛�鐜鍙橀噺
CFLAGS锛�鐜鍙橀噺
CXX锛�澶勭悊MySQL缂栬瘧闂锛�鐜鍙橀噺
CXXFLAGS锛�鐜鍙橀噺
DBI_TRACE锛�鍦╣db鐜涓嬭皟璇昺ysqld锛�鐜鍙橀噺
DBI_USER锛�鐜鍙橀噺
HOME锛�鐜鍙橀噺
LD_LIBRARY_PATH锛�浣跨敤Perl DBI/DBD鎺ュ彛鐨勯棶棰�
LD_RUN_PATH锛�浣跨敤Perl DBI/DBD鎺ュ彛鐨勯棶棰�锛�鐜鍙橀噺
MYSQL_DEBUG锛�璋冭瘯MySQL瀹㈡埛绔�锛�鐜鍙橀噺
MYSQL_HISTFILE锛�鐜鍙橀噺
MYSQL_HOST锛�鐜鍙橀噺
MYSQL_PS1锛�鐜鍙橀噺
MYSQL_PWD锛�鐜鍙橀噺
MYSQL_TCP_PORT锛�鐜鍙橀噺
MYSQL_UNIX_PORT锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�锛�鐜鍙橀噺
PATH锛�鐜鍙橀噺
TMPDIR锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�锛�鐜鍙橀噺
TZ锛�鏃跺尯闂锛�鐜鍙橀噺
UMASK锛�涓庢枃浠惰鍙湁鍏崇殑闂锛�鐜鍙橀噺
UMASK_DIR锛�涓庢枃浠惰鍙湁鍏崇殑闂锛�鐜鍙橀噺
USER锛�鐜鍙橀噺
Environment variables
CXX锛�澶勭悊MySQL缂栬瘧闂
environment variables锛�鐢ㄧ幆澧冨彉閲忔寚瀹氶�夐」锛�鎷掔粷璁块棶閿欒鐨勫師鍥�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
list of锛�鐜鍙橀噺
equal (=)锛�姣旇緝鍑芥暟鍜屾搷浣滅
Equals()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
error messages
can't find file锛�涓庢枃浠惰鍙湁鍏崇殑闂
languages锛�璁剧疆閿欒娑堟伅璇█
errors
access denied锛�鎷掔粷璁块棶
checking tables for锛�濡備綍妫�鏌yISAM琛ㄧ殑閿欒
common锛�闂鍜屽父瑙侀敊璇�
directory checksum锛�Solaris娉ㄦ剰浜嬮」
handling for UDFs锛�UDF杩斿洖鍊煎拰閿欒澶勭悊
known锛�MySQL涓殑宸茬煡浜嬪疁
linking锛�涓嶮ySQL瀹㈡埛绔簱鐨勯摼鎺ラ棶棰�
list of锛�浣跨敤MySQL绋嬪簭鏃剁殑甯歌閿欒
reporting锛�涓�鑸俊鎭�锛�MySQL閭欢鍒楄〃锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
ERROR_FOR_DIVISION_BY_ZERO SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
escape (\\)锛�瀛楃涓�
escape characters锛�鏂囧瓧鍊�
estimating
query performance锛�浼拌鏌ヨ鎬ц兘
exact-value literals锛�绮惧害鏁板
example
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
EXAMPLE storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�EXAMPLE瀛樺偍寮曟搸
EXAMPLE table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�EXAMPLE瀛樺偍寮曟搸
examples
compressed tables锛�myisampack锛氱敓鎴愬帇缂┿�佸彧璇籑yISAM琛�
myisamchk output锛�鑾峰彇鍏充簬琛ㄧ殑淇℃伅
queries锛�甯哥敤鏌ヨ鐨勪緥瀛�
Excel锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
execute
mysql option锛�閫夐」
EXECUTE锛�鐢ㄤ簬棰勫鐞嗚鍙ョ殑SQL璇硶
EXP()锛�鏁板鍑芥暟
EXPLAIN锛�EXPLAIN璇硶锛堣幏鍙朣ELECT鐩稿叧淇℃伅锛�
EXPORT_SET()锛�瀛楃涓插嚱鏁�
expression aliases锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY锛�SELECT璇硶
expressions
extended锛�妯″紡鍖归厤
extensions
to standard SQL锛�MySQL鏍囧噯鐨勫吋瀹规��
ExteriorRing()锛�Polygon鍑芥暟
EXTRACT()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
extracting
dates锛�鏃ユ湡璁＄畻

F

FALSE锛�鏁板��
testing for锛�姣旇緝鍑芥暟鍜屾搷浣滅
fatal signal 11锛�澶勭悊MySQL缂栬瘧闂
features of MySQL锛�MySQL鐨勭殑涓昏鐗规��
FEDERATED storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�FEDERATED瀛樺偍寮曟搸
FEDERATED table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�FEDERATED瀛樺偍寮曟搸
FETCH锛�鍏夋爣FETCH璇彞
field
changing锛�ALTER TABLE璇硶
FIELD()锛�瀛楃涓插嚱鏁�
FILE锛�瀛楃涓插嚱鏁�
files
binary log锛�浜岃繘鍒舵棩蹇�
config.cache锛�澶勭悊MySQL缂栬瘧闂
error messages锛�璁剧疆閿欒娑堟伅璇█
log锛�鍏稿瀷閰嶇疆閫夐」锛�鏃ュ織鏂囦欢缁存姢
my.cnf锛�澶嶅埗鐗规�у拰宸茬煡闂
not found message锛�涓庢枃浠惰鍙湁鍏崇殑闂
permissions锛�涓庢枃浠惰鍙湁鍏崇殑闂
query log锛�閫氱敤鏌ヨ鏃ュ織
repairing锛�myisamchk鐨勪慨澶嶉�夐」
script锛�鍦ㄦ壒澶勭悊妯″紡涓嬩娇鐢╩ysql
size limits锛�MySQL琛ㄦ渶澶ц兘杈惧埌澶氬皯
slow query log锛�鎱㈤�熸煡璇㈡棩蹇�
tmp锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�
update log (obsolete)锛�浜岃繘鍒舵棩蹇�
filesort optimization锛�MySQL濡備綍浼樺寲ORDER BY
FIND_IN_SET()锛�瀛楃涓插嚱鏁�
FIXED data type锛�鏁板�肩被鍨嬫杩�
fixed-point arithmetic锛�绮惧害鏁板
FLOAT data type锛�鏁板�肩被鍨嬫杩�
floating-point number锛�鏁板�肩被鍨嬫杩�
floats锛�鏁板��
FLOOR()锛�鏁板鍑芥暟
FLUSH锛�FLUSH Syntax
flush tables锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
FOR UPDATE锛�SELECT璇硶
force
mysql option锛�閫夐」
FORCE INDEX锛�SELECT璇硶锛�JOIN璇硶锛�涓庝紭鍖栧櫒鏈夊叧鐨勪簨瀹�
FORCE KEY锛�SELECT璇硶锛�JOIN璇硶
foreign key
constraint锛�PRIMARY KEY鍜孶NIQUE绱㈠紩绾︽潫
deleting锛�ALTER TABLE璇硶锛�FOREIGN KEY绾︽潫
foreign keys锛�Foreign Keys锛�浣跨敤澶栭敭锛�ALTER TABLE璇硶
FORMAT()锛�鍏朵粬鍑芥暟
Forums锛�MySQL璁哄潧涓婄殑MySQL绀惧尯鏀寔
FOUND_ROWS()锛�淇℃伅鍑芥暟
FreeBSD troubleshooting锛�澶勭悊MySQL缂栬瘧闂
FROM锛�SELECT璇硶
FROM_DAYS()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
FROM_UNIXTIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
ft_max_word_len myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
ft_min_word_len myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
ft_stopword_file myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
full disk锛�MySQL澶勭悊纾佺洏婊＄殑鏂瑰紡
full-text search锛�鍏ㄦ枃鎼滅储鍔熻兘
FULLTEXT锛�鍏ㄦ枃鎼滅储鍔熻兘
fulltext
stopword list锛�寰皟MySQL鍏ㄦ枃鎼滅储
function
deleting锛�CREATE FUNCTION/DROP FUNCTION璇硶
functions锛�鍑芥暟鍜屾搷浣滅
arithmetic锛�浣嶅嚱鏁�
bit锛�浣嶅嚱鏁�
C API锛�C API鍑芥暟姒傝堪
C Prepared statement API锛�C API棰勫鐞嗚鍙ュ嚱鏁版杩�
cast锛�Cast鍑芥暟鍜屾搷浣滅
control flow锛�鎺у埗娴佺▼鍑芥暟
date and time锛�鏃ユ湡鍜屾椂闂村嚱鏁�
encryption锛�鍔犲瘑鍑芥暟
GROUP BY锛�GROUP BY锛堣仛鍚堬級鍑芥暟
grouping锛�鍦嗘嫭鍙�
information锛�淇℃伅鍑芥暟
mathematical锛�鏁板鍑芥暟
miscellaneous锛�鍏朵粬鍑芥暟
native
adding锛�娣诲姞鏂扮殑鍥烘湁鍑芥暟
new锛�涓篗ySQL娣诲姞鏂板嚱鏁�
string锛�瀛楃涓插嚱鏁�
string comparison锛�瀛楃涓叉瘮杈冨嚱鏁�
user-defined锛�涓篗ySQL娣诲姞鏂板嚱鏁�
adding锛�娣诲姞鏂扮殑鑷畾涔夊嚱鏁�
Functions
user-defined锛�CREATE FUNCTION/DROP FUNCTION璇硶
functions for SELECT and WHERE clauses锛�鍑芥暟鍜屾搷浣滅
Future development of MySQL绨囷紝MySQL绨囧彂灞曠殑閲嶈鍘嗙▼

G

gcc锛�鍏稿瀷閰嶇疆閫夐」
gdb
using锛�鍦╣db鐜涓嬭皟璇昺ysqld
general information锛�涓�鑸俊鎭�
General Public License锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
geographic feature锛�鍓嶈█
GeomCollFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
GeomCollFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
geometry锛�鍓嶈█
GEOMETRY data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
GEOMETRYCOLLECTION data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
GeometryCollection()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
GeometryCollectionFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
GeometryCollectionFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
GeometryFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
GeometryFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
GeometryN()锛�GeometryCollection鍑芥暟
GeometryType()锛�閫氱敤鍑犱綍鍑芥暟
GeomFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�锛�Geometry鏍煎紡杞崲鍑芥暟
GeomFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�锛�Geometry鏍煎紡杞崲鍑芥暟
geospatial feature锛�鍓嶈█
getting MySQL锛�鎬庢牱鑾峰緱MySQL
GET_FORMAT()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
GET_LOCK()锛�鍏朵粬鍑芥暟
GIS锛�MySQL涓殑绌洪棿鎵╁睍锛�鍓嶈█
GLength()锛�LineString鍑芥暟锛�MultiLineString鍑芥暟
global privileges锛�GRANT鍜孯EVOKE璇硶
goals of MySQL锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
GPL
General Public License锛�GNU閫氱敤鍏叡璁稿彲
GNU閫氱敤鍏叡璁稿彲锛�GNU閫氱敤鍏叡璁稿彲
MySQL FLOSS璁稿彲渚嬪锛�MySQL FLOSS璁稿彲渚嬪
GRANT锛�GRANT鍜孯EVOKE璇硶
GRANT statement锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�锛�SSL GRANT 閫夐」
grant tables锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
re-creating锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
sorting锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
upgrading锛�鍗囩骇鎺堟潈琛�
granting
privileges锛�GRANT鍜孯EVOKE璇硶
GRANTS锛�SHOW GRANTS璇硶
greater than (>)锛�姣旇緝鍑芥暟鍜屾搷浣滅
greater than or equal (>=)锛�姣旇緝鍑芥暟鍜屾搷浣滅
GREATEST()锛�姣旇緝鍑芥暟鍜屾搷浣滅
GROUP BY锛�MySQL濡備綍浼樺寲GROUP BY
aliases in锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY
extensions to standard SQL锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY锛�SELECT璇硶
GROUP BY functions锛�GROUP BY锛堣仛鍚堬級鍑芥暟
grouping
expressions锛�鍦嗘嫭鍙�
GROUP_CONCAT()锛�GROUP BY锛堣仛鍚堬級鍑芥暟

H

HANDLER锛�HANDLER璇硶
Handlers锛�DECLARE Handlers
handling
errors锛�UDF杩斿洖鍊煎拰閿欒澶勭悊
hash partitioning锛�HASH鍒嗗尯
hash partitions锛宮anaging锛�HASH鍜孠EY鍒嗗尯鐨勭鐞�
hash partitions锛宻plitting and merging锛�HASH鍜孠EY鍒嗗尯鐨勭鐞�
HAVING锛�SELECT璇硶
HEAP storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MEMORY (HEAP)瀛樺偍寮曟搸
HEAP table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MEMORY (HEAP)瀛樺偍寮曟搸
help
mysql option锛�閫夐」
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
HEX()锛�瀛楃涓插嚱鏁�
hexadecimal values锛�鍗佸叚杩涘埗鍊�
HIGH_NOT_PRECEDENCE SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
HIGH_PRIORITY锛�SELECT璇硶
hints锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�锛�SELECT璇硶锛�JOIN璇硶
index锛�SELECT璇硶锛�JOIN璇硶
history of MySQL锛�MySQL鐨勫巻鍙�
HOME environment variable锛�閫夐」锛�鐜鍙橀噺
host
mysql option锛�閫夐」
host table锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
sorting锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
host.frm
problems finding锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
hostname
default锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�
hostname caching锛�MySQL濡備綍浣跨敤DNS
HOUR()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
html
mysql option锛�閫夐」

I

ID
unique锛�濡備綍鑾峰緱涓婃鎻掑叆琛岀殑鍞竴ID
identifiers锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
case sensitivity锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
quoting锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
IF锛�IF璇彞
IF()锛�鎺у埗娴佺▼鍑芥暟
IFNULL()锛�鎺у埗娴佺▼鍑芥暟
IGNORE INDEX锛�SELECT璇硶锛�JOIN璇硶
IGNORE KEY锛�SELECT璇硶锛�JOIN璇硶
ignore-space
mysql option锛�閫夐」
IGNORE_SPACE SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
implicit default values锛�CREATE TABLE璇硶
IMPORT TABLESPACE锛�ALTER TABLE璇硶锛�浣跨敤鎸夎〃鐨勮〃绌洪棿
IN锛�姣旇緝鍑芥暟鍜屾搷浣滅
increasing
performance锛�澶嶅埗FAQ
increasing with replication
speed锛�MySQL涓殑澶嶅埗
index
deleting锛�ALTER TABLE璇硶锛�DROP INDEX璇硶
index hints锛�SELECT璇硶锛�JOIN璇硶
indexes锛�CREATE INDEX璇硶
and BLOB columns锛�鍒楃储寮�锛�CREATE TABLE璇硶
and IS NULL锛�MySQL濡備綍浣跨敤绱㈠紩
and LIKE锛�MySQL濡備綍浣跨敤绱㈠紩
and NULL values锛�CREATE TABLE璇硶
and TEXT columns锛�鍒楃储寮�锛�CREATE TABLE璇硶
assigning to key cache锛�CACHE INDEX璇硶
block size锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�
columns锛�鍒楃储寮�
leftmost prefix of锛�MySQL濡備綍浣跨敤绱㈠紩
multi-column锛�澶氬垪绱㈠紩
multiple-part锛�CREATE INDEX璇硶
names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
use of锛�MySQL濡備綍浣跨敤绱㈠紩
INET_ATON()锛�鍏朵粬鍑芥暟
INET_NTOA()锛�鍏朵粬鍑芥暟
information about partitions锛宱btaining锛�鑾峰彇鍏充簬鍒嗗尯鐨勪俊鎭�
information functions锛�淇℃伅鍑芥暟
INFORMATION_SCHEMA锛�INFORMATION_SCHEMA淇℃伅鏁版嵁搴�锛�INFORMATION_SCHEMA琛�
INNER JOIN锛�JOIN璇硶
InnoDB锛�InnoDB姒傝堪
Solaris 10 x86_64 issues锛�Solaris娉ㄦ剰浜嬮」
InnoDB storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�InnoDB瀛樺偍寮曟搸
InnoDB table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�InnoDB瀛樺偍寮曟搸
InnoDB tables锛�浜嬪姟鍜屽師瀛愭搷浣�
INSERT锛�INSERT璇彞鐨勯�熷害锛�INSERT璇硶
INSERT ... SELECT锛�INSERT璇硶
INSERT DELAYED锛�INSERT DELAYED璇硶
INSERT statement
grant privileges锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
INSERT()锛�瀛楃涓插嚱鏁�
inserting
speed of锛�INSERT璇彞鐨勯�熷害
installation layouts锛�瀹夎甯冨眬
installation overview锛�浣跨敤婧愮爜鍒嗗彂鐗堝畨瑁匨ySQL
installing
binary distribution锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL
Linux RPM packages锛�鍦↙inux涓嬪畨瑁匨ySQL
Mac OS X PKG packages,鍦�Mac OS X涓畨瑁匨ySQL
overview锛�瀹夎MySQL
Perl锛�Perl瀹夎娉ㄦ剰浜嬮」
Perl on Windows锛�鍦╓indows涓嬪畨瑁匒ctiveState Perl
source distribution锛�浣跨敤婧愮爜鍒嗗彂鐗堝畨瑁匨ySQL
user-defined functions锛�缂栬瘧鍜屽畨瑁呯敤鎴峰畾涔夌殑鍑芥暟
INSTR()锛�瀛楃涓插嚱鏁�
INT data type锛�鏁板�肩被鍨嬫杩�
integer arithmetic锛�绮惧害鏁板
INTEGER data type锛�鏁板�肩被鍨嬫杩�
integers锛�鏁板��
InteriorRingN()锛�Polygon鍑芥暟
internal compiler errors锛�澶勭悊MySQL缂栬瘧闂
internal locking锛�閿佸畾鏂规硶
internals锛�MySQL鍐呴儴鎺т欢
Internet Relay Chat锛�IRC锛堝湪绾胯亰澶╃郴缁燂級涓婄殑MySQL绀惧尯鏀寔
Intersection()锛�Spatial 鎿嶄綔绗�
Intersects()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
INTERVAL()锛�姣旇緝鍑芥暟鍜屾搷浣滅
introducer
string literal锛�瀛楃涓�锛�瀛楃涓叉枃瀛楀瓧绗﹂泦鍜屾牎瀵�
invalid data
constraint锛�瀵规棤鏁堟暟鎹殑绾︽潫
IRC锛�IRC锛堝湪绾胯亰澶╃郴缁燂級涓婄殑MySQL绀惧尯鏀寔
IS boolean_value锛�姣旇緝鍑芥暟鍜屾搷浣滅
IS NOT boolean_value锛�姣旇緝鍑芥暟鍜屾搷浣滅
IS NOT NULL锛�姣旇緝鍑芥暟鍜屾搷浣滅
IS NULL锛�MySQL濡備綍浼樺寲IS NULL锛�姣旇緝鍑芥暟鍜屾搷浣滅
and indexes锛�MySQL濡備綍浣跨敤绱㈠紩
ISAM storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
ISAM table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
IsClosed()锛�MultiLineString鍑芥暟
IsEmpty()锛�閫氱敤鍑犱綍鍑芥暟
ISNULL()锛�姣旇緝鍑芥暟鍜屾搷浣滅
ISOLATION LEVEL锛�SET TRANSACTION璇硶
IsRing()锛�LineString鍑芥暟
IsSimple()锛�閫氱敤鍑犱綍鍑芥暟
IS_FREE_LOCK()锛�鍏朵粬鍑芥暟
IS_USED_LOCK()锛�鍏朵粬鍑芥暟
ITERATE锛�ITERATE璇彞

J

JOIN锛�JOIN璇硶

K

Key cache
MyISAM锛�MyISAM閿珮閫熺紦鍐�
key cache
assigning indexes to锛�CACHE INDEX璇硶
key partitioning锛�KEY鍒嗗尯
key partitions锛宮anaging锛�HASH鍜孠EY鍒嗗尯鐨勭鐞�
key partitions锛宻plitting and merging锛�HASH鍜孠EY鍒嗗尯鐨勭鐞�
key space
MyISAM锛�閿墍闇�鐨勭┖闂�
keys锛�鍒楃储寮�
foreign锛�Foreign Keys锛�浣跨敤澶栭敭
multi-column锛�澶氬垪绱㈠紩
searching on two锛�鏍规嵁涓や釜閿悳绱�
keywords锛�MySQL涓繚鐣欏瓧鐨勫鐞�
key_buffer_size myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
KEY_COLUMN_USAGE
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA KEY_COLUMN_USAGE琛�
KILL锛�KILL璇硶
known errors锛�MySQL涓殑宸茬煡浜嬪疁

L

language support锛�璁剧疆閿欒娑堟伅璇█
last row
unique ID锛�濡備綍鑾峰緱涓婃鎻掑叆琛岀殑鍞竴ID
LAST_DAY()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
LAST_INSERT_ID()锛�浜嬪姟鍜屽師瀛愭搷浣�锛�INSERT璇硶
LAST_INSERT_ID([expr])锛�淇℃伅鍑芥暟
layout of installation锛�瀹夎甯冨眬
LCASE()锛�瀛楃涓插嚱鏁�
LD_LIBRARY_PATH environment variable锛�浣跨敤Perl DBI/DBD鎺ュ彛鐨勯棶棰�
LD_RUN_PATH environment variable锛�Linux婧愮爜鍒嗗彂鐗堣鏄�锛�Solaris娉ㄦ剰浜嬮」锛�浣跨敤Perl DBI/DBD鎺ュ彛鐨勯棶棰�锛�鐜鍙橀噺
LEAST()锛�姣旇緝鍑芥暟鍜屾搷浣滅
LEAVE锛�LEAVE璇彞
LEFT JOIN锛�MySQL濡備綍浼樺寲LEFT JOIN鍜孯IGHT JOIN锛�JOIN璇硶
LEFT OUTER JOIN锛�JOIN璇硶
LEFT()锛�瀛楃涓插嚱鏁�
leftmost prefix of indexes锛�MySQL濡備綍浣跨敤绱㈠紩
legal names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
LENGTH()锛�瀛楃涓插嚱鏁�
less than (<)锛�姣旇緝鍑芥暟鍜屾搷浣滅
less than or equal (<=)锛�姣旇緝鍑芥暟鍜屾搷浣滅
libmysqld锛�libmysqld锛屽祵鍏ュ紡MySQL鏈嶅姟鍣ㄥ簱
options锛�涓庡祵鍏ュ紡鏈嶅姟鍣ㄤ竴璧蜂娇鐢ㄧ殑閫夐」
libraries
list of锛�MySQL浣跨敤鍜屽寘鍚殑搴�
library
mysqlclient锛�API鍜屽簱
mysqld锛�API鍜屽簱
License锛�MySQL FLOSS璁稿彲渚嬪
LIKE锛�瀛楃涓叉瘮杈冨嚱鏁�
and indexes锛�MySQL濡備綍浣跨敤绱㈠紩
and wildcards锛�MySQL濡備綍浣跨敤绱㈠紩
LIMIT锛�MySQL濡備綍浼樺寲LIMIT锛�淇℃伅鍑芥暟锛�SELECT璇硶
limitations
design锛�MySQL璁捐灞�闄愪笌鎶樿》
MySQL Limitations锛�MySQL涓殑闄愬埗
replication锛�澶嶅埗鐗规�у拰宸茬煡闂
limits
file-size锛�MySQL琛ㄦ渶澶ц兘杈惧埌澶氬皯
MySQL Limits锛宭imits in MySQL锛�MySQL涓殑闄愬埗
linear hash partitioning锛�LINEAR HASH鍒嗗尯
linear key partitioning锛�KEY鍒嗗尯
linefeed (\n)锛�瀛楃涓�
LineFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
LineFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
LINESTRING data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
LineString()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
LineStringFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
LineStringFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
linking锛�鍒涘缓瀹㈡埛绔▼搴�
errors锛�涓嶮ySQL瀹㈡埛绔簱鐨勯摼鎺ラ棶棰�
problems锛�涓嶤 API鏈夊叧鐨勯棶棰�
speed锛�缂栬瘧鍜岄摼鎺ユ�庢牱褰卞搷MySQL鐨勯�熷害
links
symbolic锛�浣跨敤绗﹀彿閾炬帴
Linux
binary distribution锛�Linux浜岃繘鍒跺垎鍙戠増璇存槑
source distribution锛�Linux婧愮爜鍒嗗彂鐗堣鏄�
list partitioning锛�LIST鍒嗗尯
list partitions锛宎dding and dropping锛�RANGE鍜孡IST鍒嗗尯鐨勭鐞�
list partitions锛宮anaging锛�RANGE鍜孡IST鍒嗗尯鐨勭鐞�
literals锛�鏂囧瓧鍊�
LN()锛�鏁板鍑芥暟
LOAD DATA FROM MASTER锛�LOAD DATA FROM MASTER璇硶
LOAD DATA INFILE锛�LOAD DATA INFILE璇硶锛�涓嶯ULL鍊兼湁鍏崇殑闂
LOAD TABLE FROM MASTER锛�LOAD TABLE tbl_name FROM MASTER璇硶
loading
tables锛�灏嗘暟鎹鍏ヨ〃涓�
LOAD_FILE()锛�瀛楃涓插嚱鏁�
local-infile
mysql option锛�閫夐」
LOCALTIME锛�鏃ユ湡鍜屾椂闂村嚱鏁�
LOCALTIMESTAMP锛�鏃ユ湡鍜屾椂闂村嚱鏁�
LOCATE()锛�瀛楃涓插嚱鏁�
LOCK IN SHARE MODE锛�SELECT璇硶
LOCK TABLES锛�LOCK TABLES鍜孶NLOCK TABLES璇硶
locking锛�绯荤粺鍥犵礌鍜屽惎鍔ㄥ弬鏁扮殑璋冭妭
page-level锛�閿佸畾鏂规硶
row-level锛�浜嬪姟鍜屽師瀛愭搷浣�锛�閿佸畾鏂规硶
table-level锛�閿佸畾鏂规硶
locking methods锛�閿佸畾鏂规硶
log
changes锛�MySQL鍙樻洿鍙�
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
log files锛�鍏稿瀷閰嶇疆閫夐」
maintaining锛�鏃ュ織鏂囦欢缁存姢
names锛�鏁版嵁搴撳浠�
Log files锛�MySQL鏃ュ織鏂囦欢
LOG()锛�鏁板鍑芥暟
LOG10()锛�鏁板鍑芥暟
LOG2()锛�鏁板鍑芥暟
logical operators锛�閫昏緫鎿嶄綔绗�
LONG data type锛�BLOB鍜孴EXT绫诲瀷
LONGBLOB data type锛�瀛楃涓茬被鍨嬫杩�
LONGTEXT data type锛�瀛楃涓茬被鍨嬫杩�
LOOP锛�LOOP璇彞
LOWER()锛�瀛楃涓插嚱鏁�
LPAD()锛�瀛楃涓插嚱鏁�
LTRIM()锛�瀛楃涓插嚱鏁�

M

Mac OS X
installation,鍦�Mac OS X涓畨瑁匨ySQL
mailing address
for customer support锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
mailing list address锛�涓�鑸俊鎭�
mailing lists锛�The MySQL閭欢鍒楄〃
archive location锛�璇锋暀闂鎴栭�氭姤缂洪櫡
guidelines锛�鍦ㄩ偖浠跺垪琛ㄤ笂鍥炵瓟闂鐨勬寚鍗�
main features of MySQL锛�MySQL鐨勭殑涓昏鐗规��
maintaining
log files锛�鏃ュ織鏂囦欢缁存姢
tables锛�寤虹珛琛ㄧ淮鎶よ鍒�
MAKEDATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
MAKETIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
make_binary_distribution锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
MAKE_SET()锛�瀛楃涓插嚱鏁�
manual
available formats锛�鍏充簬鏈墜鍐�
online location锛�鍏充簬鏈墜鍐�
typographical conventions锛�鏈墜鍐岄噰鐢ㄧ殑鎯緥
master/slave setup锛�澶嶅埗瀹炴柦姒傝堪
MASTER_POS_WAIT()锛�鍏朵粬鍑芥暟锛�MASTER_POS_WAIT()璇硶
MATCH ... AGAINST()锛�鍏ㄦ枃鎼滅储鍔熻兘
matching
patterns锛�妯″紡鍖归厤
math锛�绮惧害鏁板
mathematical functions锛�鏁板鍑芥暟
MAX()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
MAX(DISTINCT)锛�GROUP BY锛堣仛鍚堬級鍑芥暟
MAXDB SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
maximum memory used锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
maximums
maximum tables per join锛�鑱斿悎鐨勯檺鍒�
max_allowed_packet variable锛�閫夐」
MAX_CONNECTIONS_PER_HOUR锛�闄愬埗璐︽埛璧勬簮
max_join_size variable锛�閫夐」
MAX_QUERIES_PER_HOUR锛�闄愬埗璐︽埛璧勬簮
MAX_UPDATES_PER_HOUR锛�闄愬埗璐︽埛璧勬簮
MAX_USER_CONNECTIONS锛�闄愬埗璐︽埛璧勬簮
MBR锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBRContains()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBRDisjoint()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBREqual()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBRIntersects()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBROverlaps()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBRTouches()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MBRWithin()锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
MD5()锛�鍔犲瘑鍑芥暟
MEDIUMBLOB data type锛�瀛楃涓茬被鍨嬫杩�
MEDIUMINT data type锛�鏁板�肩被鍨嬫杩�
MEDIUMTEXT data type锛�瀛楃涓茬被鍨嬫杩�
MEMORY storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MEMORY (HEAP)瀛樺偍寮曟搸
MEMORY table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MEMORY (HEAP)瀛樺偍寮曟搸
memory usage
myisamchk锛�myisamchk鍐呭瓨浣跨敤
memory use锛�MySQL濡備綍浣跨敤鍐呭瓨锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
MERGE storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MERGE瀛樺偍寮曟搸
MERGE table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MERGE瀛樺偍寮曟搸
MERGE tables
defined锛�MERGE瀛樺偍寮曟搸
messages
languages锛�璁剧疆閿欒娑堟伅璇█
metadata
database锛�INFORMATION_SCHEMA淇℃伅鏁版嵁搴�
methods
locking锛�閿佸畾鏂规硶
MICROSECOND()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
MID()锛�瀛楃涓插嚱鏁�
MIN()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
MIN(DISTINCT)锛�GROUP BY锛堣仛鍚堬級鍑芥暟
Minimum Bounding Rectangle锛�鍏充簬鍑犱綍鏈�灏忚竟鐣岀煩褰紙MBR锛夌殑鍏崇郴
minus
unary (-)锛�绠楁湳鎿嶄綔绗�
MINUTE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
mirror sites锛�鎬庢牱鑾峰緱MySQL
miscellaneous functions锛�鍏朵粬鍑芥暟
MIT-pthreads锛�MIT-pthreads娉ㄦ剰浜嬮」
MLineFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MLineFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MOD (modulo)锛�鏁板鍑芥暟
MOD()锛�鏁板鍑芥暟
modes
batch锛�鍦ㄦ壒澶勭悊妯″紡涓嬩娇鐢╩ysql
modules
list of锛�MySQL绋冲畾鎬�
modulo (%)锛�鏁板鍑芥暟
modulo (MOD)锛�鏁板鍑芥暟
monitor
terminal锛�鏁欑▼
MONTH()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
MONTHNAME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
MPointFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MPointFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MPolyFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MPolyFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
mSQL compatibility锛�瀛楃涓叉瘮杈冨嚱鏁�
MSSQL SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
multi-byte character sets锛�鏃犳硶鍒濆鍖栧瓧绗﹂泦
multi-byte characters锛�澶氬瓧鑺傚瓧绗︽敮鎸�
multi-column indexes锛�澶氬垪绱㈠紩
MULTILINESTRING data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
MultiLineString()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
MultiLineStringFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MultiLineStringFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
multiple servers锛�鍦ㄥ悓涓�鍙版満鍣ㄤ笂杩愯澶氫釜MySQL鏈嶅姟鍣�
multiple-part index锛�CREATE INDEX璇硶
multiplication (*)锛�绠楁湳鎿嶄綔绗�
MULTIPOINT data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
MultiPoint()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
MultiPointFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MultiPointFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MULTIPOLYGON data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
MultiPolygon()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
MultiPolygonFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
MultiPolygonFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
My
derivation锛�MySQL鐨勫巻鍙�
my.cnf file锛�澶嶅埗鐗规�у拰宸茬煡闂
MyISAM
compressed tables锛�鍘嬬缉琛ㄧ壒鎬�
size锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
MyISAM key cache锛�MyISAM閿珮閫熺紦鍐�
MyISAM storage engine锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MyISAM瀛樺偍寮曟搸
MyISAM table type锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷锛�MyISAM瀛樺偍寮曟搸
myisamchk锛�鍏稿瀷閰嶇疆閫夐」锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
example output锛�鑾峰彇鍏充簬琛ㄧ殑淇℃伅
options锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
myisampack锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�鍘嬬缉琛ㄧ壒鎬�
myisam_block_size myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
MyODBC锛�MySQL Connector/ODBC
reporting problems锛�濡備綍閫氭姤MyODBC闂鎴栫己闄�
MySQL
defined锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
introduction锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
pronunciation锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
mysql锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
MySQL AB
defined锛�MySQL AB姒傝堪
MySQL binary distribution锛�閫夋嫨瑕佸畨瑁呯殑MySQL鍒嗗彂鐗�
MYSQL C type锛�C API鏁版嵁绫诲瀷
MySQL C type锛�C API棰勫鐞嗚鍙ョ殑鏁版嵁绫诲瀷
MySQL绨� in MySQL 5.0 and 5.1锛�MySQL绨囧彂灞曠殑閲嶈鍘嗙▼
mysql command-line options锛�閫夐」
mysql commands
list of锛�mysql鍛戒护
MySQL Dolphin name锛�MySQL鐨勫巻鍙�
MySQL history锛�MySQL鐨勫巻鍙�
mysql history file锛�閫夐」
MySQL mailing lists锛�MySQL閭欢鍒楄〃
MySQL name锛�MySQL鐨勫巻鍙�
mysql prompt command锛�mysql鍛戒护
MySQL source distribution锛�閫夋嫨瑕佸畨瑁呯殑MySQL鍒嗗彂鐗�
mysql status command锛�mysql鍛戒护
MySQL storage engines锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
MySQL table types锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
MySQL version锛�鎬庢牱鑾峰緱MySQL
MySQL++锛�MySQL C++ API
mysql.server锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
mysql.sock
changing location of锛�鍏稿瀷閰嶇疆閫夐」
protection锛�濡備綍淇濇姢鎴栨洿鏀筂ySQL濂楁帴瀛楁枃浠�/tmp/mysql.sock
MYSQL323 SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
MYSQL40 SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
mysqlaccess锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
mysqladmin锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�CREATE DATABASE璇硶锛�DROP DATABASE璇硶锛�SHOW STATUS璇硶锛�SHOW VARIABLES璇硶锛�FLUSH Syntax锛�KILL璇硶
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
mysqladmin command-line options锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
mysqlbinlog锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
mysqlbug锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
mysqlbug script锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
location锛�涓�鑸俊鎭�
mysqlcheck锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
mysqlclient library锛�API鍜屽簱
mysqld锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
starting锛�濡備綍浠ユ櫘閫氱敤鎴疯韩浠借繍琛孧ySQL
mysqld library锛�API鍜屽簱
mysqld options锛�mysqld鍛戒护琛岄�夐」锛�璋冭妭鏈嶅姟鍣ㄥ弬鏁�
mysqld server
buffer sizes锛�璋冭妭鏈嶅姟鍣ㄥ弬鏁�
mysqld-max锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�锛�mysqld-max鎵╁睍MySQL鏈嶅姟鍣�
mysqldump锛�灏哅ySQL鏁版嵁搴撴嫹璐濆埌鍙︿竴鍙版満鍣�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
mysqld_multi锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
mysqld_safe锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
mysqlhotcopy锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
mysqlimport锛�灏哅ySQL鏁版嵁搴撴嫹璐濆埌鍙︿竴鍙版満鍣�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�LOAD DATA INFILE璇硶
mysqlshow锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
mysqltest
MySQL娴嬭瘯濂椾欢锛�MySQL娴嬭瘯濂椾欢
mysql_affected_rows()锛�mysql_affected_rows()
mysql_autocommit().锛�mysql_autocommit()
MYSQL_BIND C type锛�C API棰勫鐞嗚鍙ョ殑鏁版嵁绫诲瀷
mysql_change_user()锛�mysql_change_user()
mysql_character_set_name()锛�mysql_character_set_name()
mysql_close()锛�mysql_close()
mysql_commit().锛�mysql_commit()
mysql_connect()锛�mysql_connect()
mysql_create_db()锛�mysql_create_db()
mysql_data_seek()锛�mysql_data_seek()
MYSQL_DEBUG environment variable锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�璋冭瘯MySQL瀹㈡埛绔�锛�鐜鍙橀噺
mysql_debug()锛�mysql_debug()
mysql_drop_db()锛�mysql_drop_db()
mysql_dump_debug_info()锛�mysql_dump_debug_info()
mysql_eof()锛�mysql_eof()
mysql_errno()锛�mysql_errno()
mysql_error()锛�mysql_error()
mysql_escape_string()锛�mysql_escape_string()
mysql_fetch_field()锛�mysql_fetch_field()
mysql_fetch_fields()锛�mysql_fetch_fields()
mysql_fetch_field_direct()锛�mysql_fetch_field_direct()
mysql_fetch_lengths()锛�mysql_fetch_lengths()
mysql_fetch_row()锛�mysql_fetch_row()
MYSQL_FIELD C type锛�C API鏁版嵁绫诲瀷
mysql_field_count()锛�mysql_field_count()锛�mysql_num_fields()
MYSQL_FIELD_OFFSET C type锛�C API鏁版嵁绫诲瀷
mysql_field_seek()锛�mysql_field_seek()
mysql_field_tell()锛�mysql_field_tell()
mysql_fix_privilege_tables锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�锛�鎷掔粷璁块棶閿欒鐨勫師鍥�
mysql_free_result()锛�mysql_free_result()
mysql_get_character_set_info()锛�mysql_get_character_set_info()
mysql_get_client_info()锛�mysql_get_client_info()
mysql_get_client_version()锛�mysql_get_client_version()
mysql_get_host_info()锛�mysql_get_host_info()
mysql_get_proto_info()锛�mysql_get_proto_info()
mysql_get_server_info()锛�mysql_get_server_info()
mysql_get_server_version()锛�mysql_get_server_version()
mysql_hex_string()锛�mysql_hex_string()
MYSQL_HISTFILE environment variable锛�閫夐」锛�鐜鍙橀噺
MYSQL_HOST environment variable锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�锛�鐜鍙橀噺
mysql_info()锛�ALTER TABLE璇硶锛�INSERT璇硶锛�LOAD DATA INFILE璇硶锛�UPDATE璇硶锛�mysql_info()
mysql_init()锛�mysql_init()
mysql_insert_id()锛�浜嬪姟鍜屽師瀛愭搷浣�锛�INSERT璇硶锛�mysql_insert_id()
mysql_install_db锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
mysql_install_db script锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�
mysql_kill()锛�mysql_kill()
mysql_library_end()锛�mysql_library_end()
mysql_library_init()锛�mysql_library_init()
mysql_list_dbs()锛�mysql_list_dbs()
mysql_list_fields()锛�mysql_list_fields()
mysql_list_processes()锛�mysql_list_processes()
mysql_list_tables()锛�mysql_list_tables()
mysql_more_results().锛�mysql_more_results()
mysql_next_result().锛�mysql_next_result()
mysql_num_fields()锛�mysql_num_fields()
mysql_num_rows()锛�mysql_num_rows()
mysql_options()锛�mysql_options()
mysql_ping()锛�mysql_ping()
MYSQL_PS1 environment variable锛�鐜鍙橀噺
MYSQL_PWD environment variable锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�鐜鍙橀噺
mysql_query()锛�mysql_query()锛�浣跨敤C API鏃剁殑甯歌闂
mysql_real_connect()锛�mysql_real_connect()
mysql_real_escape_string()锛�瀛楃涓�锛�mysql_real_escape_string()
mysql_real_query()锛�mysql_real_query()
mysql_refresh()锛�mysql_refresh()
mysql_reload()锛�mysql_reload()
MYSQL_RES C type锛�C API鏁版嵁绫诲瀷
mysql_rollback().锛�mysql_rollback()
MYSQL_ROW C type锛�C API鏁版嵁绫诲瀷
mysql_row_seek()锛�mysql_row_seek()
mysql_row_tell()锛�mysql_row_tell()
mysql_select_db()锛�mysql_select_db()
mysql_server_end()锛�mysql_server_end()
mysql_server_init()锛�mysql_server_init()
mysql_set_character_set()锛�mysql_set_character_set()
mysql_set_server_option()锛�mysql_set_server_option()
mysql_shutdown()锛�mysql_shutdown()
mysql_sqlstate()锛�mysql_sqlstate()
mysql_ssl_set()锛�mysql_ssl_set()
mysql_stat()锛�mysql_stat()
MYSQL_STMT C type锛�C API棰勫鐞嗚鍙ョ殑鏁版嵁绫诲瀷
mysql_stmt_affected_rows()锛�mysql_stmt_affected_rows()
mysql_stmt_attr_get()锛�mysql_stmt_attr_get()
mysql_stmt_attr_set()锛�mysql_stmt_attr_set()
mysql_stmt_bind_param()锛�mysql_stmt_bind_param()
mysql_stmt_bind_result()锛�mysql_stmt_bind_result()
mysql_stmt_close()锛�mysql_stmt_close()
mysql_stmt_data_seek()锛�mysql_stmt_data_seek()
mysql_stmt_errno()锛�mysql_stmt_errno()
mysql_stmt_error().锛�mysql_stmt_error()
mysql_stmt_execute()锛�mysql_stmt_execute()
mysql_stmt_fetch()锛�mysql_stmt_fetch()
mysql_stmt_fetch_column()锛�mysql_stmt_fetch_column()
mysql_stmt_field_count()锛�mysql_stmt_field_count()
mysql_stmt_free_result()锛�mysql_stmt_free_result()
mysql_stmt_init()锛�mysql_stmt_init()
mysql_stmt_insert_id()锛�mysql_stmt_insert_id()
mysql_stmt_num_rows()锛�mysql_stmt_num_rows()
mysql_stmt_param_count()锛�mysql_stmt_param_count()
mysql_stmt_param_metadata()锛�mysql_stmt_param_metadata()
mysql_stmt_prepare()锛�mysql_stmt_prepare()
mysql_stmt_reset()锛�mysql_stmt_reset()
mysql_stmt_result_metadata.锛�mysql_stmt_result_metadata()
mysql_stmt_row_seek()锛�mysql_stmt_row_seek()
mysql_stmt_row_tell()锛�mysql_stmt_row_tell()
mysql_stmt_send_long_data().锛�mysql_stmt_send_long_data()
mysql_stmt_sqlstate()锛�mysql_stmt_sqlstate()
mysql_stmt_store_result()锛�mysql_stmt_store_result()
mysql_store_result()锛�mysql_store_result()锛�浣跨敤C API鏃剁殑甯歌闂
MYSQL_TCP_PORT environment variable锛�鍦║nix涓繍琛屽涓湇鍔″櫒锛�鍦ㄥ鏈嶅姟鍣ㄧ幆澧冧腑浣跨敤瀹㈡埛绔▼搴�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�鐜鍙橀噺
mysql_thread_end()锛�mysql_thread_end()
mysql_thread_id()锛�mysql_thread_id()
mysql_thread_init()锛�mysql_thread_init()
mysql_thread_safe()锛�mysql_thread_safe()
MYSQL_UNIX_PORT environment variable锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�锛�鍦║nix涓繍琛屽涓湇鍔″櫒锛�鍦ㄥ鏈嶅姟鍣ㄧ幆澧冧腑浣跨敤瀹㈡埛绔▼搴�锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪锛�鐜鍙橀噺
mysql_use_result()锛�mysql_use_result()
mysql_warning_count().锛�mysql_warning_count()
my_init()锛�my_init()
my_ulonglong C type锛�C API鏁版嵁绫诲瀷
my_ulonglong values
printing锛�C API鏁版嵁绫诲瀷

N

named pipes锛�閫夋嫨MySQL鏈嶅姟鍣ㄧ被鍨�锛�娴嬭瘯MySQL瀹夎
named-commands
mysql option锛�閫夐」
names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
case sensitivity锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
variables锛�鐢ㄦ埛鍙橀噺
NAME_CONST()锛�鍏朵粬鍑芥暟
naming
releases of MySQL锛�閫夋嫨瑕佸畨瑁呯殑MySQL鐗堟湰
NATIONAL CHAR data type锛�瀛楃涓茬被鍨嬫杩�
native functions
adding锛�娣诲姞鏂扮殑鍥烘湁鍑芥暟
native thread support锛�MySQL鏀寔鐨勬搷浣滅郴缁�
NATURAL LEFT JOIN锛�JOIN璇硶
NATURAL LEFT OUTER JOIN锛�JOIN璇硶
NATURAL RIGHT JOIN锛�JOIN璇硶
NATURAL RIGHT OUTER JOIN锛�JOIN璇硶
NCHAR data type锛�瀛楃涓茬被鍨嬫杩�
negative values锛�鏁板��
nested queries锛�Subquery璇硶
net etiquette锛�璇锋暀闂鎴栭�氭姤缂洪櫡锛�鍦ㄩ偖浠跺垪琛ㄤ笂鍥炵瓟闂鐨勬寚鍗�
netmask notation
in mysql.user table锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
NetWare锛�鍦∟etWare涓畨瑁匨ySQL
net_buffer_length variable锛�閫夐」
New features in MySQL绨囷紝MySQL绨囧彂灞曠殑閲嶈鍘嗙▼
new procedures
adding锛�涓篗ySQL娣诲姞鏂版楠�
new users
adding锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL锛�婧愮爜瀹夎姒傝堪
newline (\n)锛�瀛楃涓�
no matching rows锛�瑙ｅ喅涓庝笉鍖归厤琛屾湁鍏崇殑闂
no-auto-rehash
mysql option锛�閫夐」
no-beep
mysql option锛�閫夐」
no-log
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
no-named-commands
mysql option锛�閫夐」
no-pager
mysql option锛�閫夐」
no-tee
mysql option锛�閫夐」
non-delimited strings锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
Non-transactional tables锛�闈炰簨鍔¤〃鍥炴粴澶辫触
NOT
logical锛�閫昏緫鎿嶄綔绗�
NOT BETWEEN锛�姣旇緝鍑芥暟鍜屾搷浣滅
not equal (!=)锛�姣旇緝鍑芥暟鍜屾搷浣滅
not equal (<>)锛�姣旇緝鍑芥暟鍜屾搷浣滅
NOT IN锛�姣旇緝鍑芥暟鍜屾搷浣滅
NOT LIKE锛�瀛楃涓叉瘮杈冨嚱鏁�
NOT NULL
constraint锛�瀵规棤鏁堟暟鎹殑绾︽潫
NOT REGEXP锛�瀛楃涓叉瘮杈冨嚱鏁�
Novell NetWare锛�鍦∟etWare涓畨瑁匨ySQL
NOW()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
NO_AUTO_CREATE_USER SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_AUTO_VALUE_ON_ZERO SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_BACKSLASH_ESCAPES SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_DIR_IN_CREATE SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_FIELD_OPTIONS SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_KEY_OPTIONS SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_TABLE_OPTIONS SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_UNSIGNED_SUBTRACTION SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_ZERO_DATE SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NO_ZERO_IN_DATE SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
NUL锛�瀛楃涓�
NULL锛�Working with NULL鍊�锛�涓嶯ULL鍊兼湁鍏崇殑闂
testing for null锛�姣旇緝鍑芥暟鍜屾搷浣滅锛�鎺у埗娴佺▼鍑芥暟
NULL value锛�Working with NULL鍊�锛�NULL鍊�
NULL values
and AUTO_INCREMENT columns锛�涓嶯ULL鍊兼湁鍏崇殑闂
and indexes锛�CREATE TABLE璇硶
and TIMESTAMP columns锛�涓嶯ULL鍊兼湁鍏崇殑闂
vs. empty values锛�涓嶯ULL鍊兼湁鍏崇殑闂
NULLIF()锛�鎺у埗娴佺▼鍑芥暟
numbers锛�鏁板��
NUMERIC data type锛�鏁板�肩被鍨嬫杩�
numeric types锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
NumGeometries()锛�GeometryCollection鍑芥暟
NumInteriorRings()锛�Polygon鍑芥暟
NumPoints()锛�LineString鍑芥暟

O

OCT()锛�瀛楃涓插嚱鏁�
OCTET_LENGTH()锛�瀛楃涓插嚱鏁�
ODBC锛�MySQL Connector/ODBC
ODBC compatibility锛�璇嗗埆绗﹂檺鍒舵潯浠�锛�鏁板�肩被鍨嬫杩�锛�姣旇緝鍑芥暟鍜屾搷浣滅锛�CREATE TABLE璇硶锛�JOIN璇硶
odbcadmin program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
OLAP锛�GROUP BY淇敼绋嬪簭
OLD_PASSWORD()锛�鍔犲瘑鍑芥暟
ON DUPLICATE KEY锛�INSERT璇硶
one-database
mysql option锛�閫夐」
online location of manual锛�鍏充簬鏈墜鍐�
ONLY_FULL_GROUP_BY SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
OPEN锛�鍏夋爣OPEN璇彞
Open Source
defined锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
open tables锛�MySQL濡備綍璁＄畻鎵撳紑鐨勮〃锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
OpenGIS锛�鍓嶈█
opening
tables锛�MySQL濡備綍鎵撳紑鍜屽叧闂〃
opens锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
OpenSSL锛�浣跨敤瀹夊叏杩炴帴锛�Using yaSSL
open_files_limit variable锛�mysqlbinlog锛氱敤浜庡鐞嗕簩杩涘埗鏃ュ織鏂囦欢鐨勫疄鐢ㄥ伐鍏�
operating systems
file-size limits锛�MySQL琛ㄦ渶澶ц兘杈惧埌澶氬皯
supported锛�MySQL鏀寔鐨勬搷浣滅郴缁�
Windows versus Unix锛�Windows鐗圡ySQL鍚孶nix鐗圡ySQL瀵规瘮
operations
arithmetic锛�绠楁湳鎿嶄綔绗�
operators锛�鍑芥暟鍜屾搷浣滅
cast锛�绠楁湳鎿嶄綔绗�锛�Cast鍑芥暟鍜屾搷浣滅
logical锛�閫昏緫鎿嶄綔绗�
optimization
tips锛�鍏跺畠浼樺寲鎶�宸�
optimizations锛�MySQL鎬庢牱浼樺寲WHERE瀛愬彞锛�绱㈠紩鍚堝苟浼樺寲
OPTIMIZE TABLE锛�OPTIMIZE TABLE璇硶
optimizer
controlling锛�鎺у埗鏌ヨ浼樺寲鍣ㄧ殑鎬ц兘
optimizing
DISTINCT锛�MySQL濡備綍浼樺寲DISTINCT
filesort锛�MySQL濡備綍浼樺寲ORDER BY
GROUP BY锛�MySQL濡備綍浼樺寲GROUP BY
LEFT JOIN锛�MySQL濡備綍浼樺寲LEFT JOIN鍜孯IGHT JOIN
LIMIT锛�MySQL濡備綍浼樺寲LIMIT
tables锛�Table 浼樺寲
option files锛�浣跨敤閫夐」鏂囦欢锛�鎷掔粷璁块棶閿欒鐨勫師鍥�
options
command-line锛�mysqld鍛戒护琛岄�夐」
mysql锛�閫夐」
mysqladmin锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
configure锛�鍏稿瀷閰嶇疆閫夐」
embedded server锛�涓庡祵鍏ュ紡鏈嶅姟鍣ㄤ竴璧蜂娇鐢ㄧ殑閫夐」
libmysqld锛�涓庡祵鍏ュ紡鏈嶅姟鍣ㄤ竴璧蜂娇鐢ㄧ殑閫夐」
myisamchk锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
provided by MySQL锛�鏁欑▼
replication锛�澶嶅埗鐗规�у拰宸茬煡闂
OR锛�鏍规嵁涓や釜閿悳绱�锛�绱㈠紩鍚堝苟浼樺寲
bitwise锛�浣嶅嚱鏁�
logical锛�閫昏緫鎿嶄綔绗�
OR 绱㈠紩 Merge optimization锛�绱㈠紩鍚堝苟浼樺寲
Oracle compatibility锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�锛�GROUP BY锛堣仛鍚堬級鍑芥暟锛�DESCRIBE璇硶锛堣幏鍙栨湁鍏冲垪鐨勪俊鎭級
ORACLE SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
ORD()锛�瀛楃涓插嚱鏁�
ORDER BY锛�鍒嗙被琛�锛�ALTER TABLE璇硶锛�SELECT璇硶
aliases in锛�鍏锋湁闅愬惈瀛楁鐨凣ROUP BY
OUTFILE锛�SELECT璇硶
Overlaps()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
overview锛�涓�鑸俊鎭�

P

packages
list of锛�鏀寔MySQL鐨勮蒋浠跺寘
page-level locking锛�閿佸畾鏂规硶
pager
mysql option锛�閫夐」
parameters
server锛�璋冭妭鏈嶅姟鍣ㄥ弬鏁�
parentheses ( and )锛�鍦嗘嫭鍙�
PARTITION锛�鍒嗗尯
partition management锛�鍒嗗尯绠＄悊
partitioning锛�鍒嗗尯
partitioning by hash锛�HASH鍒嗗尯
partitioning by key锛�KEY鍒嗗尯
partitioning by linear hash锛�LINEAR HASH鍒嗗尯
partitioning by linear key锛�KEY鍒嗗尯
partitioning by list锛�LIST鍒嗗尯
partitioning by range锛�RANGE鍒嗗尯
partitioning concepts锛�MySQL涓殑鍒嗗尯姒傝堪
partitioning information commands锛�鑾峰彇鍏充簬鍒嗗尯鐨勪俊鎭�
partitioning support锛�MySQL涓殑鍒嗗尯姒傝堪
partitioning types锛�鍒嗗尯绫诲瀷
partitioning锛宎dvantages锛�MySQL涓殑鍒嗗尯姒傝堪
partitioning锛宔nabling锛�MySQL涓殑鍒嗗尯姒傝堪
partitions锛宎dding and dropping锛�鍒嗗尯绠＄悊
partitions锛宎nalyzing锛�鍒嗗尯缁存姢
partitions锛宑hecking锛�鍒嗗尯缁存姢
partitions锛宮anaging锛�鍒嗗尯绠＄悊
partitions锛宮odifying锛�鍒嗗尯绠＄悊
partitions锛宱ptimizing锛�鍒嗗尯缁存姢
partitions锛宺epairing锛�鍒嗗尯缁存姢
partitions锛宻plitting and merging锛�鍒嗗尯绠＄悊
password
mysql option锛�閫夐」
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
root user锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
password encryption
reversibility of锛�鍔犲瘑鍑芥暟
PASSWORD()锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�锛�璁剧疆璐︽埛瀵嗙爜锛�鍔犲瘑鍑芥暟锛�蹇界暐鐢ㄦ埛
passwords
for users锛�MySQL鐢ㄦ埛鍚嶅拰瀵嗙爜
forgotten锛�濡備綍澶嶄綅鏍圭敤鎴峰瘑鐮�
lost锛�濡備綍澶嶄綅鏍圭敤鎴峰瘑鐮�
resetting锛�濡備綍澶嶄綅鏍圭敤鎴峰瘑鐮�
security锛�鏉冮檺绯荤粺鐨勪綔鐢�
setting锛�璁剧疆璐︽埛瀵嗙爜锛�GRANT鍜孯EVOKE璇硶锛�SET PASSWORD璇硶
PATH environment variable锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL锛�璋冪敤MySQL绋嬪簭锛�鐜鍙橀噺
pattern matching锛�妯″紡鍖归厤
performance
benchmarks锛�浣跨敤鑷繁鐨勫熀鍑�
disk issues锛�纾佺洏浜嬪疁
estimating锛�浼拌鏌ヨ鎬ц兘
improving锛�澶嶅埗FAQ锛�浣夸綘鐨勬暟鎹敖鍙兘灏�
PERIOD_ADD()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
PERIOD_DIFF()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
Perl
installing锛�Perl瀹夎娉ㄦ剰浜嬮」
installing on Windows锛�鍦╓indows涓嬪畨瑁匒ctiveState Perl
Perl API锛�MySQL Perl API
Perl DBI/DBD
installation problems锛�浣跨敤Perl DBI/DBD鎺ュ彛鐨勯棶棰�
permission checks
effect on speed锛�浼樺寲SELECT璇彞鍜屽叾瀹冩煡璇�
perror锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
PHP API锛�MySQL PHP API
PI()锛�鏁板鍑芥暟
PIPES_AS_CONCAT SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
POINT data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
point in time recovery锛�鑷姩鎭㈠
Point()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
PointFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
PointFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
PointN()锛�LineString鍑芥暟
PointOnSurface()锛�MultiPolygon鍑芥暟
PolyFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
PolyFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
POLYGON data type锛�MySQL绌洪棿鏁版嵁绫诲瀷
Polygon()锛�浣跨敤MySQL鍑芥暟鍒涘缓鍑犱綍鍊�
PolygonFromText()锛�浣跨敤WKT鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
PolygonFromWKB()锛�浣跨敤WKB鍑芥暟鍒涘缓Geometry锛堝嚑浣曪級鍊�
port
mysql option锛�閫夐」
portability锛�涓哄彲绉绘鎬ц璁″簲鐢ㄧ▼搴�
types锛�浣跨敤鏉ヨ嚜鍏朵粬鏁版嵁搴撳紩鎿庣殑鍒楃被鍨�
porting
to other systems锛�绉绘鍒板叾浠栫郴缁�
POSITION()锛�瀛楃涓插嚱鏁�
post-install
multiple servers锛�鍦ㄥ悓涓�鍙版満鍣ㄤ笂杩愯澶氫釜MySQL鏈嶅姟鍣�
post-installation
setup and testing锛�瀹夎鍚庣殑璁剧疆鍜屾祴璇�
PostgreSQL compatibility锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�
POSTGRESQL SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
POW()锛�鏁板鍑芥暟
POWER()锛�鏁板鍑芥暟
precision
arithmetic锛�绮惧害鏁板
precision math锛�绮惧害鏁板
PREPARE锛�鐢ㄤ簬棰勫鐞嗚鍙ョ殑SQL璇硶
XA transactions锛�XA浜嬪姟SQL璇硶
PRIMARY KEY锛�ALTER TABLE璇硶锛�CREATE TABLE璇硶
constraint锛�PRIMARY KEY鍜孶NIQUE绱㈠紩绾︽潫
primary key
deleting锛�ALTER TABLE璇硶
privilege
changes锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
privilege information
location锛�MySQL鎻愪緵鐨勬潈闄�
privilege system锛�鏉冮檺绯荤粺鐨勪綔鐢�
described锛�鏉冮檺绯荤粺宸ヤ綔鍘熺悊
privileges
access锛�MySQL璁块棶鏉冮檺绯荤粺
adding锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
default锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
deleting锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
display锛�SHOW GRANTS璇硶
dropping锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
granting锛�GRANT鍜孯EVOKE璇硶
revoking锛�GRANT鍜孯EVOKE璇硶
problems
access denied errors锛�鎷掔粷璁块棶
common errors锛�闂鍜屽父瑙侀敊璇�
compiling锛�澶勭悊MySQL缂栬瘧闂
DATE columns锛�浣跨敤DATE鍒楁柟闈㈢殑闂
date values锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
installing on IBM-AIX锛�IBM-AIX娉ㄦ剰浜嬮」
installing on Solaris锛�Solaris娉ㄦ剰浜嬮」
installing Perl锛�浣跨敤Perl DBI/DBD鎺ュ彛鐨勯棶棰�
linking锛�涓嶮ySQL瀹㈡埛绔簱鐨勯摼鎺ラ棶棰�
ODBC锛�濡備綍閫氭姤MyODBC闂鎴栫己闄�
reporting锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
starting the server锛�鍚姩MySQL鏈嶅姟鍣ㄤ互鍙婂叾鏁呴殰璇婃柇鍜屾帓闄�
table locking锛�琛ㄩ攣瀹氫簨瀹�
time zone锛�鏃跺尯闂
PROCEDURE锛�SELECT璇硶
procedures
adding锛�涓篗ySQL娣诲姞鏂版楠�
stored锛�瀛樺偍绋嬪簭鍜岃Е鍙戠▼搴�锛�瀛樺偍绋嬪簭鍜屽嚱鏁�
process support锛�MySQL鏀寔鐨勬搷浣滅郴缁�
processes
display锛�SHOW PROCESSLIST璇硶
processing
arguments锛�UDF鍙傞噺澶勭悊
PROCESSLIST锛�SHOW PROCESSLIST璇硶
program variables
setting锛�浣跨敤閫夐」璁剧疆绋嬪簭鍙橀噺
programs
client锛�鍒涘缓瀹㈡埛绔▼搴�
crash-me锛�涓哄彲绉绘鎬ц璁″簲鐢ㄧ▼搴�
list of锛�鏈嶅姟鍣ㄧ鑴氭湰鍜屽疄鐢ㄥ伐鍏锋杩�
prompt
mysql option锛�閫夐」
prompts
meanings锛�杈撳叆鏌ヨ
pronunciation
MySQL锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
protocol
mysql option锛�閫夐」
PURGE MASTER LOGS锛�PURGE MASTER LOGS璇硶
Python API锛�MySQL Python API

Q

QUARTER()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
queries
entering锛�杈撳叆鏌ヨ
estimating performance锛�浼拌鏌ヨ鎬ц兘
examples锛�甯哥敤鏌ヨ鐨勪緥瀛�
speed of锛�浼樺寲SELECT璇彞鍜屽叾瀹冩煡璇�
Twin Studies project锛�瀛敓椤圭洰鐨勬煡璇�
Query Cache锛�MySQL鏌ヨ楂橀�熺紦鍐�
query log锛�閫氱敤鏌ヨ鏃ュ織
questions锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
answering锛�鍦ㄩ偖浠跺垪琛ㄤ笂鍥炵瓟闂鐨勬寚鍗�
quick
mysql option锛�閫夐」
QUOTE()锛�瀛楃涓插嚱鏁�
quotes
in strings锛�瀛楃涓�
quoting锛�瀛楃涓�
quoting binary data锛�瀛楃涓�
quoting of identifiers锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�

R

RADIANS()锛�鏁板鍑芥暟
RAND()锛�鏁板鍑芥暟
range partitioning锛�RANGE鍒嗗尯
range partitions锛宎dding and dropping锛�RANGE鍜孡IST鍒嗗尯鐨勭鐞�
range partitions锛宮anaging锛�RANGE鍜孡IST鍒嗗尯鐨勭鐞�
raw
mysql option锛�閫夐」
re-creating
grant tables锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
read_buffer_size myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
REAL data type锛�鏁板�肩被鍨嬫杩�
REAL_AS_FLOAT SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
reconfiguring锛�澶勭悊MySQL缂栬瘧闂
reconnect
mysql option锛�閫夐」
RECOVER
XA transactions锛�XA浜嬪姟SQL璇硶
recovery
from crash锛�灏唌yisamchk鐢ㄤ簬宕╂簝鎭㈠
point in time锛�鑷姩鎭㈠
reducing
data size锛�浣夸綘鐨勬暟鎹敖鍙兘灏�
references锛�ALTER TABLE璇硶
ref_or_null锛�MySQL濡備綍浼樺寲IS NULL
regex锛�MySQL姝ｅ垯琛ㄨ揪寮�
REGEXP锛�瀛楃涓叉瘮杈冨嚱鏁�
regular expression syntax
described锛�MySQL姝ｅ垯琛ㄨ揪寮�
Related()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
relational databases
defined锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
release numbers锛�閫夋嫨瑕佸畨瑁呯殑MySQL鍒嗗彂鐗�
RELEASE SAVEPOINT锛�SAVEPOINT鍜孯OLLBACK TO SAVEPOINT璇硶
releases
naming scheme锛�閫夋嫨瑕佸畨瑁呯殑MySQL鐗堟湰
testing锛�閫夋嫨瑕佸畨瑁呯殑MySQL鐗堟湰
updating锛�濡備綍鍙戝竷鏇存柊浠ュ強浣曟椂鍙戝竷鏇存柊
RELEASE_LOCK()锛�鍏朵粬鍑芥暟
RENAME TABLE锛�RENAME TABLE璇硶
RENAME USER锛�RENAME USER璇硶
renaming user accounts锛�RENAME USER璇硶
reordering
columns锛�濡備綍鏇存敼琛ㄤ腑鐨勫垪椤哄簭
repair options
myisamchk锛�myisamchk鐨勪慨澶嶉�夐」
REPAIR TABLE锛�REPAIR TABLE璇硶
repairing
tables锛�濡備綍淇琛�
REPEAT锛�REPEAT璇彞
REPEAT()锛�瀛楃涓插嚱鏁�
replace锛�瀹㈡埛绔剼鏈拰瀹炵敤宸ュ叿姒傝堪
REPLACE锛�REPLACE璇硶
REPLACE ... SELECT锛�INSERT璇硶
REPLACE()锛�瀛楃涓插嚱鏁�
replication锛�MySQL涓殑澶嶅埗
replication limitations锛�澶嶅埗鐗规�у拰宸茬煡闂
replication masters
commands锛�鐢ㄤ簬鎺у埗涓绘湇鍔″櫒鐨凷QL璇彞
replication options锛�澶嶅埗鐗规�у拰宸茬煡闂
replication slaves
commands锛�鐢ㄤ簬鎺у埗浠庢湇鍔″櫒鐨凷QL璇彞
reporting
bugs锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
Connector/ODBC problems锛�濡備綍閫氭姤MyODBC闂鎴栫己闄�
errors锛�涓�鑸俊鎭�锛�MySQL閭欢鍒楄〃
MyODBC problems锛�濡備綍閫氭姤MyODBC闂鎴栫己闄�
REQUIRE GRANT option锛�SSL GRANT 閫夐」锛�GRANT鍜孯EVOKE璇硶
reserved words
exceptions锛�MySQL涓繚鐣欏瓧鐨勫鐞�
RESET MASTER锛�RESET MASTER璇硶
RESET SLAVE锛�RESET SLAVE璇硶
restarting
the server锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
RESTORE TABLE锛�RESTORE TABLE璇硶
restrictions
server-side cursors锛�瀵规湇鍔″櫒绔厜鏍囩殑闄愬埗
stored routines锛�瀵瑰瓨鍌ㄥ瓙绋嬪簭鍜岃Е鍙戠▼搴忕殑闄愬埗
subqueries锛�瀵瑰瓙鏌ヨ鐨勯檺鍒�
triggers锛�瀵瑰瓨鍌ㄥ瓙绋嬪簭鍜岃Е鍙戠▼搴忕殑闄愬埗
views锛�瀵硅鍥剧殑闄愬埗
retrieving
data from tables锛�浠庤〃妫�绱俊鎭�
return (\r)锛�瀛楃涓�
return values
UDFs锛�UDF杩斿洖鍊煎拰閿欒澶勭悊
REVERSE()锛�瀛楃涓插嚱鏁�
REVOKE锛�GRANT鍜孯EVOKE璇硶
revoking
privileges锛�GRANT鍜孯EVOKE璇硶
RIGHT JOIN锛�JOIN璇硶
RIGHT OUTER JOIN锛�JOIN璇硶
RIGHT()锛�瀛楃涓插嚱鏁�
RLIKE锛�瀛楃涓叉瘮杈冨嚱鏁�
ROLLBACK锛�浜嬪姟鍜屽師瀛愭搷浣�锛�START TRANSACTION锛孋OMMIT鍜孯OLLBACK璇硶
XA transactions锛�XA浜嬪姟SQL璇硶
ROLLBACK TO SAVEPOINT锛�SAVEPOINT鍜孯OLLBACK TO SAVEPOINT璇硶
ROLLUP锛�GROUP BY淇敼绋嬪簭
root password锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
root user
password resetting锛�濡備綍澶嶄綅鏍圭敤鎴峰瘑鐮�
ROUND()锛�鏁板鍑芥暟
rounding锛�绮惧害鏁板
rounding errors锛�鏁板�肩被鍨嬫杩�
ROUTINES
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA ROUTINES琛�
row-level locking锛�閿佸畾鏂规硶
rows
counting锛�璁℃暟琛�
deleting锛�浠庣浉鍏宠〃鍒犻櫎琛�
locking锛�浜嬪姟鍜屽師瀛愭搷浣�
matching problems锛�瑙ｅ喅涓庝笉鍖归厤琛屾湁鍏崇殑闂
selecting锛�閫夋嫨鐗规畩琛�
sorting锛�鍒嗙被琛�
ROW_COUNT()锛�淇℃伅鍑芥暟
RPAD()锛�瀛楃涓插嚱鏁�
RPM file锛�鍦↙inux涓嬪畨瑁匨ySQL
RPM Package Manager锛�鍦↙inux涓嬪畨瑁匨ySQL
RTRIM()锛�瀛楃涓插嚱鏁�
RTS-threads锛�鍏充簬RTS绾跨▼鐨勬敞閲�
running
ANSI mode锛�鍦ˋNSI妯″紡涓嬭繍琛孧ySQL
batch mode锛�鍦ㄦ壒澶勭悊妯″紡涓嬩娇鐢╩ysql
multiple servers锛�鍦ㄥ悓涓�鍙版満鍣ㄤ笂杩愯澶氫釜MySQL鏈嶅姟鍣�
queries锛�杈撳叆鏌ヨ
running configure after prior invocation锛�澶勭悊MySQL缂栬瘧闂

S

safe-updates
mysql option锛�閫夐」
safe-updates option锛�浣跨敤--safe-updates閫夐」
Sakila锛�MySQL鐨勫巻鍙�
SAVEPOINT锛�SAVEPOINT鍜孯OLLBACK TO SAVEPOINT璇硶
scale
arithmetic锛�绮惧害鏁板
schema
altering锛�ALTER DATABASE璇硶
creating锛�CREATE DATABASE璇硶
deleting锛�DROP DATABASE璇硶
SCHEMA()锛�淇℃伅鍑芥暟
SCHEMATA
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA SCHEMATA琛�
SCHEMA_PRIVILEGES
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA SCHEMA_PRIVILEGES琛�
script files锛�鍦ㄦ壒澶勭悊妯″紡涓嬩娇鐢╩ysql
scripts
mysqlbug锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
mysql_install_db锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�
searching
and case sensitivity锛�鎼滅储涓殑澶у皬鍐欐晱鎰熸��
full-text锛�鍏ㄦ枃鎼滅储鍔熻兘
MySQL Web pages锛�璇锋暀闂鎴栭�氭姤缂洪櫡
two keys锛�鏍规嵁涓や釜閿悳绱�
SECOND()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
secure-auth
mysql option锛�閫夐」
security
against attackers锛�浣縈ySQL鍦ㄦ敾鍑昏�呴潰鍓嶄繚鎸佸畨鍏�
security system锛�MySQL璁块棶鏉冮檺绯荤粺
SEC_TO_TIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
SELECT
LIMIT锛�SELECT璇硶
optimizing锛�EXPLAIN璇硶锛堣幏鍙朣ELECT鐩稿叧淇℃伅锛�
Query Cache锛�MySQL鏌ヨ楂橀�熺紦鍐�
SELECT INTO锛�SELECT ... INTO璇彞
SELECT INTO TABLE锛�SELECT INTO TABLE
SELECT speed锛�SELECT鏌ヨ鐨勯�熷害
selecting
databases锛�鍒涘缓骞堕�夋嫨鏁版嵁搴�
select_limit variable锛�閫夐」
SEQUENCE锛�浣跨敤AUTO_INCREMENT
sequence emulation锛�淇℃伅鍑芥暟
sequences锛�浣跨敤AUTO_INCREMENT
server
connecting锛�杩炴帴涓庢柇寮�鏈嶅姟鍣�锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�
debugging锛�璋冭瘯MySQL鏈嶅姟鍣�
disconnecting锛�杩炴帴涓庢柇寮�鏈嶅姟鍣�
restart锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
shutdown锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
starting锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
starting and stopping锛�鑷姩鍚姩鍜屽仠姝ySQL
starting problems锛�鍚姩MySQL鏈嶅姟鍣ㄤ互鍙婂叾鏁呴殰璇婃柇鍜屾帓闄�
server variables锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�锛�绯荤粺鍙橀噺锛�SHOW VARIABLES璇硶
server-side cursor restrictions锛�瀵规湇鍔″櫒绔厜鏍囩殑闄愬埗
servers
multiple锛�鍦ㄥ悓涓�鍙版満鍣ㄤ笂杩愯澶氫釜MySQL鏈嶅姟鍣�
SESSION_USER()锛�淇℃伅鍑芥暟
SET锛�SET璇硶锛�Variable SET Statement
size锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
SET data type锛�瀛楃涓茬被鍨嬫杩�锛�SET绫诲瀷
SET GLOBAL SQL_SLAVE_SKIP_COUNTER锛�SET GLOBAL SQL_SLAVE_SKIP_COUNTER璇硶
SET OPTION锛�SET璇硶
SET PASSWORD锛�SET PASSWORD璇硶
SET PASSWORD statement锛�璁剧疆璐︽埛瀵嗙爜
SET SQL_LOG_BIN锛�SET SQL_LOG_BIN璇硶
SET TRANSACTION锛�SET TRANSACTION璇硶
setting
passwords锛�璁剧疆璐︽埛瀵嗙爜
setting passwords锛�SET PASSWORD璇硶
setting program variables锛�浣跨敤閫夐」璁剧疆绋嬪簭鍙橀噺
setup
post-installation锛�瀹夎鍚庣殑璁剧疆鍜屾祴璇�
SHA()锛�鍔犲瘑鍑芥暟
SHA1()锛�鍔犲瘑鍑芥暟
shell syntax锛�鏈墜鍐岄噰鐢ㄧ殑鎯緥
SHOW BINARY LOGS锛�SHOW MASTER LOGS璇硶
SHOW BINLOG EVENTS锛�SHOW璇硶锛�SHOW BINLOG EVENTS璇硶
SHOW CHARACTER SET锛�SHOW CHARACTER SET璇硶
SHOW COLLATION锛�SHOW COLLATION Syntax
SHOW COLUMNS锛�SHOW璇硶锛�SHOW COLUMNS璇硶
SHOW CREATE DATABASE锛�SHOW璇硶锛�SHOW CREATE DATABASE璇硶
SHOW CREATE FUNCTION锛�SHOW CREATE PROCEDURE鍜孲HOW CREATE FUNCTION
SHOW CREATE PROCEDURE锛�SHOW CREATE PROCEDURE鍜孲HOW CREATE FUNCTION
SHOW CREATE SCHEMA锛�SHOW璇硶锛�SHOW CREATE DATABASE璇硶
SHOW CREATE TABLE锛�SHOW璇硶锛�SHOW CREATE TABLE璇硶
SHOW CREATE VIEW锛�SHOW CREATE VIEW璇硶
SHOW DATABASES锛�SHOW璇硶锛�SHOW DATABASES璇硶
SHOW ENGINE锛�SHOW璇硶锛�SHOW ENGINE璇硶
SHOW ENGINES锛�SHOW璇硶锛�SHOW ENGINES璇硶
SHOW ERRORS锛�SHOW璇硶锛�SHOW ERRORS璇硶
SHOW extensions锛�SHOW璇彞鐨勬墿灞�
SHOW FIELDS锛�SHOW璇硶
SHOW FUNCTION STATUS锛�SHOW PROCEDURE STATUS鍜孲HOW FUNCTION STATUS
SHOW GRANTS锛�SHOW璇硶锛�SHOW GRANTS璇硶
SHOW INDEX锛�SHOW璇硶锛�SHOW INDEX璇硶
SHOW INNODB STATUS锛�SHOW璇硶
SHOW KEYS锛�SHOW璇硶锛�SHOW INDEX璇硶
SHOW MASTER LOGS锛�SHOW璇硶锛�SHOW MASTER LOGS璇硶
SHOW MASTER STATUS锛�SHOW璇硶锛�SHOW MASTER STATUS璇硶
SHOW OPEN TABLES锛�SHOW璇硶锛�SHOW OPEN TABLES璇硶
SHOW PRIVILEGES锛�SHOW璇硶锛�SHOW PRIVILEGES璇硶
SHOW PROCEDURE STATUS锛�SHOW PROCEDURE STATUS鍜孲HOW FUNCTION STATUS
SHOW PROCESSLIST锛�SHOW璇硶锛�SHOW PROCESSLIST璇硶
SHOW SCHEMAS锛�SHOW璇硶锛�SHOW DATABASES璇硶
SHOW SLAVE HOSTS锛�SHOW璇硶锛�SHOW SLAVE HOSTS璇硶
SHOW SLAVE STATUS锛�SHOW璇硶锛�SHOW SLAVE STATUS璇硶
SHOW STATUS锛�SHOW璇硶
SHOW STORAGE ENGINES锛�SHOW ENGINES璇硶
SHOW TABLE STATUS锛�SHOW璇硶
SHOW TABLE TYPES锛�SHOW璇硶锛�SHOW ENGINES璇硶
SHOW TABLES锛�SHOW璇硶锛�SHOW TABLES璇硶
SHOW TRIGGERS锛�SHOW璇硶锛�SHOW TRIGGERS璇硶
SHOW VARIABLES锛�SHOW璇硶
SHOW WARNINGS锛�SHOW璇硶锛�SHOW WARNINGS璇硶
SHOW with WHERE锛�INFORMATION_SCHEMA淇℃伅鏁版嵁搴�锛�SHOW璇彞鐨勬墿灞�
show-warnings
mysql option锛�閫夐」
shutdown_timeout variable锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
shutting down
the server锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
sigint-ignore
mysql option锛�閫夐」
SIGN()锛�鏁板鍑芥暟
silent
mysql option锛�閫夐」
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
silent column changes锛�娌夊瘋鐨勫垪瑙勬牸鍙樻洿
SIN()锛�鏁板鍑芥暟
single quote (\')锛�瀛楃涓�
size of tables锛�MySQL琛ㄦ渶澶ц兘杈惧埌澶氬皯
sizes
display锛�鍒楃被鍨�
skip-column-names
mysql option锛�閫夐」
skip-line-numbers
mysql option锛�閫夐」
SLEEP()锛�鍏朵粬鍑芥暟
slow queries锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
slow query log锛�鎱㈤�熸煡璇㈡棩蹇�
SMALLINT data type锛�鏁板�肩被鍨嬫杩�
socket
mysql option锛�閫夐」
socket location
changing锛�鍏稿瀷閰嶇疆閫夐」
Solaris installation problems锛�Solaris娉ㄦ剰浜嬮」
Solaris troubleshooting锛�澶勭悊MySQL缂栬瘧闂
Solaris x86_64 issues锛�InnoDB鎬ц兘璋冭妭鎻愮ず
sorting
character sets锛�鏁版嵁鍜屾帓搴忕敤瀛楃闆�
data锛�鍒嗙被琛�
grant tables锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
table rows锛�鍒嗙被琛�
sort_buffer_size myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
sort_key_blocks myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
SOUNDEX()锛�瀛楃涓插嚱鏁�
SOUNDS LIKE锛�瀛楃涓插嚱鏁�
source distribution
installing锛�浣跨敤婧愮爜鍒嗗彂鐗堝畨瑁匨ySQL
source distributions
on Linux锛�Linux婧愮爜鍒嗗彂鐗堣鏄�
SPACE()锛�瀛楃涓插嚱鏁�
MySQL涓殑绌洪棿鎵╁睍锛�鍓嶈█
speed
compiling锛�缂栬瘧鍜岄摼鎺ユ�庢牱褰卞搷MySQL鐨勯�熷害
increasing with replication锛�MySQL涓殑澶嶅埗
inserting锛�INSERT璇彞鐨勯�熷害
linking锛�缂栬瘧鍜岄摼鎺ユ�庢牱褰卞搷MySQL鐨勯�熷害
of queries锛�浼樺寲SELECT璇彞鍜屽叾瀹冩煡璇�锛�SELECT鏌ヨ鐨勯�熷害
SQL
defined锛�MySQL鏁版嵁搴撶鐞嗙郴缁熸杩�
SQL commands
replication masters锛�鐢ㄤ簬鎺у埗涓绘湇鍔″櫒鐨凷QL璇彞
replication slaves锛�鐢ㄤ簬鎺у埗浠庢湇鍔″櫒鐨凷QL璇彞
SQL-92
extensions to锛�MySQL鏍囧噯鐨勫吋瀹规��
SQL_BIG_RESULT锛�SELECT璇硶
SQL_BUFFER_RESULT锛�SELECT璇硶
SQL_CACHE锛�鏌ヨ楂橀�熺紦鍐睸ELECT閫夐」锛�SELECT璇硶
SQL_CALC_FOUND_ROWS锛�SELECT璇硶
SQL_NO_CACHE锛�鏌ヨ楂橀�熺紦鍐睸ELECT閫夐」锛�SELECT璇硶
SQL_SMALL_RESULT锛�SELECT璇硶
sql_yacc.cc problems锛�澶勭悊MySQL缂栬瘧闂
SQRT()锛�鏁板鍑芥暟
square brackets锛�鍒楃被鍨�
SRID()锛�閫氱敤鍑犱綍鍑芥暟
SSH锛�鐢⊿SH浠ヨ繙绋嬫柟寮忎粠Windows杩炴帴鍒癕ySQL
SSL and X509 Basics锛�浣跨敤瀹夊叏杩炴帴
SSL command-line options锛�SSL鍛戒护琛岄�夐」
SSL related options锛�SSL GRANT 閫夐」锛�GRANT鍜孯EVOKE璇硶
stability锛�MySQL绋冲畾鎬�
standard SQL
extensions to锛�MySQL鏍囧噯鐨勫吋瀹规��
Standard SQL
differences from锛�GRANT鍜孯EVOKE璇硶
standards compatibility锛�MySQL鏍囧噯鐨勫吋瀹规��
START
XA transactions锛�XA浜嬪姟SQL璇硶
START SLAVE锛�START SLAVE璇硶
START TRANSACTION锛�START TRANSACTION锛孋OMMIT鍜孯OLLBACK璇硶
starting
comments锛�鈥�--鈥欎綔涓烘敞閲婅捣濮嬫爣璁�
mysqld锛�濡備綍浠ユ櫘閫氱敤鎴疯韩浠借繍琛孧ySQL
the server锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
the server automatically锛�鑷姩鍚姩鍜屽仠姝ySQL
Starting many servers锛�鍦ㄥ悓涓�鍙版満鍣ㄤ笂杩愯澶氫釜MySQL鏈嶅姟鍣�
StartPoint()锛�LineString鍑芥暟
startup options
default锛�浣跨敤閫夐」鏂囦欢
startup parameters锛�璋冭妭鏈嶅姟鍣ㄥ弬鏁�
mysql锛�閫夐」
mysqladmin锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
tuning锛�绯荤粺鍥犵礌鍜屽惎鍔ㄥ弬鏁扮殑璋冭妭
statements
GRANT锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
INSERT锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
statically
compiling锛�鍏稿瀷閰嶇疆閫夐」
STATISTICS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA STATISTICS琛�
stats_method myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」
status
tables锛�SHOW TABLE STATUS璇硶
status command
results锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
status variables锛�鏈嶅姟鍣ㄧ姸鎬佸彉閲�锛�SHOW STATUS璇硶
STD()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
STDDEV()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
STDDEV_POP()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
STDDEV_SAMP()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
STOP SLAVE锛�STOP SLAVE璇硶
 
stopping
the server锛�鑷姩鍚姩鍜屽仠姝ySQL
stopword list
user-defined锛�寰皟MySQL鍏ㄦ枃鎼滅储
storage engine
ARCHIVE锛�ARCHIVE瀛樺偍寮曟搸
storage engines
choosing锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
storage of data锛�璁捐閫夋嫨
storage requirements
column type锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
storage space
minimising锛�浣夸綘鐨勬暟鎹敖鍙兘灏�
stored procedures锛�瀛樺偍绋嬪簭鍜屽嚱鏁�
stored procedures and triggers
defined锛�瀛樺偍绋嬪簭鍜岃Е鍙戠▼搴�
stored routine restrictions锛�瀵瑰瓨鍌ㄥ瓙绋嬪簭鍜岃Е鍙戠▼搴忕殑闄愬埗
STRAIGHT_JOIN锛�SELECT璇硶锛�JOIN璇硶
STRCMP()锛�瀛楃涓叉瘮杈冨嚱鏁�
STRICT SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
STRICT_ALL_TABLES SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
STRICT_TRANS_TABLES SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
string collating锛�瀛楃涓叉瘮杈冩敮鎸�
string comparison functions锛�瀛楃涓叉瘮杈冨嚱鏁�
string comparisons
case sensitivity锛�瀛楃涓叉瘮杈冨嚱鏁�
string functions锛�瀛楃涓插嚱鏁�
string literal introducer锛�瀛楃涓�锛�瀛楃涓叉枃瀛楀瓧绗﹂泦鍜屾牎瀵�
string types锛�String绫诲瀷
strings
defined锛�鏂囧瓧鍊�
escaping characters锛�鏂囧瓧鍊�
non-delimited锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
striping
defined锛�纾佺洏浜嬪疁
STR_TO_DATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
SUBDATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
subpartitioning锛�瀛愬垎鍖�
subpartitions锛�瀛愬垎鍖�
subqueries锛�Subquery璇硶
subquery锛�Subquery璇硶
subquery restrictions锛�瀵瑰瓙鏌ヨ鐨勯檺鍒�
subselects锛�Subquery璇硶
SUBSTR()锛�瀛楃涓插嚱鏁�
SUBSTRING()锛�瀛楃涓插嚱鏁�
SUBSTRING_INDEX()锛�瀛楃涓插嚱鏁�
SUBTIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
subtraction (-)锛�绠楁湳鎿嶄綔绗�
SUM()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
SUM(DISTINCT)锛�GROUP BY锛堣仛鍚堬級鍑芥暟
superuser锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
support
for operating systems锛�MySQL鏀寔鐨勬搷浣滅郴缁�
mailing address锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
suppression
default values锛�瀵规棤鏁堟暟鎹殑绾︽潫
Sybase compatibility锛�USE璇硶
symbolic links锛�浣跨敤绗﹀彿閾炬帴锛�鍦╓indows骞冲彴涓婁娇鐢ㄥ叧浜庢暟鎹簱鐨勭鍙烽摼鎺�
SymDifference()锛�Spatial 鎿嶄綔绗�
syntax
regular expression锛�MySQL姝ｅ垯琛ㄨ揪寮�
SYSDATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
system
privilege锛�鏉冮檺绯荤粺鐨勪綔鐢�
security锛�涓�鑸畨鍏ㄩ棶棰�
system optimization锛�绯荤粺鍥犵礌鍜屽惎鍔ㄥ弬鏁扮殑璋冭妭
system table锛�EXPLAIN璇硶锛堣幏鍙朣ELECT鐩稿叧淇℃伅锛�
system variables锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�锛�绯荤粺鍙橀噺锛�SHOW VARIABLES璇硶
SYSTEM_USER()锛�淇℃伅鍑芥暟

T

tab (\t)锛�瀛楃涓�
table
changing锛�ALTER TABLE璇硶锛�涓嶢LTER TABLE鏈夊叧鐨勯棶棰�
deleting锛�DROP TABLE璇硶
mysql option锛�閫夐」
table aliases锛�SELECT璇硶
table cache锛�MySQL濡備綍鎵撳紑鍜屽叧闂〃
table is full锛�SET璇硶锛�琛ㄥ凡婊�
table names
case sensitivity锛�璇嗗埆绗﹀ぇ灏忓啓鏁忔劅鎬�
case-sensitivity锛�MySQL瀵规爣鍑哠QL鐨勬墿灞�
Table scans
avoiding锛�濡備綍閬垮厤琛ㄦ壂鎻�
table types
choosing锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
table-level locking锛�閿佸畾鏂规硶
tables
ARCHIVE锛�ARCHIVE瀛樺偍寮曟搸
BDB锛�BDB (BerkeleyDB)瀛樺偍寮曟搸
Berkeley DB锛�BDB (BerkeleyDB)瀛樺偍寮曟搸
BLACKHOLE锛�BLACKHOLE瀛樺偍寮曟搸
changing column order锛�濡備綍鏇存敼琛ㄤ腑鐨勫垪椤哄簭
checking锛�鐢ㄤ簬myisamchk鐨勬鏌ラ�夐」
closing锛�MySQL濡備綍鎵撳紑鍜屽叧闂〃
compressed format锛�鍘嬬缉琛ㄧ壒鎬�
constant锛�EXPLAIN璇硶锛堣幏鍙栧叧浜嶴ELECT鐨勪俊鎭級锛�MySQL鎬庢牱浼樺寲WHERE瀛愬彞
copying锛�CREATE TABLE璇硶
counting rows锛�璁℃暟琛�
creating锛�鍒涘缓琛�
CSV锛�CSV瀛樺偍寮曟搸
defragment锛�寤虹珛琛ㄧ淮鎶よ鍒�锛�鍔ㄦ�佽〃鐗规��
defragmenting锛�OPTIMIZE TABLE璇硶
deleting rows锛�浠庣浉鍏宠〃鍒犻櫎琛�
displaying status锛�SHOW TABLE STATUS璇硶
dynamic锛�鍔ㄦ�佽〃鐗规��
error checking锛�濡備綍妫�鏌yISAM琛ㄧ殑閿欒
EXAMPLE锛�EXAMPLE瀛樺偍寮曟搸
FEDERATED锛�FEDERATED瀛樺偍寮曟搸
flush锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
fragmentation锛�OPTIMIZE TABLE璇硶
grant锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
HEAP锛�MEMORY (HEAP)瀛樺偍寮曟搸
host锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
improving performance锛�浣夸綘鐨勬暟鎹敖鍙兘灏�
information锛�鑾峰彇鍏充簬琛ㄧ殑淇℃伅
information about锛�鑾峰緱鏁版嵁搴撳拰琛ㄧ殑淇℃伅
InnoDB锛�InnoDB瀛樺偍寮曟搸
loading data锛�灏嗘暟鎹鍏ヨ〃涓�
maintenance regimen锛�寤虹珛琛ㄧ淮鎶よ鍒�
maximum size锛�MySQL琛ㄦ渶澶ц兘杈惧埌澶氬皯
MEMORY锛�MEMORY (HEAP)瀛樺偍寮曟搸
MERGE锛�MERGE瀛樺偍寮曟搸
merging锛�MERGE瀛樺偍寮曟搸
multiple锛�浣跨敤1涓互涓婄殑琛�
 
MyISAM锛�MyISAM瀛樺偍寮曟搸
names锛�鏁版嵁搴撱�佽〃銆佺储寮曘�佸垪鍜屽埆鍚�
open锛�MySQL濡備綍璁＄畻鎵撳紑鐨勮〃
opening锛�MySQL濡備綍鎵撳紑鍜屽叧闂〃
optimizing锛�Table 浼樺寲
partitioning锛�MERGE瀛樺偍寮曟搸
repairing锛�濡備綍淇琛�
retrieving data锛�浠庤〃妫�绱俊鎭�
selecting columns锛�閫夋嫨鐗规畩鍒�
selecting rows锛�閫夋嫨鐗规畩琛�
sorting rows锛�鍒嗙被琛�
symbolic links锛�鍦║nix骞冲彴涓婁娇鐢ㄨ〃鐨勭鍙烽摼鎺�
 
system锛�EXPLAIN璇硶锛堣幏鍙朣ELECT鐩稿叧淇℃伅锛�
too many锛�鍦ㄥ悓涓�涓暟鎹簱涓垱寤哄涓〃鐨勭己闄�
unique ID for last row锛�濡備綍鑾峰緱涓婃鎻掑叆琛岀殑鍞竴ID
updating锛�浜嬪姟鍜屽師瀛愭搷浣�
TABLES
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA TABLES琛�
table_cache锛�MySQL濡備綍鎵撳紑鍜屽叧闂〃
TABLE_PRIVILEGES
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA TABLE_PRIVILEGES琛�
TAN()锛�鏁板鍑芥暟
tar
problems on Solaris锛�Solaris娉ㄦ剰浜嬮」
Tcl API锛�MySQL Tcl API
tcp-ip
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
TCP/IP锛�閫夋嫨MySQL鏈嶅姟鍣ㄧ被鍨�锛�娴嬭瘯MySQL瀹夎
technical support
mailing address锛�濡備綍閫氭姤缂洪櫡鍜岄棶棰�
tee
mysql option锛�閫夐」
temporary file
write access锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�
temporary tables
problems锛�TEMPORARY TABLE闂
terminal monitor
defined锛�鏁欑▼
testing
connection to the server锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
installation锛�Unix涓嬪畨瑁呭悗鐨勮繃绋�
of MySQL releases锛�閫夋嫨瑕佸畨瑁呯殑MySQL鐗堟湰
post-installation锛�瀹夎鍚庣殑璁剧疆鍜屾祴璇�
testing mysqld
mysqltest锛�MySQL娴嬭瘯濂椾欢
TEXT
size锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
TEXT columns
default values锛�BLOB鍜孴EXT绫诲瀷
indexing锛�鍒楃储寮�锛�CREATE TABLE璇硶
TEXT data type锛�瀛楃涓茬被鍨嬫杩�锛�BLOB鍜孴EXT绫诲瀷
thread packages
differences between锛�绾跨▼杞欢鍖呬箣闂寸殑宸紓
thread support锛�MySQL鏀寔鐨勬搷浣滅郴缁�
non-native锛�MIT-pthreads娉ㄦ剰浜嬮」
threaded clients锛�濡備綍鐢熸垚绾跨▼寮忓鎴风
threads锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�锛�SHOW PROCESSLIST璇硶锛�MySQL鍐呴儴鎺т欢
display锛�SHOW PROCESSLIST璇硶
RTS锛�鍏充簬RTS绾跨▼鐨勬敞閲�
TIME data type锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�TIME绫诲瀷
time types锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
time zone problems锛�鏃跺尯闂
TIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
TIMEDIFF()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
timeout锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�锛�鍏朵粬鍑芥暟锛�INSERT DELAYED璇硶
connect_timeout variable锛�閫夐」锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
shutdown_timeout variable锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
TIMESTAMP
and NULL values锛�涓嶯ULL鍊兼湁鍏崇殑闂
TIMESTAMP data type锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�DATETIME銆丏ATE鍜孴IMESTAMP绫诲瀷
TIMESTAMP()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
TIMESTAMPADD()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
TIMESTAMPDIFF()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
TIME_FORMAT()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
TIME_TO_SEC()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
TINYBLOB data type锛�瀛楃涓茬被鍨嬫杩�
TINYINT data type锛�鏁板�肩被鍨嬫杩�
TINYTEXT data type锛�瀛楃涓茬被鍨嬫杩�
tips
optimization锛�鍏跺畠浼樺寲鎶�宸�
TMPDIR environment variable锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�锛�鐜鍙橀噺
TODO
embedded server锛�宓屽叆寮忔湇鍔″櫒涓皻闇�瀹屾垚鐨勪簨椤�(TODO)
symlinks锛�鍦║nix骞冲彴涓婁娇鐢ㄨ〃鐨勭鍙烽摼鎺�
 
tools
list of锛�鐢ㄤ簬鍒涘缓MySQL鐨勫伐鍏�
Touches()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
TO_DAYS()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
trace DBI method锛�鍦╣db鐜涓嬭皟璇昺ysqld
TRADITIONAL SQL mode锛�SQL鏈嶅姟鍣ㄦā寮�
transaction-safe tables锛�浜嬪姟鍜屽師瀛愭搷浣�锛�InnoDB姒傝堪
transactions
support锛�浜嬪姟鍜屽師瀛愭搷浣�锛�InnoDB姒傝堪
Translators
list of锛�璧勬枡鍛樺拰璇戝憳
trigger restrictions锛�瀵瑰瓨鍌ㄥ瓙绋嬪簭鍜岃Е鍙戠▼搴忕殑闄愬埗
triggers锛�瀛樺偍绋嬪簭鍜岃Е鍙戠▼搴�锛�SHOW TRIGGERS璇硶锛�瑙﹀彂绋嬪簭
TRIGGERS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA TRIGGERS琛�
TRIM()锛�瀛楃涓插嚱鏁�
troubleshooting
FreeBSD锛�澶勭悊MySQL缂栬瘧闂
Solaris锛�澶勭悊MySQL缂栬瘧闂
TRUE锛�鏁板��
testing for锛�姣旇緝鍑芥暟鍜屾搷浣滅
TRUNCATE锛�TRUNCATE璇硶
TRUNCATE()锛�鏁板鍑芥暟
tutorial锛�鏁欑▼
Twin Studies
queries锛�瀛敓椤圭洰鐨勬煡璇�
type conversions锛�姣旇緝鍑芥暟鍜屾搷浣滅
types
columns锛�鍒楃被鍨�锛�閫夋嫨姝ｇ‘鐨勫垪绫诲瀷
data锛�鍒楃被鍨�
date锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
Date and Time锛�鏃ユ湡鍜屾椂闂寸被鍨�
numeric锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
of tables锛�瀛樺偍寮曟搸鍜岃〃绫诲瀷
portability锛�浣跨敤鏉ヨ嚜鍏朵粬鏁版嵁搴撳紩鎿庣殑鍒楃被鍨�
strings锛�String绫诲瀷
time锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
typographical conventions锛�鏈墜鍐岄噰鐢ㄧ殑鎯緥
TZ environment variable锛�鏃跺尯闂锛�鐜鍙橀噺

U

UCASE()锛�瀛楃涓插嚱鏁�
UCS-2锛�瀛楃闆嗘敮鎸�
UDFs锛�CREATE FUNCTION/DROP FUNCTION璇硶
compiling锛�缂栬瘧鍜屽畨瑁呯敤鎴峰畾涔夌殑鍑芥暟
defined锛�涓篗ySQL娣诲姞鏂板嚱鏁�
return values锛�UDF杩斿洖鍊煎拰閿欒澶勭悊
ulimit锛�鏂囦欢鏈壘鍒�
UMASK environment variable锛�涓庢枃浠惰鍙湁鍏崇殑闂锛�鐜鍙橀噺
UMASK_DIR environment variable锛�涓庢枃浠惰鍙湁鍏崇殑闂锛�鐜鍙橀噺
unary minus (-)锛�绠楁湳鎿嶄綔绗�
unbuffered
mysql option锛�閫夐」
UNCOMPRESS()锛�瀛楃涓插嚱鏁�
UNCOMPRESSED_LENGTH()锛�瀛楃涓插嚱鏁�
UNHEX()锛�瀛楃涓插嚱鏁�
Unicode锛�瀛楃闆嗘敮鎸�
Unicode Collation Algorithm锛�Unicode瀛楃闆�
UNION锛�鏍规嵁涓や釜閿悳绱�锛�UNION璇硶
 
Union()锛�Spatial 鎿嶄綔绗�
UNIQUE锛�ALTER TABLE璇硶
constraint锛�PRIMARY KEY鍜孶NIQUE绱㈠紩绾︽潫
unique ID锛�濡備綍鑾峰緱涓婃鎻掑叆琛岀殑鍞竴ID
UNIX_TIMESTAMP()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
UNKNOWN
testing for锛�姣旇緝鍑芥暟鍜屾搷浣滅
unloading
tables锛�浠庤〃妫�绱俊鎭�
UNLOCK TABLES锛�LOCK TABLES鍜孶NLOCK TABLES璇硶
unnamed views锛�FROM瀛愬彞涓殑瀛愭煡璇�
UNTIL锛�REPEAT璇彞
UPDATE锛�UPDATE璇硶
updating
releases of MySQL锛�濡備綍鍙戝竷鏇存柊浠ュ強浣曟椂鍙戝竷鏇存柊
tables锛�浜嬪姟鍜屽師瀛愭搷浣�
upgrading锛�鍗囩骇MySQL
different architecture锛�灏哅ySQL鏁版嵁搴撴嫹璐濆埌鍙︿竴鍙版満鍣�
grant tables锛�鍗囩骇鎺堟潈琛�
UPPER()锛�瀛楃涓插嚱鏁�
uptime锛�mysqladmin锛氱敤浜庣鐞哅ySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�
URLs for downloading MySQL锛�鎬庢牱鑾峰緱MySQL
USE锛�USE璇硶
USE INDEX锛�SELECT璇硶锛�JOIN璇硶
USE KEY锛�SELECT璇硶锛�JOIN璇硶
user
mysql option锛�閫夐」
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
user accounts
creating锛�CREATE USER璇硶
renaming锛�RENAME USER璇硶
USER environment variable锛�涓嶮ySQL鏈嶅姟鍣ㄨ繛鎺�锛�鐜鍙橀噺
user privileges
adding锛�鍚慚ySQL澧炲姞鏂扮敤鎴疯处鎴�
deleting锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
dropping锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
user table
sorting锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
user variables锛�鐢ㄦ埛鍙橀噺
USER()锛�淇℃伅鍑芥暟
user-defined functions
adding锛�涓篗ySQL娣诲姞鏂板嚱鏁�锛�娣诲姞鏂扮殑鑷畾涔夊嚱鏁�
User-defined functions锛�CREATE FUNCTION/DROP FUNCTION璇硶
usernames
and passwords锛�MySQL鐢ㄦ埛鍚嶅拰瀵嗙爜
users
adding锛�鍦ㄥ叾瀹冪被Unix绯荤粺涓畨瑁匨ySQL锛�婧愮爜瀹夎姒傝堪
deleting锛�浠嶮ySQL鍒犻櫎鐢ㄦ埛璐︽埛锛�DROP USER璇硶
root锛�浣垮垵濮婱ySQL璐︽埛瀹夊叏
USER_PRIVILEGES
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA USER_PRIVILEGES琛�
uses
of MySQL锛�鎴戜滑宸插皢MySQL鐢ㄥ湪浣曞锛�
using multiple disks to start data锛�鍦╓indows骞冲彴涓婁娇鐢ㄥ叧浜庢暟鎹簱鐨勭鍙烽摼鎺�
UTC_DATE()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
UTC_TIME()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
UTC_TIMESTAMP()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
UTF-8锛�瀛楃闆嗘敮鎸�
UTF8锛�瀛楃闆嗘敮鎸�
UUID()锛�鍏朵粬鍑芥暟

V

valid numbers
examples锛�鏁板��
VALUES()锛�鍏朵粬鍑芥暟
VARBINARY data type锛�瀛楃涓茬被鍨嬫杩�锛�BINARY鍜孷ARBINARY绫诲瀷
VARCHAR
size锛�鍒楃被鍨嬪瓨鍌ㄩ渶姹�
VARCHAR data type锛�瀛楃涓茬被鍨嬫杩�锛�String绫诲瀷
VARCHARACTER data type锛�瀛楃涓茬被鍨嬫杩�
variables
mysqld锛�璋冭妭鏈嶅姟鍣ㄥ弬鏁�
server锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�锛�SHOW VARIABLES璇硶
status锛�鏈嶅姟鍣ㄧ姸鎬佸彉閲�锛�SHOW STATUS璇硶
system锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�锛�SHOW VARIABLES璇硶
System锛�绯荤粺鍙橀噺
user锛�鐢ㄦ埛鍙橀噺
values锛�鏈嶅姟鍣ㄧ郴缁熷彉閲�
VARIANCE()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
VAR_POP()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
VAR_SAMP()锛�GROUP BY锛堣仛鍚堬級鍑芥暟
verbose
mysql option锛�閫夐」
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
version
choosing锛�閫夋嫨瑕佸畨瑁呯殑MySQL鍒嗗彂鐗�
latest锛�鎬庢牱鑾峰緱MySQL
mysql option锛�閫夐」
mysqld_multi option锛�mysqld_multi锛氱鐞嗗涓狹ySQL鏈嶅姟鍣ㄧ殑绋嬪簭
VERSION()锛�淇℃伅鍑芥暟
vertical
mysql option锛�閫夐」
view restrictions锛�瀵硅鍥剧殑闄愬埗
views锛�瑙嗗浘锛�瑙嗗浘锛�CREATE VIEW璇硶
updatable锛�瑙嗗浘锛�CREATE VIEW璇硶
VIEWS
INFORMATION_SCHEMA table锛�INFORMATION_SCHEMA VIEWS琛�
virtual memory
problems while compiling锛�澶勭悊MySQL缂栬瘧闂
Visual Basic锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭

W

wait
mysql option锛�閫夐」
WEEK()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
WEEKDAY()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
WEEKOFYEAR()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
Well-Known Binary format锛�钁楀悕鐨勪簩杩涘埗(WKB)鏍煎紡
Well-Known Text format锛�钁楀悕鐨勬枃鏈�(WKT)鏍煎紡
What is an X509/Certificate?锛�Basic SSL Concepts
What is encryption锛�Basic SSL Concepts
WHERE锛�MySQL鎬庢牱浼樺寲WHERE瀛愬彞
with SHOW锛�INFORMATION_SCHEMA淇℃伅鏁版嵁搴�锛�SHOW璇彞鐨勬墿灞�
WHILE锛�WHILE Statement
widths
display锛�鍒楃被鍨�
Wildcard character (%)锛�瀛楃涓�
Wildcard character (_)锛�瀛楃涓�
wildcards
and LIKE锛�MySQL濡備綍浣跨敤绱㈠紩
in mysql.columns_priv table锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
in mysql.db table锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
in mysql.host table锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
in mysql.tables_priv table锛�璁块棶鎺у埗 锛岄樁娈�2锛氳姹傛牳瀹�
in mysql.user table锛�璁块棶鎺у埗 锛岄樁娈�1锛氳繛鎺ユ牳瀹�
Windows锛�MySQL Connector/ODBC
compiling on锛�鍦╓indows涓嬬紪璇慚ySQL瀹㈡埛绔�
open issues锛�Windows鐗圡ySQL鍚孶nix鐗圡ySQL瀵规瘮
upgrading锛�鍦╓indows涓嬪崌绾ySQL
versus Unix锛�Windows鐗圡ySQL鍚孶nix鐗圡ySQL瀵规瘮
with-big-tables option锛�鍏稿瀷閰嶇疆閫夐」
Within()锛�娴嬭瘯鍑犱綍绫讳箣闂寸┖闂村叧绯荤殑鍑芥暟
without-server option锛�鍏稿瀷閰嶇疆閫夐」
WKB format锛�钁楀悕鐨勪簩杩涘埗(WKB)鏍煎紡
WKT format锛�钁楀悕鐨勬枃鏈�(WKT)鏍煎紡
Word program锛�宸茬煡鐨勮兘涓嶮yODBC涓�璧峰伐浣滅殑绋嬪簭
wrappers
Eiffel锛�MySQL Eiffel Wrapper
write access
tmp锛�涓庤繍琛宮ysql_install_db鏈夊叧鐨勯棶棰�
write_buffer_size myisamchk variable锛�鐢ㄤ簬myisamchk鐨勪竴鑸�夐」

X

X()锛�Point鍑芥暟
 
XA BEGIN锛�XA浜嬪姟SQL璇硶
XA COMMIT锛�XA浜嬪姟SQL璇硶
XA PREPARE锛�XA浜嬪姟SQL璇硶
XA RECOVER锛�XA浜嬪姟SQL璇硶
XA ROLLBACK锛�XA浜嬪姟SQL璇硶
XA START锛�XA浜嬪姟SQL璇硶
XA transactions锛�XA浜嬪姟
transaction identifiers锛�XA浜嬪姟SQL璇硶
xid
XA transaction identifier锛�XA浜嬪姟SQL璇硶
xml
mysql option锛�閫夐」
XOR
bitwise锛�浣嶅嚱鏁�
logical锛�閫昏緫鎿嶄綔绗�

Y

Y()锛�Point鍑芥暟
 
Year 2000 compliance锛�2000骞村吋瀹规��
Year 2000 issues锛�Y2K浜嬪疁鍜屾棩鏈熺被鍨�
YEAR data type锛�鏃ユ湡鍜屾椂闂寸被鍨嬫杩�锛�YEAR绫诲瀷
YEAR()锛�鏃ユ湡鍜屾椂闂村嚱鏁�
YEARWEEK()锛�鏃ユ湡鍜屾椂闂村嚱鏁�

杩欐槸MySQL鍙傝�冩墜鍐岀殑缈昏瘧鐗堟湰锛屽叧浜嶮ySQL鍙傝�冩墜鍐岋紝璇疯闂�dev.mysql.com銆� 鍘熷鍙傝�冩墜鍐屼负鑻辨枃鐗堬紝涓庤嫳鏂囩増鍙傝�冩墜鍐岀浉姣旓紝鏈炕璇戠増鍙兘涓嶆槸鏈�鏂扮殑銆�