F i l e s \ M e s s e n g e r \ m s m s g s . e x e

符号-A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y_mysql中文手册_MYSQL教程_数据库学习__
! (logical NOT),
!= (not equal),
% (modulo),
% (wildcard character),
& (bitwise AND),
&& (logical AND),
() (parentheses),
(Control-Z) \Z,
* (multiplication),
+ (addition),
- (subtraction),
- (unary minus),
--password option,
-p option,
file,,,,,
.mysql_history
(process ID) file,
/ (division),
/etc/passwd,,
& (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),
aborted clients,
aborted connection,
access control,
access denied errors,
access privileges,
Access program,
account privileges
anonymous user,
ActiveState
ADDDATE(),
character sets,
native functions,
new account privileges,
new functions,
new user privileges,
new users,,
procedures,
user-defined functions,
addition (+),
ADDTIME(),
ADO program,
AES_DECRYPT(),
AES_ENCRYPT(),
calculating,
alias names
case sensitivity,
for expressions,
for tables,
in GROUP BY clauses,
in ORDER BY clauses,
on expressions,
ALLOW_INVALID_DATES
SQL mode,
ALTER COLUMN,
ALTER DATABASE,
ALTER FUNCTION,
ALTER PROCEDURE,
ALTER SCHEMA,
ALTER TABLE,,
ALTER VIEW,
database,
ANALYZE TABLE,
anonymous user,,,
ANSI SQL mode,
ANSI_QUOTES
SQL mode,
answering questions
etiquette,
approximate-value literals,
ARCHIVE storage engine,,
ARCHIVE table type,,
Area(),,
argument processing,
arithmetic expressions,
arithmetic functions,
AsBinary(),
AsText(),
security against,
AUTO-INCREMENT
AUTO_INCREMENT,
and NULL values,
AVG(DISTINCT),
escape character,
backspace (\b),
BACKUP TABLE,
database,
batch mode,
storage engine,,
BDB table type,,
BDB tables,
BdMPolyFromText(),
BdMPolyFromWKB(),
BdPolyFromText(),
BdPolyFromWKB(),
XA transactions,
benchmark suite,
BENCHMARK(),
benchmarks,
BerkeleyDB
storage engine,,
BerkeleyDB table type,,
BETWEEN ... AND,
Big5 Chinese character encoding,
data type,
BINARY data type,,
binary distributions,
installing,
on Linux,
binary log,
BIT data type,
BIT_AND(),
BIT_COUNT,
BIT_COUNT(),
bit_functions
BIT_LENGTH(),
BIT_OR(),
BIT_XOR(),
BLACKHOLE storage engine,,
table type,,
inserting binary data,
BLOB columns
default values,
indexing,,
BLOB data type,,
data type,
BOOLEAN data type,
Borland Builder 4 program,
Borland C++ compiler,
Boundary(),
buffer sizes
mysqld server,
Buffer(),
bug reports
criteria for,
reporting,
bugs database,
client programs,
data types,
functions,
linking problems,
C Prepared statement API
functions,
C++ APIs,
C++ Builder,
C++ compiler
C++ compiler cannot create executables,
CACHE INDEX,
clearing,
calculating
calendar,
calling sequences for aggregate functions
calling sequences for simple functions
can't create/write to file,
carriage return (\r),
case sensitivity
in identifiers,
in names,
in searches,
in string comparisons,
case-sensitivity
in access checking,
of database names,
of table names,
cast functions,
cast operators,
CC environment variable,,,
cc1plus problems,
CEILING(),
Centroid(),
environment variable,,,
CHANGE MASTER TO,
ChangeLog,
MySQL 5.1,
changes to privileges,
column order,
changing socket location,,,
CHAR data type,,
CHAR VARYING data type,
CHARACTER data type,
character sets,,
Character sets,
VARYING data type,
character-sets-dir
characters
multi-byte,
CHARACTER_LENGTH(),
CHARACTER_SETS
INFORMATION_SCHEMA
CHARSET(),
CHAR_LENGTH(),
check options
myisamchk,
CHECK TABLE,
tables for errors,
checksum errors,
CHECKSUM TABLE,
choosing types,
client programs
building,
client tools,
debugging,
threaded,
COALESCE(),
COERCIBILITY(),
ColdFusion
COLLATION(),
COLLATIONS
INFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITY
INFORMATION_SCHEMA
changing,
column comments,
column names
case sensitivity,
changing,
other types,
selecting,
storage requirements,
INFORMATION_SCHEMA
COLUMN_PRIVILEGES
INFORMATION_SCHEMA
command syntax,
command-line history
command-line options,
mysqladmin,
for binary distribution,
replication masters,
replication slaves,
commands out of sync,
Comment syntax,
starting,
COMMIT,,
XA transactions,
comparison operators,
compatibility
with mSQL,
with ODBC,,,,,
with Oracle,,,
with PostgreSQL,
with standard SQL,
with Sybase,
on Windows,
optimizing,
problems,
statically,
user-defined functions,
compliance
composite subpartitioning,
COMPRESS(),
compressed tables,
CONCAT(),
CONCAT_WS(),
concurrent inserts,
Conditions,
config-file
mysqld_multi
config.cache,
config.cache
configuration files,
configuration options,
running after prior invocation,
configure option
--with-charset,
--with-collation,
--with-extra-charsets,
--with-low-memory,
configure script,
connecting
remotely with SSH,
to the server,,
verification,
connection
CONNECTION_ID(),
Connector/JDBC,
Connector/ODBC,,
reporting problems,
connect_timeout
variable,,
constant table,,
constraints,
CONSTRAINTS
INFORMATION_SCHEMA
Contains(),
contributing companies
contributors
control access,
control flow functions,
conventions
typographical,
CONVERT TO,
CONVERT_TZ(),
ConvexHull(),
copying databases,
copying tables,
COUNT(DISTINCT),
table rows,
recovery,
repeated,
crash-me,
crash-me program,,
CREATE DATABASE,
CREATE FUNCTION,,
CREATE INDEX,
CREATE PROCEDURE,
CREATE SCHEMA,
CREATE TABLE,
CREATE USER,
CREATE VIEW,
bug reports,
database,
databases,
default startup options,
creating user accounts,
CROSS JOIN,
Crosses(),
CR_SERVER_GONE_ERROR,
CR_SERVER_LOST_ERROR,
CSV storage engine,,
CSV table type,,
CURDATE(),
CURRENT_DATE,
CURRENT_TIME,
CURRENT_TIMESTAMP,
CURRENT_USER(),
CURTIME(),
customer support
mailing address,
of MySQL,
environment variable,,,
environment variable,,,
character sets,
loading into tables,
retrieving,
BINARY,,
BOOLEAN,,
CHAR VARYING,
CHARACTER,
CHARACTER VARYING,
DATETIME,,
DECIMAL,,
DOUBLE PRECISION,
GEOMETRY,
GEOMETRYCOLLECTION,
LINESTRING,
LONGBLOB,
LONGTEXT,
MEDIUMBLOB,
MEDIUMINT,
MEDIUMTEXT,
MULTILINESTRING,
MULTIPOINT,
MULTIPOLYGON,
NATIONAL CHAR,
SMALLINT,
TIMESTAMP,,
TINYBLOB,
TINYTEXT,
VARBINARY,,
VARCHAR,,
VARCHARACTER,
data types,
overview,
altering,
creating,
deleting,
mysql option,
database design,
Database information
obtaining,
database metadata,
database names
case sensitivity,
case-sensitivity,
DATABASE(),
creating,
information about,
replicating,
selecting,
symbolic links,
DataJunction,
date and time functions,
Date and Time types,
date calculations,
DATE columns
problems,
DATE data type,,
date functions
Y2K compliance,
date types,
Y2K issues,
date values
problems,
DATEDIFF(),
data type,,
DATE_ADD(),
DATE_FORMAT(),
DATE_SUB(),
DAYNAME(),
DAYOFMONTH(),
DAYOFWEEK(),
DAYOFYEAR(),
DB2 SQL mode,
interface,
DBI-&quote,
DBI-&trace,
interface,
environment variable,,
environment variable,
DEALLOCATE
debug-info
DEC data type,
decimal arithmetic,
DECIMAL data type,,
decimal point,
DECODE(),
decode_bits myisamchk
variable,
constraint,
privileges,
default hostname,
default installation location,
default options,
DEFAULT value clause,
default values,,,
BLOB and TEXT columns,
implicit,
suppression,
DEFAULT(),
default-character-set
embedded,
DEGREES(),
delayed_insert_limit,
database,
foreign key,,
function,
primary key,
mysql.sock,
Delphi program,
derived tables,
DESCRIBE,,
limitations,
DES_DECRYPT(),
DES_ENCRYPT(),
developers
development source tree,
Difference(),
Dimension(),
directory structure
DISCARD TABLESPACE,,
disconnecting
from the server,
Disjoint(),
disk full,
disk issues,
splitting data across,
display size,
triggers,
display width,
displaying
information
Cardinality,
Collation,
SHOW,,,,,
table status,
Distance(),
DISTINCT,,,,
DISTINCTROW,
division (/),
DocBook XML
documentation source format,
Documenters
DOUBLE data type,
DOUBLE PRECISION data type,
double quote (\&),
downgrading,
downloading,
DROP DATABASE,
DROP FOREIGN KEY,,
DROP FUNCTION,,
DROP INDEX,,
DROP PRIMARY KEY,
DROP PROCEDURE,
DROP SCHEMA,
DROP TABLE,
DROP USER,
DROP VIEW,
DUMPFILE,
dynamic table characteristics,
Eiffel Wrapper,
email lists,
embedded MySQL
server library,
ENCODE(),
ENCRYPT(),
encryption functions,
EndPoint(),
data type,,
Envelope(),
environment variable
CFLAGS,,
CXXFLAGS,,
LD_RUN_PATH,,
MYSQL_DEBUG,
MYSQL_HISTFILE,
MYSQL_HOST,
MYSQL_PWD,,
MYSQL_TCP_PORT,,,
MYSQL_UNIX_PORT,,,
Environment variable
CXXFLAGS,
DBI_TRACE,,
DBI_USER,
LD_LIBRARY_PATH,
LD_RUN_PATH,,
MYSQL_DEBUG,,
MYSQL_HISTFILE,
MYSQL_HOST,
MYSQL_PS1,
MYSQL_PWD,
MYSQL_TCP_PORT,
MYSQL_UNIX_PORT,,
TMPDIR,,
UMASK_DIR,,
Environment variables
environment variables,,,
equal (=),
Equals(),
error messages
can't find file,
languages,
access denied,
checking tables for,
checksum,
handling for UDFs,
reporting,,,
ERROR_FOR_DIVISION_BY_ZERO
SQL mode,
escape (\\),
escape characters,
estimating
query performance,
exact-value literals,
mysqld_multi
EXAMPLE storage engine,,
EXAMPLE table type,,
compressed tables,
EXPORT_SET(),
expression aliases,,
expressions
extended,
extensions
to standard SQL,
ExteriorRing(),
EXTRACT(),
extracting
testing for,
fatal signal 11,
features of MySQL,
FEDERATED storage engine,,
FEDERATED table type,,
changing,
binary log,
config.cache,
error messages,
not found message,
permissions,
query log,
repairing,
size limits,
slow query log,
update log (obsolete),
optimization,
FIND_IN_SET(),
FIXED data type,
fixed-point arithmetic,
FLOAT data type,
floating-point number,
FOR UPDATE,
FORCE INDEX,,,
FORCE KEY,,
foreign key
constraint,
deleting,,
foreign keys,,,
FORMAT(),
FOUND_ROWS(),
FreeBSD troubleshooting,
FROM_DAYS(),
FROM_UNIXTIME(),
ft_max_word_len myisamchk
variable,
ft_min_word_len myisamchk
variable,
ft_stopword_file myisamchk
variable,
full disk,
full-text search,
FULLTEXT,
deleting,
functions,
arithmetic,
C Prepared statement API,
control flow,
date and time,
encryption,
GROUP BY,
grouping,
information,
mathematical,
miscellaneous,
string comparison,
user-defined,
user-defined,
functions for
SELECT and WHERE clauses,
Future development of
general information,
General Public License,
geographic feature,
GeomCollFromText(),
GeomCollFromWKB(),
geometry,
GEOMETRY data type,
GEOMETRYCOLLECTION
data type,
GeometryCollection(),
GeometryCollectionFromText(),
GeometryCollectionFromWKB(),
GeometryFromText(),
GeometryFromWKB(),
GeometryN(),
GeometryType(),
GeomFromText(),,
GeomFromWKB(),,
geospatial feature,
getting MySQL,
GET_FORMAT(),
GET_LOCK(),
GLength(),,
global privileges,
goals of MySQL,
General Public License,
GNU通用公共许可,
FLOSS许可例外,
GRANT statement,,
grant tables,
re-creating,
sorting,,
upgrading,
privileges,
greater than (&),
greater than or equal (&=),
GREATEST(),
GROUP BY,
aliases in,
extensions to standard SQL,,
GROUP BY functions,
expressions,
GROUP_CONCAT(),
Handlers,
hash partitioning,
hash partitions,managing,
hash partitions,splitting
and merging,
storage engine,,
HEAP table type,,
mysql option,
mysqld_multi
hexadecimal values,
HIGH_NOT_PRECEDENCE
SQL mode,
HIGH_PRIORITY,
hints,,,
history of MySQL,
HOME environment variable,,
host table,
problems finding,
hostname caching,
identifiers,
case sensitivity,
IFNULL(),
IGNORE INDEX,,
IGNORE KEY,,
ignore-space
IGNORE_SPACE
SQL mode,
implicit default values,
IMPORT TABLESPACE,,
increasing
performance,
increasing with replication
deleting,,
index hints,,
and BLOB columns,,
and IS NULL,
and LIKE,
and NULL values,
and TEXT columns,,
assigning to key cache,
block size,
leftmost prefix of,
multi-column,
multiple-part,
INET_ATON(),
INET_NTOA(),
information about partitions,obtaining,
information functions,
INFORMATION_SCHEMA,,
INNER JOIN,
Solaris 10 x86_64 issues,
storage engine,,
table type,,
INSERT,,
INSERT ... SELECT,
INSERT DELAYED,
INSERT statement
privileges,
INSERT(),
speed of,
installation layouts,
installation overview,
installing
binary distribution,
Linux RPM packages,
Mac OS X PKG packages,在
overview,
Perl on Windows,
source distribution,
user-defined functions,
data type,
integer arithmetic,
INTEGER data type,
integers,
InteriorRingN(),
internal compiler errors,
internal locking,
internals,
Internet Relay Chat,
Intersection(),
Intersects(),
INTERVAL(),
introducer
string literal,,
invalid data
constraint,
IS boolean_value,
IS NOT boolean_value,
IS NOT NULL,
IS NULL,,
and indexes,
storage engine,
table type,
IsClosed(),
IsEmpty(),
ISNULL(),
ISOLATION LEVEL,
IsRing(),
IsSimple(),
IS_FREE_LOCK(),
IS_USED_LOCK(),
assigning indexes to,
key partitioning,
key partitions,managing,
key partitions,splitting
and merging,
foreign,,
multi-column,
searching on two,
keywords,
key_buffer_size myisamchk
variable,
KEY_COLUMN_USAGE
INFORMATION_SCHEMA
known errors,
language support,
unique ID,
LAST_DAY(),
LAST_INSERT_ID(),,
LAST_INSERT_ID([expr]),
layout of installation,
LD_LIBRARY_PATH
environment variable,
LD_RUN_PATH
environment variable,,,,
LEFT JOIN,,
LEFT OUTER JOIN,
leftmost prefix of indexes,
legal names,
LENGTH(),
less than (&),
less than or equal (&=),
libmysqld,
mysqlclient,
and indexes,
and wildcards,
LIMIT,,,
limitations
Limitations,
replication,
file-size,
MySQL Limits,limits in MySQL,
linear hash partitioning,
linear key partitioning,
linefeed (\n),
LineFromText(),
LineFromWKB(),
LINESTRING
data type,
LineString(),
LineStringFromText(),
LineStringFromWKB(),
problems,
symbolic,
binary distribution,
source distribution,
list partitioning,
list partitions,adding
and dropping,
list partitions,managing,
literals,
LOAD DATA FROM MASTER,
LOAD DATA INFILE,,
LOAD TABLE FROM MASTER,
LOAD_FILE(),
local-infile
LOCALTIME,
LOCALTIMESTAMP,
LOCATE(),
LOCK IN SHARE MODE,
LOCK TABLES,
page-level,
row-level,,
table-level,
locking methods,
mysqld_multi
log files,
maintaining,
Log files,
logical operators,
LONG data type,
data type,
data type,
installation,在
mailing address
customer support,
mailing list address,
mailing lists,
archive location,
guidelines,
main features of MySQL,
maintaining
log files,
MAKEDATE(),
MAKETIME(),
make_binary_distribution,
MAKE_SET(),
available formats,
online location,
typographical conventions,
master/slave setup,
MASTER_POS_WAIT(),,
MATCH ... AGAINST(),
patterns,
mathematical
functions,
MAX(DISTINCT),
MAXDB SQL mode,
maximum memory used,
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,
MBRContains(),
MBRDisjoint(),
MBREqual(),
MBRIntersects(),
MBROverlaps(),
MBRTouches(),
MBRWithin(),
MEDIUMBLOB
data type,
data type,
MEDIUMTEXT
data type,
MEMORY storage engine,,
MEMORY table type,,
memory usage
myisamchk,
memory use,,
MERGE storage engine,,
MERGE table type,,
MERGE tables
languages,
database,
MICROSECOND(),
MIN(DISTINCT),
Minimum Bounding Rectangle,
unary (-),
MINUTE(),
mirror sites,
miscellaneous functions,
MIT-pthreads,
MLineFromText(),
MLineFromWKB(),
MOD (modulo),
modulo (%),
modulo (MOD),
terminal,
MONTHNAME(),
MPointFromText(),
MPointFromWKB(),
MPolyFromText(),
MPolyFromWKB(),
mSQL compatibility,
MSSQL SQL mode,
multi-byte character sets,
multi-byte characters,
multi-column indexes,
MULTILINESTRING data type,
MultiLineString(),
MultiLineStringFromText(),
MultiLineStringFromWKB(),
multiple servers,
multiple-part index,
multiplication (*),
MULTIPOINT data type,
MultiPoint(),
MultiPointFromText(),
MultiPointFromWKB(),
MULTIPOLYGON
data type,
MultiPolygon(),
MultiPolygonFromText(),
MultiPolygonFromWKB(),
derivation,
my.cnf file,
compressed tables,
key cache,
MyISAM storage engine,,
MyISAM table type,,
myisamchk,,
example output,
myisampack,,
myisam_block_size myisamchk variable,
reporting problems,
introduction,
pronunciation,
binary distribution,
MYSQL C type,
MySQL C type,
MySQL簇 in MySQL 5.0 and 5.1,
mysql command-line options,
mysql commands
MySQL Dolphin name,
MySQL history,
history file,
MySQL mailing lists,
MySQL name,
mysql prompt command,
MySQL source distribution,
mysql status command,
MySQL storage engines,
MySQL table types,
MySQL version,
mysql.server,
mysql.sock
changing location of,
protection,
MYSQL323 SQL mode,
MYSQL40 SQL mode,
mysqlaccess,
mysqladmin,,,,,,,
mysqld_multi
mysqladmin
command-line options,
mysqlbinlog,
mysqlbug,
location,
mysqlcheck,
mysqlclient
mysqld_multi
starting,
mysqld options,,
mysqld server
buffer sizes,
mysqld-max,,
mysqldump,,
mysqld_multi,
mysqld_safe,
mysqlhotcopy,
mysqlimport,,,
mysqlshow,
MySQL测试套件,
mysql_affected_rows(),
mysql_autocommit().,
MYSQL_BIND
mysql_change_user(),
mysql_character_set_name(),
mysql_close(),
mysql_commit().,
mysql_connect(),
mysql_create_db(),
mysql_data_seek(),
MYSQL_DEBUG
environment variable,,,
mysql_debug(),
mysql_drop_db(),
mysql_dump_debug_info(),
mysql_eof(),
mysql_errno(),
mysql_error(),
mysql_escape_string(),
mysql_fetch_field(),
mysql_fetch_fields(),
mysql_fetch_field_direct(),
mysql_fetch_lengths(),
mysql_fetch_row(),
MYSQL_FIELD C type,
mysql_field_count(),,
MYSQL_FIELD_OFFSET C type,
mysql_field_seek(),
mysql_field_tell(),
mysql_fix_privilege_tables,,
mysql_free_result(),
mysql_get_character_set_info(),
mysql_get_client_info(),
mysql_get_client_version(),
mysql_get_host_info(),
mysql_get_proto_info(),
mysql_get_server_info(),
mysql_get_server_version(),
mysql_hex_string(),
MYSQL_HISTFILE environment variable,,
MYSQL_HOST
environment variable,,
mysql_info(),,,,,
mysql_init(),
mysql_insert_id(),,,
mysql_install_db,
mysql_install_db script,
mysql_kill(),
mysql_library_end(),
mysql_library_init(),
mysql_list_dbs(),
mysql_list_fields(),
mysql_list_processes(),
mysql_list_tables(),
mysql_more_results().,
mysql_next_result().,
mysql_num_fields(),
mysql_num_rows(),
mysql_options(),
mysql_ping(),
MYSQL_PS1 environment variable,
MYSQL_PWD environment variable,,,
mysql_query(),,
mysql_real_connect(),
mysql_real_escape_string(),,
mysql_real_query(),
mysql_refresh(),
mysql_reload(),
MYSQL_RES C type,
mysql_rollback().,
MYSQL_ROW C type,
mysql_row_seek(),
mysql_row_tell(),
mysql_select_db(),
mysql_server_end(),
mysql_server_init(),
mysql_set_character_set(),
mysql_set_server_option(),
mysql_shutdown(),
mysql_sqlstate(),
mysql_ssl_set(),
mysql_stat(),
MYSQL_STMT C type,
mysql_stmt_affected_rows(),
mysql_stmt_attr_get(),
mysql_stmt_attr_set(),
mysql_stmt_bind_param(),
mysql_stmt_bind_result(),
mysql_stmt_close(),
mysql_stmt_data_seek(),
mysql_stmt_errno(),
mysql_stmt_error().,
mysql_stmt_execute(),
mysql_stmt_fetch(),
mysql_stmt_fetch_column(),
mysql_stmt_field_count(),
mysql_stmt_free_result(),
mysql_stmt_init(),
mysql_stmt_insert_id(),
mysql_stmt_num_rows(),
mysql_stmt_param_count(),
mysql_stmt_param_metadata(),
mysql_stmt_prepare(),
mysql_stmt_reset(),
mysql_stmt_result_metadata.,
mysql_stmt_row_seek(),
mysql_stmt_row_tell(),
mysql_stmt_send_long_data().,
mysql_stmt_sqlstate(),
mysql_stmt_store_result(),
mysql_store_result(),,
MYSQL_TCP_PORT environment variable,,,,
mysql_thread_end(),
mysql_thread_id(),
mysql_thread_init(),
mysql_thread_safe(),
MYSQL_UNIX_PORT
environment variable,,,,,
mysql_use_result(),
mysql_warning_count().,
my_init(),
my_ulonglong C type,
my_ulonglong values
printing,
named pipes,,
named-commands
case sensitivity,
variables,
NAME_CONST(),
releases of MySQL,
NATIONAL CHAR data type,
native functions
native thread support,
NATURAL LEFT JOIN,
NATURAL LEFT OUTER JOIN,
NATURAL RIGHT JOIN,
NATURAL RIGHT OUTER JOIN,
data type,
negative values,
nested queries,
net etiquette,,
netmask notation
in mysql.user
net_buffer_length
variable,
New features in
new procedures
adding,,
no matching rows,
no-auto-rehash
mysqld_multi
no-named-commands
non-delimited strings,
Non-transactional tables,
NOT BETWEEN,
not equal (!=),
not equal (&&),
NOT LIKE,
constraint,
NOT REGEXP,
Novell NetWare,
NO_AUTO_CREATE_USER
SQL mode,
NO_AUTO_VALUE_ON_ZERO
SQL mode,
NO_BACKSLASH_ESCAPES
SQL mode,
NO_DIR_IN_CREATE
SQL mode,
NO_FIELD_OPTIONS
SQL mode,
NO_KEY_OPTIONS
SQL mode,
NO_TABLE_OPTIONS SQL mode,
NO_UNSIGNED_SUBTRACTION SQL mode,
NO_ZERO_DATE SQL mode,
NO_ZERO_IN_DATE SQL mode,
testing for null,,
NULL value,,
NULL values
and AUTO_INCREMENT columns,
and indexes,
and TIMESTAMP columns,
vs. empty values,
NULLIF(),
NUMERIC data type,
numeric types,
NumGeometries(),
NumInteriorRings(),
NumPoints(),
OCTET_LENGTH(),
ODBC compatibility,,,,,
OLD_PASSWORD(),
ON DUPLICATE KEY,
one-database
online location of manual,
ONLY_FULL_GROUP_BY
SQL mode,
Open Source
open tables,,
OpenSSL,,
open_files_limit
variable,
operating systems
file-size limits,
supported,
Windows versus Unix,
operations
arithmetic,
operators,
optimization
optimizations,,
OPTIMIZE TABLE,
controlling,
optimizing
DISTINCT,
filesort,
GROUP BY,
LEFT JOIN,
option files,,
command-line,
mysqladmin,
configure,
embedded server,
libmysqld,
myisamchk,
provided by MySQL,
replication,
索引 Merge optimization,
Oracle compatibility,,,
ORACLE SQL mode,
ORDER BY,,,
aliases in,
Overlaps(),
overview,
page-level locking,
parameters
parentheses ( and ),
PARTITION,
management,
partitioning,
partitioning
partitioning by key,
partitioning by linear hash,
partitioning by linear key,
partitioning by list,
partitioning by range,
partitioning concepts,
partitioning information commands,
partitioning support,
partitioning types,
partitioning,advantages,
partitioning,enabling,
partitions,adding
and dropping,
partitions,analyzing,
partitions,checking,
partitions,managing,
partitions,modifying,
partitions,optimizing,
partitions,repairing,
partitions,splitting
and merging,
mysqld_multi
root user,
password encryption
reversibility of,
PASSWORD(),,,,
for users,
forgotten,
resetting,
security,
setting,,,
PATH environment variable,,,
pattern matching,
performance
benchmarks,
disk issues,
estimating,
improving,,
PERIOD_ADD(),
PERIOD_DIFF(),
installing,
installing on Windows,
Perl API,
Perl DBI/DBD
installation problems,
permission checks
effect on speed,
PIPES_AS_CONCAT
SQL mode,
POINT data type,
point in time recovery,
PointFromText(),
PointFromWKB(),
PointN(),
PointOnSurface(),
PolyFromText(),
PolyFromWKB(),
POLYGON data type,
Polygon(),
PolygonFromText(),
PolygonFromWKB(),
portability,
to other systems,
POSITION(),
post-install
multiple servers,
post-installation
setup and testing,
PostgreSQL
compatibility,
POSTGRESQL
SQL mode,
arithmetic,
precision math,
transactions,
PRIMARY KEY,,
constraint,
primary key
deleting,
privilege information
location,
privilege system,
described,
privileges
deleting,,
dropping,,
granting,
revoking,
access denied errors,
common errors,
compiling,
DATE columns,
date values,
installing on IBM-AIX,
installing on Solaris,
installing Perl,
reporting,
starting the server,
table locking,
time zone,
PROCEDURE,
procedures
stored,,
process support,
processing
arguments,
PROCESSLIST,
program variables
crash-me,
meanings,
pronunciation
PURGE MASTER LOGS,
Python API,
QUARTER(),
entering,
estimating performance,
examples,
speed of,
Twin Studies project,
Query Cache,
query log,
questions,
answering,
in strings,
quoting binary data,
quoting of identifiers,
RADIANS(),
range partitioning,
range partitions,adding
and dropping,
range partitions,managing,
re-creating
grant tables,
read_buffer_size myisamchk
variable,
REAL data type,
REAL_AS_FLOAT
SQL mode,
reconfiguring,
transactions,
from crash,
point in time,
data size,
references,
ref_or_null,
regular expression syntax
described,
Related(),
relational databases
release numbers,
RELEASE SAVEPOINT,
naming scheme,
updating,
RELEASE_LOCK(),
RENAME TABLE,
RENAME USER,
renaming user accounts,
reordering
repair options
myisamchk,
REPAIR TABLE,
REPEAT(),
REPLACE ... SELECT,
REPLACE(),
replication,
replication limitations,
replication masters
commands,
replication options,
replication slaves
commands,
Connector/ODBC problems,
errors,,
problems,
REQUIRE GRANT option,,
reserved words
exceptions,
RESET MASTER,
RESET SLAVE,
restarting
the server,
RESTORE TABLE,
restrictions
server-side
stored routines,
subqueries,
triggers,
retrieving
data from tables,
return (\r),
return values
REVERSE(),
privileges,
RIGHT JOIN,
OUTER JOIN,
ROLLBACK,,
XA transactions,
ROLLBACK TO SAVEPOINT,
root password,
password resetting,
rounding,
INFORMATION_SCHEMA
row-level locking,
counting,
deleting,
matching problems,
selecting,
ROW_COUNT(),
RPM file,
RPM Package Manager,
RTS-threads,
ANSI mode,
batch mode,
multiple servers,
running configure after prior invocation,
safe-updates
safe-updates option,
SAVEPOINT,
arithmetic,
altering,
creating,
deleting,
SCHEMA(),
INFORMATION_SCHEMA
SCHEMA_PRIVILEGES
INFORMATION_SCHEMA
script files,
mysqlbug,
mysql_install_db,
and case sensitivity,
full-text,
Web pages,
two keys,
SECOND(),
secure-auth
against attackers,
security system,
SEC_TO_TIME(),
optimizing,
Query Cache,
SELECT INTO,
SELECT INTO TABLE,
SELECT speed,
databases,
select_limit
variable,
SEQUENCE,
sequence emulation,
sequences,
connecting,,
debugging,
disconnecting,
shutdown,
starting,
starting and stopping,
starting problems,
server variables,,,
server-side cursor restrictions,
multiple,
SESSION_USER(),
SET data type,,
SET GLOBAL SQL_SLAVE_SKIP_COUNTER,
SET OPTION,
SET PASSWORD,
SET PASSWORD statement,
SET SQL_LOG_BIN,
SET TRANSACTION,
passwords,
setting passwords,
setting program variables,
post-installation,
shell syntax,
SHOW BINARY LOGS,
SHOW BINLOG EVENTS,,
SHOW CHARACTER SET,
SHOW COLLATION,
SHOW COLUMNS,,
SHOW CREATE DATABASE,,
SHOW CREATE FUNCTION,
SHOW CREATE
PROCEDURE,
SHOW CREATE
SCHEMA,,
SHOW CREATE TABLE,,
SHOW CREATE VIEW,
SHOW DATABASES,,
SHOW ENGINE,,
SHOW ENGINES,,
SHOW ERRORS,,
SHOW extensions,
SHOW FIELDS,
FUNCTION STATUS,
SHOW GRANTS,,
SHOW INDEX,,
SHOW INNODB STATUS,
SHOW KEYS,,
SHOW MASTER LOGS,,
SHOW MASTER STATUS,,
SHOW OPEN TABLES,,
SHOW PRIVILEGES,,
SHOW PROCEDURE STATUS,
SHOW PROCESSLIST,,
SHOW SCHEMAS,,
SHOW SLAVE HOSTS,,
SHOW SLAVE STATUS,,
SHOW STATUS,
SHOW STORAGE ENGINES,
SHOW TABLE STATUS,
SHOW TABLE TYPES,,
SHOW TABLES,,
SHOW TRIGGERS,,
SHOW VARIABLES,
SHOW WARNINGS,,
SHOW with WHERE,,
show-warnings
shutdown_timeout
variable,
shutting down
the server,
sigint-ignore
mysqld_multi
silent column changes,
single quote (\'),
size of tables,
skip-column-names
skip-line-numbers
slow queries,
slow query log,
data type,
socket location
changing,
Solaris installation problems,
Solaris troubleshooting,
Solaris x86_64 issues,
character sets,
tables,,
table rows,
sort_buffer_size myisamchk
variable,
sort_key_blocks myisamchk
variable,
SOUNDEX(),
SOUNDS LIKE,
source distribution
installing,
source distributions
on Linux,
MySQL中的空间扩展,
compiling,
increasing with replication,
inserting,
of queries,,
SQL commands
replication masters,
replication slaves,
extensions to,
SQL_BIG_RESULT,
SQL_BUFFER_RESULT,
SQL_CACHE,,
SQL_CALC_FOUND_ROWS,
SQL_NO_CACHE,,
SQL_SMALL_RESULT,
sql_yacc.cc
problems,
square brackets,
and X509 Basics,
command-line options,
related options,,
stability,
standard SQL
extensions to,
Standard SQL
differences from,
standards compatibility,
transactions,
START SLAVE,
START TRANSACTION,
comments,
the server,
the server automatically,
Starting many servers,
StartPoint(),
startup options
startup parameters,
mysqladmin,
statements
statically
compiling,
STATISTICS
INFORMATION_SCHEMA
stats_method myisamchk
variable,
status command
status variables,,
STDDEV(),
STDDEV_POP(),
STDDEV_SAMP(),
STOP SLAVE,
the server,
stopword list
user-defined,
storage engine
storage engines
choosing,
storage of data,
storage requirements
column type,
storage space
minimising,
stored procedures,
stored procedures and triggers
stored routine restrictions,
STRAIGHT_JOIN,,
STRCMP(),
STRICT SQL mode,
STRICT_ALL_TABLES
SQL mode,
STRICT_TRANS_TABLES
SQL mode,
string collating,
string comparison functions,
string comparisons
case sensitivity,
string functions,
string literal introducer,,
string types,
escaping characters,
non-delimited,
STR_TO_DATE(),
SUBDATE(),
subpartitioning,
subpartitions,
subqueries,
subquery,
restrictions,
subselects,
SUBSTR(),
SUBSTRING(),
SUBSTRING_INDEX(),
SUBTIME(),
subtraction (-),
SUM(DISTINCT),
superuser,
for operating systems,
mailing address,
suppression
default values,
Sybase compatibility,
symbolic links,,
SymDifference(),
regular expression,
SYSDATE(),
privilege,
security,
system optimization,
system table,
system variables,,,
SYSTEM_USER(),
tab (\t),
changing,,
deleting,
mysql option,
table aliases,
table cache,
table is full,,
table names
case sensitivity,
case-sensitivity,
Table scans
avoiding,
table types
choosing,
table-level locking,
Berkeley DB,
BLACKHOLE,
changing column order,
checking,
compressed format,
constant,,
counting rows,
creating,
defragment,,
defragmenting,
deleting rows,
displaying status,
error checking,
FEDERATED,
fragmentation,
improving performance,
information,
information about,
loading data,
maintenance regimen,
maximum size,
multiple,
optimizing,
partitioning,
repairing,
retrieving data,
selecting columns,
selecting rows,
sorting rows,
symbolic links,
too many,
unique ID for last row,
updating,
INFORMATION_SCHEMA
table_cache,
TABLE_PRIVILEGES
INFORMATION_SCHEMA
problems on Solaris,
mysqld_multi
TCP/IP,,
technical support
mailing address,
temporary file
write access,
temporary tables
problems,
terminal monitor
connection to the server,
installation,
releases,
post-installation,
testing mysqld
mysqltest,
TEXT columns
default values,
indexing,,
TEXT data type,,
thread packages
differences between,
thread support,
non-native,
threaded clients,
threads,,,
TIME data type,,
time types,
time zone problems,
TIMEDIFF(),
timeout,,,
connect_timeout variable,,
shutdown_timeout
variable,
and NULL values,
TIMESTAMP data type,,
TIMESTAMP(),
TIMESTAMPADD(),
TIMESTAMPDIFF(),
TIME_FORMAT(),
TIME_TO_SEC(),
TINYBLOB data type,
TINYINT data type,
TINYTEXT data type,
optimization,
environment variable,,
embedded server,
symlinks,
Touches(),
TO_DAYS(),
trace DBI method,
TRADITIONAL SQL mode,
transaction-safe tables,,
transactions
support,,
Translators
trigger restrictions,
triggers,,,
INFORMATION_SCHEMA
troubleshooting
testing for,
TRUNCATE,
TRUNCATE(),
tutorial,
Twin Studies
type conversions,
columns,,
Date and Time,
of tables,
portability,
typographical conventions,
environment variable,,
compiling,
return values,
environment variable,,
environment variable,,
unary minus (-),
unbuffered
UNCOMPRESS(),
UNCOMPRESSED_LENGTH(),
Unicode Collation
Algorithm,
constraint,
unique ID,
UNIX_TIMESTAMP(),
testing for,
UNLOCK TABLES,
unnamed views,
releases of MySQL,
upgrading,
different architecture,
grant tables,
URLs for downloading MySQL,
USE INDEX,,
USE KEY,,
mysqld_multi
user accounts
creating,
renaming,
USER environment variable,,
user privileges
deleting,,
dropping,,
user table
user variables,
user-defined functions
adding,,
User-defined functions,
passwords,
adding,,
deleting,,
USER_PRIVILEGES
INFORMATION_SCHEMA
of MySQL,
using multiple disks to start data,
UTC_DATE(),
UTC_TIME(),
UTC_TIMESTAMP(),
valid numbers
examples,
VALUES(),
data type,,
VARCHAR data type,,
VARCHARACTER data type,
server,,
status,,
system,,
VARIANCE(),
VAR_POP(),
VAR_SAMP(),
mysql option,
mysqld_multi option,
choosing,
mysql option,
mysqld_multi option,
VERSION(),
view restrictions,
views,,,
updatable,,
INFORMATION_SCHEMA
virtual memory
problems while compiling,
Visual Basic,
mysql option,
WEEKDAY(),
WEEKOFYEAR(),
Well-Known Binary format,
Well-Known Text format,
What is an X509/Certificate?,
What is encryption,
with SHOW,,
Wildcard character (%),
Wildcard character (_),
and LIKE,
in mysql.columns_priv table,
in mysql.db table,
in mysql.host table,
in mysql.tables_priv table,
in mysql.user table,
compiling on,
open issues,
upgrading,
versus Unix,
with-big-tables option,
Within(),
without-server option,
Word program,
write access
write_buffer_size myisamchk
variable,
XA BEGIN,
ROLLBACK,
transactions,
transaction identifiers,
transaction identifier,
Year 2000 compliance,
Year 2000 issues,
YEAR data type,,
YEARWEEK(),
这是MySQL参考手册的翻译版本,关于MySQL参考手册,请访问。
原始参考手册为英文版,与英文版参考手册相比,本翻译版可能不是最新的。}

我要回帖

更多关于 b p m f d t n l 的文章

更多推荐

版权声明:文章内容来源于网络,版权归原作者所有,如有侵权请点击这里与我们联系,我们将及时删除。

点击添加站长微信