站内搜索: 请输入搜索关键词
当前页面: 在线文档首页 > 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銆 鍘熷鍙傝冩墜鍐屼负鑻辨枃鐗堬紝涓庤嫳鏂囩増鍙傝冩墜鍐岀浉姣旓紝鏈炕璇戠増鍙兘涓嶆槸鏈鏂扮殑銆