Secure FTP (sFTP) Hosting
Alden Hosting offers Secure FTP (sFTP) on our
WEB 5 PLAN and our
WEB 6 PLAN .
At Alden Hosting we eat and breathe Secure FTP (sFTP)!
Index Symbols ! (logical NOT), Logical Operators != (not equal), Comparison Functions and Operators ", Database, Table, Index, Column, and Alias Names %, Arithmetic Operators % (modulo), Mathematical Functions % (wildcard character), Strings & (bitwise AND), Bit Functions && (logical AND), Logical Operators () (parentheses), Operator Precedence (Control-Z) \Z, Strings * (multiplication), Arithmetic Operators + (addition), Arithmetic Operators - (subtraction), Arithmetic Operators - (unary minus), Arithmetic Operators --config-file option (ndb_mgmd), Command Options for ndb_mgmd --connect-string option (MySQL Cluster), Command Options for MySQL Cluster Processes --debug option (MySQL Cluster), Command Options for MySQL Cluster Processes --execute option (MySQL Cluster), Command Options for MySQL Cluster Processes --help option MySQL Cluster programs, Command Options for MySQL Cluster Processes --initial option (ndbd), Command Options for ndbd --initial-start option (ndbd), Command Options for ndbd --ndb-connectstring option (MySQL Cluster), MySQL Cluster-Related Command Options for mysqld --ndbcluster option (MySQL Cluster), MySQL Cluster-Related Command Options for mysqld --nodaemon option (ndbd), Command Options for ndbd --nostart option (ndbd), Command Options for ndbd --nowait-nodes option (ndbd), Command Options for ndbd --password option, Keeping Your Password Secure --usage option MySQL Cluster programs, Command Options for MySQL Cluster Processes --version option (MySQL Cluster), Command Options for MySQL Cluster Processes -? option MySQL Cluster programs, Command Options for MySQL Cluster Processes -c option (MySQL Cluster), Command Options for MySQL Cluster Processes -c option (ndb_mgmd) (OBSOLETE), Command Options for ndb_mgmd -e option (MySQL Cluster), Command Options for MySQL Cluster Processes -f option (ndb_mgmd), Command Options for ndb_mgmd -n option (ndbd), Command Options for ndbd -p option, Keeping Your Password Secure -V option (MySQL Cluster), Command Options for MySQL Cluster Processes .my.cnf file, Using Option Files , Connecting to the MySQL Server , Causes of Access denied Errors , Keeping Your Password Secure , Using Client Programs in a Multiple-Server Environment .mysql_history file, mysql Options .pid (process ID) file, Setting Up a Table Maintenance Schedule / (division), Arithmetic Operators /etc/passwd, Making MySQL Secure Against Attackers , SELECT Syntax := (assignment), User-Defined Variables < (less than), Comparison Functions and Operators <<, Calculating Visits Per Day << (left shift), Bit Functions <= (less than or equal), Comparison Functions and Operators <=> (equal to), Comparison Functions and Operators <> (not equal), Comparison Functions and Operators = (assignment), User-Defined Variables = (equal), Comparison Functions and Operators > (greater than), Comparison Functions and Operators >= (greater than or equal), Comparison Functions and Operators >> (right shift), Bit Functions [API] (MySQL Cluster), SQL Node and API Node Configuration Parameters [MGM] (MySQL Cluster), Management Node Configuration Parameters [NDBD] (MySQL Cluster), Data Node Configuration Parameters [NDBD_DEFAULT] (MySQL Cluster), Data Node Configuration Parameters [NDB_MGMD] (MySQL Cluster), Management Node Configuration Parameters [SQL] (MySQL Cluster), SQL Node and API Node Configuration Parameters \" (double quote), Strings \' (single quote), Strings \. (mysql client command), Using mysql in Batch Mode , Executing SQL Statements from a Text File \0 (ASCII 0), Strings \b (backspace), Strings \n (linefeed), Strings \n (newline), Strings \r (carriage return), Strings \t (tab), Strings \Z (Control-Z) ASCII 26, Strings \\ (escape), Strings ^ (bitwise XOR), Bit Functions _ (wildcard character), Strings _rowid, CREATE TABLE Syntax `, Database, Table, Index, Column, and Alias Names | (bitwise OR), Bit Functions || (logical OR), Logical Operators ~, Bit Functions A abort-slave-event-count option mysqld, Command Options aborted clients, Communication Errors and Aborted Connections aborted connection, Communication Errors and Aborted Connections ABS(), Mathematical Functions access control, Access Control, Stage 1: Connection Verification access denied errors, Access denied access privileges, The MySQL Access Privilege System account privileges adding, Adding New User Accounts to MySQL accounts anonymous user, Securing the Initial MySQL Accounts root, Securing the Initial MySQL Accounts ACID, Transactions and Atomic Operations , InnoDB Overview ACLs, The MySQL Access Privilege System ACOS(), Mathematical Functions Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP) ActiveState Perl, Installing ActiveState Perl on Windows add-drop-database option mysqldump, mysqldump — A Database Backup Program add-drop-table option mysqldump, mysqldump — A Database Backup Program add-locks option mysqldump, mysqldump — A Database Backup Program ADDDATE(), Date and Time Functions adding character sets, Adding a New Character Set native functions, Adding a New Native Function new account privileges, Adding New User Accounts to MySQL new functions, Adding New Functions to MySQL new user privileges, Adding New User Accounts to MySQL new users, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems , Source Installation Overview procedures, Adding New Procedures to MySQL user-defined functions, Adding a New User-Defined Function addition (+), Arithmetic Operators ADDTIME(), Date and Time Functions addtodest option mysqlhotcopy, mysqlhotcopy — A Database Backup Program AES_DECRYPT(), Encryption and Compression Functions AES_ENCRYPT(), Encryption and Compression Functions age calculating, Date Calculations alias, Problems with Column Aliases alias names case sensitivity, Identifier Case Sensitivity aliases for expressions, GROUP BY and HAVING with Hidden
Fields for tables, SELECT Syntax in GROUP BY clauses, GROUP BY and HAVING with Hidden
Fields names, Database, Table, Index, Column, and Alias Names on expressions, SELECT Syntax ALL, SELECT Syntax , Subqueries with ALL all-databases option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program all-in-1 option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program allow-keywords option mysqldump, mysqldump — A Database Backup Program allow-suspicious-udfs option mysqld, Command Options , Security-Related mysqld Options allowold option mysqlhotcopy, mysqlhotcopy — A Database Backup Program ALLOW_INVALID_DATES SQL mode, SQL Modes ALTER COLUMN, ALTER TABLE Syntax ALTER DATABASE, ALTER DATABASE Syntax ALTER FUNCTION, ALTER PROCEDURE and ALTER FUNCTION
Syntax ALTER PROCEDURE, ALTER PROCEDURE and ALTER FUNCTION
Syntax ALTER SCHEMA, ALTER DATABASE Syntax ALTER TABLE, ALTER TABLE Syntax , Problems with ALTER TABLE ALTER VIEW, ALTER VIEW Syntax altering database, ALTER DATABASE Syntax schema, ALTER DATABASE Syntax analyze option myisamchk, Other myisamchk Options mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program ANALYZE TABLE, ANALYZE TABLE Syntax AND bitwise, Bit Functions logical, Logical Operators angel-pid-file option mysqlmanager, MySQL Instance Manager Command Options anonymous user, Securing the Initial MySQL Accounts , Access Control, Stage 1: Connection Verification , Access Control, Stage 2: Request Verification ANSI mode running, Running MySQL in ANSI Mode ansi option mysqld, Command Options ANSI SQL mode, SQL Modes ANSI_QUOTES SQL mode, SQL Modes answering questions etiquette, Guidelines for Using the Mailing Lists ANY, Subqueries with ANY, IN, and
SOME Apache, Using MySQL with Apache API node (MySQL Cluster) defined, Basic MySQL Cluster Concepts API nodes, MySQL Server Process Usage for MySQL Cluster API's list of, Packages that support MySQL APIs, APIs and Libraries Perl, MySQL Perl API approximate-value literals, Precision Math ArbitrationDelay, Defining the Management Server , Defining SQL and Other API Nodes ArbitrationRank, Defining the Management Server , Defining SQL and Other API Nodes ArbitrationTimeout (MySQL Cluster configuration
parameter), Defining Data Nodes arbitrator, MySQL 5.0 FAQ — MySQL Cluster ARCHIVE storage engine, Storage Engines , The ARCHIVE Storage Engine Area(), Polygon Functions , MultiPolygon Functions argument processing, UDF Argument Processing arithmetic expressions, Arithmetic Operators arithmetic functions, Bit Functions AS, SELECT Syntax , JOIN Syntax AsBinary(), Geometry Format Conversion Functions ASCII(), String Functions ASIN(), Mathematical Functions AsText(), Geometry Format Conversion Functions ATAN(), Mathematical Functions ATAN2(), Mathematical Functions attackers security against, Making MySQL Secure Against Attackers AUTO-INCREMENT ODBC, Obtaining Auto-Increment Values auto-rehash option mysql, mysql Options auto-repair option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program autoclose option mysqld_safe, mysqld_safe — MySQL Server Startup Script AUTO_INCREMENT, Using AUTO_INCREMENT and NULL values, Problems with NULL Values AVG(), GROUP BY (Aggregate) Functions AVG(DISTINCT), GROUP BY (Aggregate) Functions B backslash escape character, Literal Values backspace (\b), Strings backup option myisamchk, myisamchk Repair Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables BACKUP TABLE, BACKUP TABLE Syntax BackupDataBufferSize, Configuration for Cluster Backup BackupDataBufferSize (MySQL Cluster configuration
parameter), Defining Data Nodes BackupDataDir, Defining Data Nodes BackupLogBufferSize, Defining Data Nodes , Configuration for Cluster Backup BackupMaxWriteSize, Defining Data Nodes , Configuration for Cluster Backup BackupMemory, Defining Data Nodes , Configuration for Cluster Backup backups, Database Backups database, BACKUP TABLE Syntax in MySQL Cluster, On-line Backup of MySQL Cluster , Cluster Backup Concepts , Using The Management Client to Create a Backup , Configuration for Cluster Backup backups, troubleshooting in MySQL Cluster, Backup Troubleshooting BackupWriteSize, Defining Data Nodes , Configuration for Cluster Backup basedir option mysql.server, mysql.server — MySQL Server Startup Script mysqld, Command Options mysqld_safe, mysqld_safe — MySQL Server Startup Script mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade batch mode, Using mysql in Batch Mode batch option mysql, mysql Options BatchByteSize, Defining SQL and Other API Nodes BatchSize, Defining SQL and Other API Nodes BatchSizePerLocalScan, Defining Data Nodes BDB storage engine, Storage Engines , The BDB (BerkeleyDB) Storage
Engine BDB tables, Transactions and Atomic Operations bdb-home option mysqld, BDB Startup Options bdb-lock-detect option mysqld, BDB Startup Options bdb-logdir option mysqld, BDB Startup Options bdb-no-recover option mysqld, BDB Startup Options bdb-no-sync option mysqld, BDB Startup Options bdb-shared-data option mysqld, BDB Startup Options bdb-tmpdir option mysqld, BDB Startup Options BdMPolyFromText(), Creating Geometry Values Using WKT Functions BdMPolyFromWKB(), Creating Geometry Values Using WKB Functions BdPolyFromText(), Creating Geometry Values Using WKT Functions BdPolyFromWKB(), Creating Geometry Values Using WKB Functions BEGIN, START TRANSACTION, COMMIT, and
ROLLBACK Syntax , BEGIN ... END Compound Statement Syntax XA transactions, XA Transaction SQL Syntax benchmark suite, The MySQL Benchmark Suite BENCHMARK(), Information Functions benchmarks, Using Your Own Benchmarks BerkeleyDB storage engine, Storage Engines , The BDB (BerkeleyDB) Storage
Engine BETWEEN ... AND, Comparison Functions and Operators big5, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Big5 Chinese character encoding, Case Sensitivity in Searches BIGINT data type, Overview of Numeric Types BIN(), String Functions BINARY, Cast Functions and Operators BINARY data type, Overview of String Types , The BINARY and VARBINARY Types binary distributions, MySQL Binaries Compiled by MySQL AB installing, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems on Linux, Linux Binary Distribution Notes binary log, The Binary Log binary logging and MySQL Cluster, Issues Exclusive to MySQL Cluster bind-address option mysqld, Command Options mysqlmanager, MySQL Instance Manager Command Options binlog-do-db option mysqld, The Binary Log binlog-ignore-db option mysqld, The Binary Log BIT data type, Overview of Numeric Types BitKeeper tree, Installing from the Development Source Tree BIT_AND(), GROUP BY (Aggregate) Functions BIT_COUNT, Calculating Visits Per Day BIT_COUNT(), Bit Functions bit_functions example, Calculating Visits Per Day BIT_LENGTH(), String Functions BIT_OR, Calculating Visits Per Day BIT_OR(), GROUP BY (Aggregate) Functions BIT_XOR(), GROUP BY (Aggregate) Functions BLACKHOLE storage engine, Storage Engines , The BLACKHOLE Storage Engine BLOB inserting binary data, Strings size, Data Type Storage Requirements BLOB columns default values, The BLOB and TEXT Types indexing, Column Indexes , CREATE TABLE Syntax BLOB data type, Overview of String Types , The BLOB and TEXT Types block-search option myisamchk, Other myisamchk Options BOOL data type, Overview of Numeric Types BOOLEAN data type, Overview of Numeric Types bootstrap option mysqld, Command Options Borland Builder 4, Using Connector/ODBC with Borland Builder 4 Borland C++ compiler, Building MySQL from Source Using Borland C++ Boundary(), General Geometry Functions brackets square, Data Types brief option mysqlaccess, mysqlaccess — Client for Checking Access Privileges buffer sizes client, APIs and Libraries mysqld server, Tuning Server Parameters Buffer(), Spatial Operators bug reports criteria for, How to Report Bugs or Problems bugs known, Known Issues in MySQL reporting, How to Report Bugs or Problems bugs database, How to Report Bugs or Problems bugs.mysql.com, How to Report Bugs or Problems building client programs, Building Client Programs C C API data types, MySQL C API functions, C API Function Overview linking problems, Problems Linking with the C API C Prepared statement API functions, C API Prepared Statement Function Overview C++ APIs, MySQL C++ API C++ Builder, Using Connector/ODBC with C++ Builder C++ compiler gcc, Typical configure Options C++ compiler cannot create executables, Dealing with Problems Compiling MySQL C:\my.cnf file, Using Client Programs in a Multiple-Server Environment CACHE INDEX, CACHE INDEX Syntax caches clearing, FLUSH Syntax calculating dates, Date Calculations calendar, What Calendar Is Used By MySQL? CALL, CALL Statement Syntax calling sequences for aggregate functions UDF, UDF Calling Sequences for Aggregate Functions calling sequences for simple functions UDF, UDF Calling Sequences for Simple Functions can't create/write to file, Can't create/write to file carriage return (\r), Strings CASE, Control Flow Functions , CASE Statement case sensitivity in access checking, How the Privilege System Works in identifiers, Identifier Case Sensitivity in names, Identifier Case Sensitivity in searches, Case Sensitivity in Searches in string comparisons, String Comparison Functions case-sensitivity of database names, MySQL Extensions to Standard SQL of table names, MySQL Extensions to Standard SQL CAST, Cast Functions and Operators cast functions, Cast Functions and Operators cast operators, Cast Functions and Operators casts, Type Conversion in Expression Evaluation , Comparison Functions and Operators , Cast Functions and Operators CC environment variable, Typical configure Options , Dealing with Problems Compiling MySQL , Environment Variables cc1plus problems, Dealing with Problems Compiling MySQL CEILING(), Mathematical Functions Centroid(), MultiPolygon Functions CFLAGS environment variable, Typical configure Options , Dealing with Problems Compiling MySQL , Environment Variables CHANGE MASTER TO, CHANGE MASTER TO Syntax ChangeLog, MySQL Change History changes Cluster, Changes in MySQL Cluster log, MySQL Change History MySQL 5.0, Changes in release 5.0.x (Production) MySQL Community Server, MySQL Community Server Enhancements and Release Notes MySQL Enterprise, MySQL Enterprise Release Notes changes to privileges, Access Control, Stage 2: Request Verification changing column, ALTER TABLE Syntax column order, How to Change the Order of Columns in a Table field, ALTER TABLE Syntax table, ALTER TABLE Syntax , Problems with ALTER TABLE changing socket location, Typical configure Options , Starting and Stopping MySQL Automatically , How to Protect or Change the MySQL Unix Socket File CHAR data type, Overview of String Types , String Types CHAR VARYING data type, Overview of String Types CHAR(), String Functions CHARACTER data type, Overview of String Types character sets, Typical configure Options , The Character Set Used for Data and Sorting adding, Adding a New Character Set Character sets, Character Set Support CHARACTER VARYING data type, Overview of String Types character-set-client-handshake option mysqld, Command Options character-set-filesystem option mysqld, Command Options character-set-server option mysqld, Command Options character-sets-dir option myisamchk, myisamchk Repair Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information characters multi-byte, Multi-Byte Character Support CHARACTER_LENGTH(), String Functions CHARACTER_SETS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table charset option comp_err, comp_err — Compile MySQL Error Message File CHARSET(), Information Functions CHAR_LENGTH(), String Functions check option myisamchk, myisamchk Check Options mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program check options myisamchk, myisamchk Check Options CHECK TABLE, CHECK TABLE Syntax check-only-changed option myisamchk, myisamchk Check Options mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program check-upgrade option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program checking tables for errors, How to Check MyISAM Tables for Errors CHECKPOINT Events (MySQL Cluster), Log Events checkpoint option mysqlhotcopy, mysqlhotcopy — A Database Backup Program Checksum, Cluster TCP/IP Connections Checksum (MySQL Cluster), Shared-Memory Connections , SCI Transport Connections checksum errors, Solaris Notes CHECKSUM TABLE, CHECKSUM TABLE Syntax Chinese, Case Sensitivity in Searches Chinese, Japanese, Korean character sets frequently asked questions, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets choosing a MySQL version, Choosing Which MySQL Distribution to Install choosing types, Choosing the Right Type for a Column chroot option mysqld, Command Options mysqlhotcopy, mysqlhotcopy — A Database Backup Program CJK FAQ, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets CJK (Chinese, Japanese, Korean) Access, PHP, etc., MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets availability of specific characters, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets available character sets, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets big5, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets character sets available, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets characters displayed as question marks, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets CJKV, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets collations, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets conversion problems with Japanese character sets, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets data truncation, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Database and table names, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets documentation in Chinese, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets documentation in Japanese, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets documentation in Korean, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets gb2312, gbk, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Japanese character sets, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Korean character set, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets LIKE and FULLTEXT, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets MySQL 4.0 behavior, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets ORDER BY treatment, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with Access, PHP, etc., MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with Big5 character sets (Chinese), MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with data truncation, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with euckr character set (Korean), MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with GB character sets (Chinese), MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with LIKE and FULLTEXT, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets problems with Yen sign (Japanese), MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets rejected characters, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets sort order problems, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets sorting problems, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets testing availability of characters, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Unicode collations, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Vietnamese, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Yen sign, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets clear option mysql_tableinfo, mysql_tableinfo — Generate Database Metadata clear-only option mysql_tableinfo, mysql_tableinfo — Generate Database Metadata clearing caches, FLUSH Syntax client programs, Overview of Client and Utility Programs building, Building Client Programs client tools, APIs and Libraries clients threaded, How to Make a Threaded Client CLOSE, Cursor CLOSE Statement closing tables, How MySQL Opens and Closes Tables cluster logs, Event Reports Generated in MySQL Cluster , Logging Management Commands Clustering, MySQL Cluster CLUSTERLOG commands (MySQL Cluster), Logging Management Commands CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS CMake, Building MySQL from Source Using CMake and Visual Studio COALESCE(), Comparison Functions and Operators COERCIBILITY(), Information Functions col option mysql_tableinfo, mysql_tableinfo — Generate Database Metadata ColdFusion, Using Connector/ODBC with ColdFusion collating strings, String Collating Support COLLATION(), Information Functions collation-server option mysqld, Command Options COLLATIONS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table COLLATION_CHARACTER_SET_APPLICABILITY INFORMATION_SCHEMA table, The INFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITY Table column changing, ALTER TABLE Syntax types, Data Types column comments, CREATE TABLE Syntax column names case sensitivity, Identifier Case Sensitivity column-names option mysql, mysql Options columns changing, How to Change the Order of Columns in a Table indexes, Column Indexes names, Database, Table, Index, Column, and Alias Names other types, Using Data Types from Other Database Engines selecting, Selecting Particular Columns storage requirements, Data Type Storage Requirements COLUMNS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table columns option mysqlimport, mysqlimport — A Data Import Program COLUMN_PRIVILEGES INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table comma-separated values data, reading, LOAD DATA INFILE Syntax , SELECT Syntax command options mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqld, Command Options command options (MySQL Cluster), Command Options for MySQL Cluster Processes mysqld, MySQL Cluster-Related Command Options for mysqld ndbd, Command Options for ndbd ndb_mgm, Command Options for ndb_mgm ndb_mgmd, Command Options for ndb_mgmd command syntax, Conventions Used in This Manual command-line history mysql, mysql Options commands for binary distribution, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems commands out of sync, Commands out of sync Comment syntax, Comment Syntax comments adding, Comment Syntax starting, '--' as the Start of a Comment comments option mysqldump, mysqldump — A Database Backup Program COMMIT, Transactions and Atomic Operations , START TRANSACTION, COMMIT, and
ROLLBACK Syntax XA transactions, XA Transaction SQL Syntax commit option mysqlaccess, mysqlaccess — Client for Checking Access Privileges compact option mysqldump, mysqldump — A Database Backup Program comparison operators, Comparison Functions and Operators compatibility between MySQL versions, Upgrading from MySQL 4.1 to 5.0 with mSQL, String Comparison Functions with ODBC, Identifier Qualifiers , Overview of Numeric Types , Type Conversion in Expression Evaluation , Comparison Functions and Operators , CREATE TABLE Syntax , JOIN Syntax with Oracle, MySQL Extensions to Standard SQL , GROUP BY (Aggregate) Functions , DESCRIBE Syntax with PostgreSQL, MySQL Extensions to Standard SQL with standard SQL, MySQL Standards Compliance with Sybase, USE Syntax compatible option mysqldump, mysqldump — A Database Backup Program compiler C++ gcc, Typical configure Options compiling on Windows, Compiling MySQL Clients on Windows optimizing, System Factors and Startup Parameter Tuning problems, Dealing with Problems Compiling MySQL speed, How Compiling and Linking Affects the Speed of MySQL statically, Typical configure Options user-defined functions, Compiling and Installing User-Defined Functions complete-insert option mysqldump, mysqldump — A Database Backup Program compliance Y2K, Year 2000 Issues and Date Types compress option mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information COMPRESS(), Encryption and Compression Functions compressed tables, Compressed Table Characteristics comp_err, Overview of Server-Side Programs charset option, comp_err — Compile MySQL Error Message File debug option, comp_err — Compile MySQL Error Message File debug-info option, comp_err — Compile MySQL Error Message File header_file option, comp_err — Compile MySQL Error Message File help option, comp_err — Compile MySQL Error Message File in_file option, comp_err — Compile MySQL Error Message File name_file option, comp_err — Compile MySQL Error Message File out_dir option, comp_err — Compile MySQL Error Message File out_file option, comp_err — Compile MySQL Error Message File statefile option, comp_err — Compile MySQL Error Message File version option, comp_err — Compile MySQL Error Message File CONCAT(), String Functions CONCAT_WS(), String Functions concurrent inserts, Internal Locking Methods , Concurrent Inserts Conditions, DECLARE Conditions config-file option mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers my_print_defaults, my_print_defaults — Display Options from Option Files ndb_config, ndb_config — Extract NDB Configuration Information config.cache, Dealing with Problems Compiling MySQL config.cache file, Dealing with Problems Compiling MySQL config.ini (MySQL Cluster), Multi-Computer Configuration , Configuration File , Basic Example Configuration , ndb_mgmd — The Management Server Process configuration MySQL Cluster, Overview of Cluster Configuration Parameters configuration files, Causes of Access denied Errors configuration options, Typical configure Options configure disable-grant-options option, Typical configure Options enable-thread-safe-client option, Typical configure Options localstatedir option, Typical configure Options previx option, Typical configure Options running after prior invocation, Dealing with Problems Compiling MySQL with-big-tables option, Typical configure Options with-charset option, Typical configure Options with-collation option, Typical configure Options with-debug option, Typical configure Options with-embedded-server option, Typical configure Options with-extra-charsets option, Typical configure Options with-unix-socket-path option, Typical configure Options without-server option, Typical configure Options configure option --with-low-memory, Dealing with Problems Compiling MySQL configure script, Typical configure Options configuring backups in MySQL Cluster, Configuration for Cluster Backup configuring MySQL Cluster, Simple Multi-Computer How-To , MySQL Cluster Configuration , MySQL Server Process Usage for MySQL Cluster , ndb_mgmd — The Management Server Process Configuring MySQL Cluster (concepts), Basic MySQL Cluster Concepts connecting remotely with SSH, Connecting to MySQL Remotely from Windows with SSH to the server, Connecting to and Disconnecting from the Server , Connecting to the MySQL Server verification, Access Control, Stage 1: Connection Verification connection aborted, Communication Errors and Aborted Connections CONNECTION Events (MySQL Cluster), Log Events CONNECTION_ID(), Information Functions Connector/JDBC, Connectors Connector/MXJ, Connectors Connector/NET, Connectors , MySQL Connector/NET reporting problems, Connector/NET Support Connector/ODBC, Connectors , MySQL Connector/ODBC Borland, Using Connector/ODBC with Borland Applications Borland Database Engine, Using Connector/ODBC with Borland Applications reporting problems, Connector/ODBC Support Connectors MySQL, Connectors connectstring, The Cluster Connectstring connect_timeout variable, mysql Options , mysqladmin — Client for Administering a MySQL Server console option mysqld, Command Options constant table, Optimizing Queries with EXPLAIN , WHERE Clause Optimization constraints, How MySQL Deals with Constraints CONSTRAINTS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table Contains(), Functions That Test Spatial Relationships Between Geometries contributing companies list of, Supporters of MySQL contributors list of, Contributors to MySQL control access, Access Control, Stage 1: Connection Verification control flow functions, Control Flow Functions CONV(), String Functions conventions typographical, Conventions Used in This Manual CONVERT, Cast Functions and Operators CONVERT TO, ALTER TABLE Syntax CONVERT_TZ(), Date and Time Functions ConvexHull(), Spatial Operators copy option mysqlaccess, mysqlaccess — Client for Checking Access Privileges copying databases, Copying MySQL Databases to Another Machine copying tables, CREATE TABLE Syntax core-file option mysqld, Command Options core-file-size option mysqld_safe, mysqld_safe — MySQL Server Startup Script correct-checksum option myisamchk, myisamchk Repair Options correlated subqueries, Correlated Subqueries COS(), Mathematical Functions COT(), Mathematical Functions count option myisam_ftdump, myisam_ftdump — Display Full-Text Index information mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlshow, mysqlshow — Display Database, Table, and Column Information COUNT(), GROUP BY (Aggregate) Functions COUNT(DISTINCT), GROUP BY (Aggregate) Functions counting table rows, Counting Rows crash recovery, Using myisamchk for Crash Recovery repeated, What to Do If MySQL Keeps Crashing crash-me, The MySQL Benchmark Suite crash-me program, Designing Applications for Portability , The MySQL Benchmark Suite CRC32(), Mathematical Functions CREATE DATABASE, CREATE DATABASE Syntax CREATE FUNCTION, CREATE PROCEDURE and CREATE
FUNCTION Syntax , CREATE FUNCTION Syntax CREATE INDEX, CREATE INDEX Syntax CREATE PROCEDURE, CREATE PROCEDURE and CREATE
FUNCTION Syntax CREATE SCHEMA, CREATE DATABASE Syntax CREATE TABLE, CREATE TABLE Syntax CREATE TRIGGER, CREATE TRIGGER Syntax CREATE USER, CREATE USER Syntax CREATE VIEW, CREATE VIEW Syntax create-options option mysqldump, mysqldump — A Database Backup Program creating bug reports, How to Report Bugs or Problems database, CREATE DATABASE Syntax databases, Creating and Using a Database default startup options, Using Option Files function, CREATE FUNCTION Syntax schema, CREATE DATABASE Syntax tables, Creating a Table creating user accounts, CREATE USER Syntax CROSS JOIN, JOIN Syntax Crosses(), Functions That Test Spatial Relationships Between Geometries CR_SERVER_GONE_ERROR, MySQL server has gone away CR_SERVER_LOST_ERROR, MySQL server has gone away CSV data, reading, LOAD DATA INFILE Syntax , SELECT Syntax CSV storage engine, Storage Engines , The CSV Storage Engine CURDATE(), Date and Time Functions CURRENT_DATE, Date and Time Functions CURRENT_TIME, Date and Time Functions CURRENT_TIMESTAMP, Date and Time Functions CURRENT_USER(), Information Functions Cursors, Cursors CURTIME(), Date and Time Functions customers of MySQL, What We Have Used MySQL For CXX environment variable, Typical configure Options , Dealing with Problems Compiling MySQL , Environment Variables CXXFLAGS environment variable, Typical configure Options , Dealing with Problems Compiling MySQL , Environment Variables D data character sets, The Character Set Used for Data and Sorting importing, Executing SQL Statements from a Text File loading into tables, Loading Data into a Table retrieving, Retrieving Information from a Table size, Make Your Data as Small as Possible data node (MySQL Cluster) defined, Basic MySQL Cluster Concepts Data truncation with CJK characters, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets data type BIGINT, Overview of Numeric Types BINARY, Overview of String Types , The BINARY and VARBINARY Types BIT, Overview of Numeric Types BLOB, Overview of String Types , The BLOB and TEXT Types BOOL, Overview of Numeric Types , Using Data Types from Other Database Engines BOOLEAN, Overview of Numeric Types , Using Data Types from Other Database Engines CHAR, Overview of String Types , String Types CHAR VARYING, Overview of String Types CHARACTER, Overview of String Types CHARACTER VARYING, Overview of String Types DATE, Overview of Date and Time Types , The DATETIME, DATE, and
TIMESTAMP Types DATETIME, Overview of Date and Time Types , The DATETIME, DATE, and
TIMESTAMP Types DEC, Overview of Numeric Types DECIMAL, Overview of Numeric Types , Precision Math DOUBLE, Overview of Numeric Types DOUBLE PRECISION, Overview of Numeric Types ENUM, Overview of String Types , The ENUM Type FIXED, Overview of Numeric Types FLOAT, Overview of Numeric Types GEOMETRY, MySQL Spatial Data Types GEOMETRYCOLLECTION, MySQL Spatial Data Types INT, Overview of Numeric Types INTEGER, Overview of Numeric Types LINESTRING, MySQL Spatial Data Types LONG, The BLOB and TEXT Types LONGBLOB, Overview of String Types LONGTEXT, Overview of String Types MEDIUMBLOB, Overview of String Types MEDIUMINT, Overview of Numeric Types MEDIUMTEXT, Overview of String Types MULTILINESTRING, MySQL Spatial Data Types MULTIPOINT, MySQL Spatial Data Types MULTIPOLYGON, MySQL Spatial Data Types NATIONAL CHAR, Overview of String Types NCHAR, Overview of String Types NUMERIC, Overview of Numeric Types POINT, MySQL Spatial Data Types POLYGON, MySQL Spatial Data Types REAL, Overview of Numeric Types SET, Overview of String Types , The SET Type SMALLINT, Overview of Numeric Types TEXT, Overview of String Types , The BLOB and TEXT Types TIME, Overview of Date and Time Types , The TIME Type TIMESTAMP, Overview of Date and Time Types , The DATETIME, DATE, and
TIMESTAMP Types TINYBLOB, Overview of String Types TINYINT, Overview of Numeric Types TINYTEXT, Overview of String Types VARBINARY, Overview of String Types , The BINARY and VARBINARY Types VARCHAR, Overview of String Types , String Types VARCHARACTER, Overview of String Types YEAR, Overview of Date and Time Types , The YEAR Type data types, Data Types C API, MySQL C API overview, Data Type Overview data-file-length option myisamchk, myisamchk Repair Options database altering, ALTER DATABASE Syntax creating, CREATE DATABASE Syntax deleting, DROP DATABASE Syntax database design, Design Choices Database information obtaining, SHOW Syntax database metadata, The INFORMATION_SCHEMA Database database names case sensitivity, Identifier Case Sensitivity case-sensitivity, MySQL Extensions to Standard SQL database option mysql, mysql Options mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files DATABASE(), Information Functions databases backups, Database Backups copying, Copying MySQL Databases to Another Machine creating, Creating and Using a Database defined, What is MySQL? information about, Getting Information About Databases and Tables names, Database, Table, Index, Column, and Alias Names replicating, Replication selecting, Creating and Selecting a Database symbolic links, Using Symbolic Links for Databases on Unix using, Creating and Using a Database databases option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program DataDir, Defining the Management Server , Defining Data Nodes datadir option mysql.server, mysql.server — MySQL Server Startup Script mysqld, Command Options mysqld_safe, mysqld_safe — MySQL Server Startup Script mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade DataJunction, Using Connector/ODBC with Pervasive Software DataJunction DataMemory, Defining Data Nodes , Configuring Parameters for Local Checkpoints DATE, Problems Using DATE Columns date and time functions, Date and Time Functions Date and Time types, Date and Time Types date calculations, Date Calculations DATE columns problems, Problems Using DATE Columns DATE data type, Overview of Date and Time Types , The DATETIME, DATE, and
TIMESTAMP Types date functions Y2K compliance, Year 2000 Issues and Date Types date option mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log date types, Data Type Storage Requirements Y2K issues, Year 2000 Issues and Date Types date values problems, The DATETIME, DATE, and
TIMESTAMP Types DATE(), Date and Time Functions DATEDIFF(), Date and Time Functions DATETIME data type, Overview of Date and Time Types , The DATETIME, DATE, and
TIMESTAMP Types DATE_ADD(), Date and Time Functions DATE_FORMAT(), Date and Time Functions DATE_SUB(), Date and Time Functions DAY(), Date and Time Functions DAYNAME(), Date and Time Functions DAYOFMONTH(), Date and Time Functions DAYOFWEEK(), Date and Time Functions DAYOFYEAR(), Date and Time Functions db option mysqlaccess, mysqlaccess — Client for Checking Access Privileges db table sorting, Access Control, Stage 2: Request Verification DB2 SQL mode, SQL Modes DBI interface, MySQL Perl API DBI->quote, Strings DBI/DBD interface, MySQL Perl API DBI_TRACE environment variable, Environment Variables DBI_USER environment variable, Environment Variables DEALLOCATE PREPARE, SQL Syntax for Prepared Statements debug option comp_err, comp_err — Compile MySQL Error Message File make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive myisamchk, myisamchk General Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysql, mysql Options mysqlaccess, mysqlaccess — Client for Checking Access Privileges mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information my_print_defaults, my_print_defaults — Display Options from Option Files debug-info option comp_err, comp_err — Compile MySQL Error Message File mysql, mysql Options debugging support, Typical configure Options DEC data type, Overview of Numeric Types decimal arithmetic, Precision Math DECIMAL data type, Overview of Numeric Types , Precision Math decimal point, Data Types DECLARE, DECLARE Statement Syntax DECODE(), Encryption and Compression Functions decode_bits myisamchk variable, myisamchk General Options DEFAULT constraint, Constraints on Invalid Data default privileges, Securing the Initial MySQL Accounts default hostname, Connecting to the MySQL Server default installation location, Installation Layouts default options, Using Option Files DEFAULT value clause, Data Type Default Values , CREATE TABLE Syntax default values, MySQL Design Limitations and Tradeoffs , Data Type Default Values , CREATE TABLE Syntax , INSERT Syntax BLOB and TEXT columns, The BLOB and TEXT Types explicit, Data Type Default Values implicit, Data Type Default Values suppression, Constraints on Invalid Data DEFAULT(), Miscellaneous Functions default-character-set option mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information default-collation option mysqld, Command Options default-mysqld-path option mysqlmanager, MySQL Instance Manager Command Options default-storage-engine option mysqld, Command Options default-table-type option mysqld, Command Options default-time-zone option mysqld, Command Options defaults-extra-file option, Using Option Files mysqld_safe, mysqld_safe — MySQL Server Startup Script my_print_defaults, my_print_defaults — Display Options from Option Files defaults-file option, Using Option Files mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqlmanager, MySQL Instance Manager Command Options my_print_defaults, my_print_defaults — Display Options from Option Files defaults-group-suffix option, Using Option Files my_print_defaults, my_print_defaults — Display Options from Option Files DEGREES(), Mathematical Functions delay-key-write option mysqld, Command Options , MyISAM Startup Options DELAYED, INSERT DELAYED Syntax delayed-insert option mysqldump, mysqldump — A Database Backup Program delayed_insert_limit, INSERT DELAYED Syntax DELETE, DELETE Syntax and MySQL Cluster, Limits and Differences from Standard MySQL Limits delete option mysqlimport, mysqlimport — A Data Import Program delete-master-logs option mysqldump, mysqldump — A Database Backup Program deleting database, DROP DATABASE Syntax foreign key, ALTER TABLE Syntax , FOREIGN KEY Constraints function, DROP FUNCTION Syntax index, ALTER TABLE Syntax , DROP INDEX Syntax primary key, ALTER TABLE Syntax rows, Deleting Rows from Related Tables schema, DROP DATABASE Syntax table, DROP TABLE Syntax user, Removing User Accounts from MySQL , DROP USER Syntax users, Removing User Accounts from MySQL , DROP USER Syntax deletion mysql.sock, How to Protect or Change the MySQL Unix Socket File delimiter option mysql, mysql Options ndb_select_all, ndb_select_all — Print Rows from NDB Table Delphi, Using Connector/ODBC with Delphi derived tables, Subqueries in the FROM clause des-key-file option mysqld, Command Options DESC, DESCRIBE Syntax descending option ndb_select_all, ndb_select_all — Print Rows from NDB Table DESCRIBE, Getting Information About Databases and Tables , DESCRIBE Syntax description option myisamchk, Other myisamchk Options design choices, Design Choices issues, Known Issues in MySQL limitations, MySQL Design Limitations and Tradeoffs DES_DECRYPT(), Encryption and Compression Functions DES_ENCRYPT(), Encryption and Compression Functions developers list of, Credits development source tree, Installing from the Development Source Tree Difference(), Spatial Operators digits, Data Types Dimension(), General Geometry Functions directory structure default, Installation Layouts disable-grant-options option configure, Typical configure Options disable-keys option mysqldump, mysqldump — A Database Backup Program disable-log-bin option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files DISCARD TABLESPACE, ALTER TABLE Syntax , Using Per-Table Tablespaces disconnect-slave-event-count option mysqld, Command Options disconnecting from the server, Connecting to and Disconnecting from the Server Disjoint(), Functions That Test Spatial Relationships Between Geometries disk full, How MySQL Handles a Full Disk disk issues, Disk Issues Diskless, Defining Data Nodes disks splitting data across, Using Symbolic Links for Databases on Windows display size, Data Types display triggers, SHOW TRIGGERS Syntax display width, Data Types displaying information Cardinality, SHOW INDEX Syntax Collation, SHOW INDEX Syntax SHOW, SHOW Syntax , SHOW COLUMNS Syntax , SHOW INDEX Syntax , SHOW OPEN TABLES Syntax , SHOW TABLES Syntax table status, SHOW TABLE STATUS Syntax Distance(), Functions That Test Spatial Relationships Between Geometries DISTINCT, Selecting Particular Columns , DISTINCT Optimization , SELECT Syntax AVG(), GROUP BY (Aggregate) Functions COUNT(), GROUP BY (Aggregate) Functions MAX(), GROUP BY (Aggregate) Functions MIN(), GROUP BY (Aggregate) Functions SUM(), GROUP BY (Aggregate) Functions DISTINCTROW, SELECT Syntax DIV, Arithmetic Operators division (/), Arithmetic Operators DNS, How MySQL Uses DNS DO, DO Syntax DocBook XML documentation source format, About This Manual Documentation in Chinese, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets in Japanese, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets in Korean, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Documenters list of, Documenters and translators DOUBLE data type, Overview of Numeric Types DOUBLE PRECISION data type, Overview of Numeric Types double quote (\"), Strings downgrades MySQL Cluster, Upgrading and Downgrading MySQL Cluster , Performing a Rolling Restart of the Cluster , Cluster Upgrade and Downgrade Compatibility downgrading, Downgrading MySQL downloading, How to Get MySQL drbd FAQ, MySQL 5.0 FAQ — MySQL, DRBD, and Heartbeat DRBD, Distributed Replicated Block Device DRBD licence, Distributed Replicated Block Device DROP DATABASE, DROP DATABASE Syntax DROP FOREIGN KEY, ALTER TABLE Syntax , FOREIGN KEY Constraints DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION
Syntax , DROP FUNCTION Syntax DROP INDEX, ALTER TABLE Syntax , DROP INDEX Syntax DROP PREPARE, SQL Syntax for Prepared Statements DROP PRIMARY KEY, ALTER TABLE Syntax DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION
Syntax DROP SCHEMA, DROP DATABASE Syntax DROP TABLE, DROP TABLE Syntax and MySQL Cluster, Limits and Differences from Standard MySQL Limits DROP TRIGGER, DROP TRIGGER Syntax DROP USER, DROP USER Syntax DROP VIEW, DROP VIEW Syntax dropping user, Removing User Accounts from MySQL , DROP USER Syntax dryrun option mysqlhotcopy, mysqlhotcopy — A Database Backup Program DUAL, SELECT Syntax dump option myisam_ftdump, myisam_ftdump — Display Full-Text Index information DUMPFILE, SELECT Syntax dynamic table characteristics, Dynamic Table Characteristics E Eiffel Wrapper, MySQL Eiffel Wrapper ELT(), String Functions email lists, MySQL Mailing Lists embedded MySQL server library, libmysqld, the Embedded MySQL Server Library embedded option make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive enable-named-pipe option mysqld, Command Options enable-pstack option mysqld, Command Options enable-thread-safe-client option configure, Typical configure Options ENCODE(), Encryption and Compression Functions ENCRYPT(), Encryption and Compression Functions encryption, Basic SSL Concepts encryption functions, Encryption and Compression Functions END, BEGIN ... END Compound Statement Syntax EndPoint(), LineString Functions enhancements MySQL Community Server, MySQL Community Server Enhancements and Release Notes Enhancements MySQL Community Server, MySQL Community Server 5.0 Enhancements and Release Notes ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client entering queries, Entering Queries ENUM size, Data Type Storage Requirements ENUM data type, Overview of String Types , The ENUM Type Envelope(), General Geometry Functions environment variable CC, Typical configure Options , Dealing with Problems Compiling MySQL CFLAGS, Typical configure Options , Dealing with Problems Compiling MySQL CXX, Typical configure Options , Dealing with Problems Compiling MySQL CXXFLAGS, Typical configure Options , Dealing with Problems Compiling MySQL HOME, mysql Options LD_RUN_PATH, Linux Source Distribution Notes , Solaris Notes MYSQL_DEBUG, Overview of Client and Utility Programs MYSQL_HISTFILE, mysql Options MYSQL_HOST, Connecting to the MySQL Server MYSQL_PWD, Connecting to the MySQL Server , Overview of Client and Utility Programs MYSQL_TCP_PORT, Running Multiple Servers on Unix , Using Client Programs in a Multiple-Server Environment , Overview of Client and Utility Programs MYSQL_UNIX_PORT, Running Multiple Servers on Unix , Using Client Programs in a Multiple-Server Environment , Overview of Client and Utility Programs PATH, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems , Invoking MySQL Programs USER, Connecting to the MySQL Server Environment variable CC, Environment Variables CFLAGS, Environment Variables CXX, Dealing with Problems Compiling MySQL , Environment Variables CXXFLAGS, Environment Variables DBI_TRACE, Environment Variables DBI_USER, Environment Variables HOME, Environment Variables LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD
Interface LD_RUN_PATH, Environment Variables , Problems Using the Perl DBI/DBD
Interface MYSQL_DEBUG, Environment Variables MYSQL_GROUP_SUFFIX, Environment Variables MYSQL_HISTFILE, Environment Variables MYSQL_HOME, Environment Variables MYSQL_HOST, Environment Variables MYSQL_PS1, Environment Variables MYSQL_PWD, Environment Variables MYSQL_TCP_PORT, Environment Variables MYSQL_UNIX_PORT, Problems Running mysql_install_db , Environment Variables PATH, Environment Variables TMPDIR, Problems Running mysql_install_db , Environment Variables TZ, Environment Variables , Time Zone Problems UMASK, Environment Variables , Problems with File Permissions UMASK_DIR, Environment Variables , Problems with File Permissions USER, Environment Variables Environment variables CXX, Dealing with Problems Compiling MySQL environment variables, Using Environment Variables to Specify Options , Causes of Access denied Errors , Overview of Client and Utility Programs list of, Environment Variables equal (=), Comparison Functions and Operators Equals(), Functions That Test Spatial Relationships Between Geometries ERROR Events (MySQL Cluster), Log Events error logs (MySQL Cluster), ndbd — The Storage Engine Node Process error messages can't find file, Problems with File Permissions languages, Setting the Error Message Language errors access denied, Access denied checking tables for, How to Check MyISAM Tables for Errors common, Problems and Common Errors directory checksum, Solaris Notes handling for UDFs, UDF Return Values and Error Handling in subqueries, Subquery Errors known, Known Issues in MySQL linking, Problems Linking to the MySQL Client Library list of, Common Errors When Using MySQL Programs reporting, General Information , How to Report Bugs or Problems ERROR_FOR_DIVISION_BY_ZERO SQL mode, SQL Modes escape (\\), Strings escape characters, Literal Values estimating query performance, Estimating Query Performance event log format (MySQL Cluster), Log Events event logs (MySQL Cluster), Event Reports Generated in MySQL Cluster , Logging Management Commands event severity levels (MySQL Cluster), Logging Management Commands event types (MySQL Cluster), Event Reports Generated in MySQL Cluster , Log Events exact-value literals, Precision Math example option mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers EXAMPLE storage engine, Storage Engines , The EXAMPLE Storage Engine examples compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables myisamchk output, Getting Information About a Table queries, Examples of Common Queries exe-suffix option make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive EXECUTE, SQL Syntax for Prepared Statements execute option mysql, mysql Options EXECUTE statement, SQL Syntax for Prepared Statements ExecuteOnComputer, Defining the Management Server , Defining Data Nodes , Defining SQL and Other API Nodes executing SQL statements from text files, Using mysql in Batch Mode , Executing SQL Statements from a Text File EXISTS with subqueries, EXISTS and NOT EXISTS EXIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client exit-info option mysqld, Command Options EXP(), Mathematical Functions EXPLAIN, Optimizing Queries with EXPLAIN explicit default values, Data Type Default Values EXPORT_SET(), String Functions expression aliases, GROUP BY and HAVING with Hidden
Fields , SELECT Syntax expressions extended, Pattern Matching extend-check option myisamchk, myisamchk Check Options , myisamchk Repair Options extended option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program extended-insert option mysqldump, mysqldump — A Database Backup Program extensions to standard SQL, MySQL Standards Compliance ExteriorRing(), Polygon Functions external locking, Command Options , System Variables , Using myisamchk for Crash Recovery , External Locking , SHOW PROCESSLIST Syntax external-locking option mysqld, Command Options extra-file option my_print_defaults, my_print_defaults — Display Options from Option Files extra-partition-info option ndb_desc, ndb_desc — Describe NDB Tables EXTRACT(), Date and Time Functions extracting dates, Date Calculations F FALSE, Numbers , Boolean Values testing for, Comparison Functions and Operators fast option myisamchk, myisamchk Check Options mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program fatal signal 11, Dealing with Problems Compiling MySQL features of MySQL, The Main Features of MySQL FEDERATED storage engine, Storage Engines , The FEDERATED Storage Engine FETCH, Cursor FETCH Statement field changing, ALTER TABLE Syntax FIELD(), String Functions fields option ndb_config, ndb_config — Extract NDB Configuration Information fields-enclosed-by option mysqldump, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program fields-escaped-by option mysqldump, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program fields-optionally-enclosed-by option mysqldump, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program fields-terminated-by option mysqldump, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program FILE, String Functions files binary log, The Binary Log config.cache, Dealing with Problems Compiling MySQL error messages, Setting the Error Message Language general query log, The General Query Log log, Typical configure Options , Server Log Maintenance my.cnf, Replication Features and Known Problems not found message, Problems with File Permissions permissions, Problems with File Permissions repairing, myisamchk Repair Options script, Using mysql in Batch Mode size limits, The table is full slow query log, The Slow Query Log text, Executing SQL Statements from a Text File tmp, Problems Running mysql_install_db update log (obsolete), The Binary Log filesort optimization, ORDER BY Optimization FileSystemPath, Defining Data Nodes FIND_IN_SET(), String Functions first-slave option mysqldump, mysqldump — A Database Backup Program FIXED data type, Overview of Numeric Types fixed-point arithmetic, Precision Math FLOAT data type, Overview of Numeric Types floating-point number, Overview of Numeric Types floats, Numbers FLOOR(), Mathematical Functions FLUSH, FLUSH Syntax flush option mysqld, Command Options flush tables, mysqladmin — Client for Administering a MySQL Server flush-logs option mysqldump, mysqldump — A Database Backup Program flush-privileges option mysqldump, mysqldump — A Database Backup Program flushlog option mysqlhotcopy, mysqlhotcopy — A Database Backup Program FOR UPDATE, SELECT Syntax FORCE INDEX, Index Hint Syntax , Optimizer-Related Issues FORCE KEY, Index Hint Syntax force option myisamchk, myisamchk Check Options , myisamchk Repair Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade force-read option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files foreign key constraint, PRIMARY KEY and UNIQUE Index
Constraints deleting, ALTER TABLE Syntax , FOREIGN KEY Constraints foreign keys, Foreign Keys , Using Foreign Keys , ALTER TABLE Syntax FORMAT(), String Functions Forums, MySQL Community Support at the MySQL Forums FOUND_ROWS(), Information Functions FreeBSD troubleshooting, Dealing with Problems Compiling MySQL frequently-asked questions about DRBD, MySQL 5.0 FAQ — MySQL, DRBD, and Heartbeat frequently-asked questions about MySQL Cluster, MySQL 5.0 FAQ — MySQL Cluster FROM, SELECT Syntax FROM_DAYS(), Date and Time Functions FROM_UNIXTIME(), Date and Time Functions ft_max_word_len myisamchk variable, myisamchk General Options ft_min_word_len myisamchk variable, myisamchk General Options ft_stopword_file myisamchk
variable, myisamchk General Options full disk, How MySQL Handles a Full Disk full-text search, Full-Text Search Functions FULLTEXT, Full-Text Search Functions fulltext stopword list, Fine-Tuning MySQL Full-Text Search function creating, CREATE FUNCTION Syntax deleting, DROP FUNCTION Syntax function names parsing, Function Name Parsing and Resolution resolving ambiguity, Function Name Parsing and Resolution functions, Functions and Operators arithmetic, Bit Functions bit, Bit Functions C API, C API Function Overview C Prepared statement API, C API Prepared Statement Function Overview cast, Cast Functions and Operators control flow, Control Flow Functions date and time, Date and Time Functions encryption, Encryption and Compression Functions GROUP BY, GROUP BY (Aggregate) Functions grouping, Operator Precedence information, Information Functions mathematical, Mathematical Functions miscellaneous, Miscellaneous Functions native adding, Adding a New Native Function new, Adding New Functions to MySQL string, String Functions string comparison, String Comparison Functions user-defined, Adding New Functions to MySQL adding, Adding a New User-Defined Function Functions user-defined, CREATE FUNCTION Syntax , DROP FUNCTION Syntax functions for SELECT and WHERE
clauses, Functions and Operators Future development of MySQL Cluster, MySQL Cluster Development Roadmap G gap lock, InnoDB Startup Options and System Variables , InnoDB and TRANSACTION ISOLATION
LEVEL , Next-Key Locking: Avoiding the Phantom Problem gb2312, gbk, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets gcc, Typical configure Options gci option ndb_select_all, ndb_select_all — Print Rows from NDB Table gdb option mysqld, Command Options general information, General Information General Public License, What is MySQL? general query log, The General Query Log geographic feature, Introduction to MySQL Spatial Support GeomCollFromText(), Creating Geometry Values Using WKT Functions GeomCollFromWKB(), Creating Geometry Values Using WKB Functions geometry, Introduction to MySQL Spatial Support GEOMETRY data type, MySQL Spatial Data Types GEOMETRYCOLLECTION data type, MySQL Spatial Data Types GeometryCollection(), Creating Geometry Values Using MySQL-Specific Functions GeometryCollectionFromText(), Creating Geometry Values Using WKT Functions GeometryCollectionFromWKB(), Creating Geometry Values Using WKB Functions GeometryFromText(), Creating Geometry Values Using WKT Functions GeometryFromWKB(), Creating Geometry Values Using WKB Functions GeometryN(), GeometryCollection Functions GeometryType(), General Geometry Functions GeomFromText(), Creating Geometry Values Using WKT Functions , Geometry Format Conversion Functions GeomFromWKB(), Creating Geometry Values Using WKB Functions , Geometry Format Conversion Functions geospatial feature, Introduction to MySQL Spatial Support getting MySQL, How to Get MySQL GET_FORMAT(), Date and Time Functions GET_LOCK(), Miscellaneous Functions GIS, Spatial Extensions , Introduction to MySQL Spatial Support GLength(), LineString Functions , MultiLineString Functions global privileges, GRANT Syntax , REVOKE Syntax goals of MySQL, What is MySQL? GRANT, GRANT Syntax GRANT statement, Adding New User Accounts to MySQL grant tables, Access Control, Stage 2: Request Verification re-creating, Problems Running mysql_install_db sorting, Access Control, Stage 1: Connection Verification , Access Control, Stage 2: Request Verification granting privileges, GRANT Syntax GRANTS, SHOW GRANTS Syntax greater than (>), Comparison Functions and Operators greater than or equal (>=), Comparison Functions and Operators GREATEST(), Comparison Functions and Operators GROUP BY, GROUP BY Optimization aliases in, GROUP BY and HAVING with Hidden
Fields extensions to standard SQL, GROUP BY and HAVING with Hidden
Fields , SELECT Syntax GROUP BY functions, GROUP BY (Aggregate) Functions grouping expressions, Operator Precedence GROUP_CONCAT(), GROUP BY (Aggregate) Functions H HANDLER, HANDLER Syntax Handlers, DECLARE Handlers handling errors, UDF Return Values and Error Handling HAVING, SELECT Syntax header option ndb_select_all, ndb_select_all — Print Rows from NDB Table header_file option comp_err, comp_err — Compile MySQL Error Message File HEAP storage engine, Storage Engines , The MEMORY (HEAP) Storage Engine HeartbeatIntervalDbApi (MySQL Cluster configuration
parameter), Defining Data Nodes HeartbeatIntervalDbDb (MySQL Cluster configuration
parameter), Defining Data Nodes HELP command (MySQL Cluster), Commands in the MySQL Cluster Management Client help option comp_err, comp_err — Compile MySQL Error Message File myisamchk, myisamchk General Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables myisam_ftdump, myisam_ftdump — Display Full-Text Index information mysql, mysql Options mysqlaccess, mysqlaccess — Client for Checking Access Privileges mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlmanager, MySQL Instance Manager Command Options mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log mysql_find_rows, mysql_find_rows — Extract Queries from Update Log mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_tableinfo, mysql_tableinfo — Generate Database Metadata mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination my_print_defaults, my_print_defaults — Display Options from Option Files perror, perror — Explain Error Codes resolveip, resolveip — Resolve Hostname to IP Address or Vice
Versa resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols HELP statement, HELP Syntax HEX(), String Functions hex-blob option mysqldump, mysqldump — A Database Backup Program hexadecimal values, Hexadecimal Values hexdump option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files HIGH_NOT_PRECEDENCE SQL mode, SQL Modes HIGH_PRIORITY, SELECT Syntax hints, MySQL Extensions to Standard SQL index, SELECT Syntax , Index Hint Syntax history of MySQL, History of MySQL HOME environment variable, Environment Variables , mysql Options host option mysql, mysql Options mysqlaccess, mysqlaccess — Client for Checking Access Privileges mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_tableinfo, mysql_tableinfo — Generate Database Metadata ndb_config, ndb_config — Extract NDB Configuration Information host table, Access Control, Stage 2: Request Verification sorting, Access Control, Stage 2: Request Verification Host*SciId* parameters, SCI Transport Connections host.frm problems finding, Unix Post-Installation Procedures hostname default, Connecting to the MySQL Server HostName, Defining the Management Server , Defining Data Nodes , Defining SQL and Other API Nodes hostname caching, How MySQL Uses DNS HOUR(), Date and Time Functions howto option mysqlaccess, mysqlaccess — Client for Checking Access Privileges html option mysql, mysql Options I i-am-a-dummy option mysql, mysql Options Id, Defining the Management Server , Defining Data Nodes , Defining SQL and Other API Nodes ID unique, How to Get the Unique ID for the Last Inserted Row id option ndb_config, ndb_config — Extract NDB Configuration Information identifiers, Database, Table, Index, Column, and Alias Names case sensitivity, Identifier Case Sensitivity quoting, Database, Table, Index, Column, and Alias Names idx option mysql_tableinfo, mysql_tableinfo — Generate Database Metadata IF, IF Statement IF(), Control Flow Functions IFNULL(), Control Flow Functions IGNORE INDEX, Index Hint Syntax IGNORE KEY, Index Hint Syntax ignore option mysqlimport, mysqlimport — A Data Import Program ignore-lines option mysqlimport, mysqlimport — A Data Import Program ignore-spaces option mysql, mysql Options ignore-table option mysqldump, mysqldump — A Database Backup Program IGNORE_SPACE SQL mode, SQL Modes implicit default values, Data Type Default Values IMPORT TABLESPACE, ALTER TABLE Syntax , Using Per-Table Tablespaces importing data, Executing SQL Statements from a Text File IN, Comparison Functions and Operators , Subqueries with ANY, IN, and
SOME increasing performance, Replication FAQ increasing with replication speed, Replication index deleting, ALTER TABLE Syntax , DROP INDEX Syntax index hints, SELECT Syntax , Index Hint Syntax indexes, CREATE INDEX Syntax and BLOB columns, Column Indexes , CREATE TABLE Syntax and IS NULL, How MySQL Uses Indexes and LIKE, How MySQL Uses Indexes and NULL values, CREATE TABLE Syntax and TEXT columns, Column Indexes , CREATE TABLE Syntax assigning to key cache, CACHE INDEX Syntax block size, System Variables columns, Column Indexes leftmost prefix of, How MySQL Uses Indexes multi-column, Multiple-Column Indexes multiple-part, CREATE INDEX Syntax names, Database, Table, Index, Column, and Alias Names use of, How MySQL Uses Indexes IndexMemory, Defining Data Nodes , Configuring Parameters for Local Checkpoints INET_ATON(), Miscellaneous Functions INET_NTOA(), Miscellaneous Functions INFO Events (MySQL Cluster), Log Events information functions, Information Functions information option myisamchk, myisamchk Check Options INFORMATION_SCHEMA, The INFORMATION_SCHEMA Database init-file option mysqld, Command Options INNER JOIN, JOIN Syntax innochecksum, Overview of Client and Utility Programs InnoDB, InnoDB Overview NFS, InnoDB Configuration , Restrictions on InnoDB Tables Solaris 10 x86_64 issues, Solaris Notes innodb option mysqld, InnoDB Startup Options and System Variables InnoDB storage engine, Storage Engines , The InnoDB Storage Engine InnoDB tables, Transactions and Atomic Operations innodb-safe-binlog option mysqld, Command Options innodb_status_file option mysqld, InnoDB Startup Options and System Variables INSERT, Speed of INSERT Statements , INSERT Syntax INSERT ... SELECT, INSERT ... SELECT Syntax INSERT DELAYED, INSERT DELAYED Syntax INSERT statement grant privileges, Adding New User Accounts to MySQL INSERT(), String Functions insert-ignore option mysqldump, mysqldump — A Database Backup Program inserting speed of, Speed of INSERT Statements inserts concurrent, Internal Locking Methods , Concurrent Inserts install option mysqlmanager, MySQL Instance Manager Command Options installation layouts, Installation Layouts installation overview, MySQL Installation Using a Source Distribution installing binary distribution, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems Linux RPM packages, Installing MySQL from RPM Packages on Linux Mac OS X PKG packages, Installing MySQL on Mac OS X MySQL Community Server, Installing MySQL Community Server MySQL Enterprise, Installing MySQL Enterprise overview, Installing and Upgrading MySQL , MySQL Installation Overview Perl, Perl Installation Notes Perl on Windows, Installing ActiveState Perl on Windows Solaris PKG packages, Installing MySQL on Solaris source distribution, MySQL Installation Using a Source Distribution user-defined functions, Compiling and Installing User-Defined Functions installing MySQL Cluster, Simple Multi-Computer How-To , Multi-Computer Installation , Installing the Cluster Software INSTR(), String Functions INT data type, Overview of Numeric Types integer arithmetic, Precision Math INTEGER data type, Overview of Numeric Types integers, Numbers InteriorRingN(), Polygon Functions internal compiler errors, Dealing with Problems Compiling MySQL internal locking, Internal Locking Methods internals, MySQL Internals Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC) Intersection(), Spatial Operators Intersects(), Functions That Test Spatial Relationships Between Geometries INTERVAL(), Comparison Functions and Operators introducer string literal, Strings , Character String Literal Character Set and Collation invalid data constraint, Constraints on Invalid Data in_file option comp_err, comp_err — Compile MySQL Error Message File IRC, MySQL Community Support on Internet Relay Chat (IRC) IS boolean_value, Comparison Functions and Operators IS NOT boolean_value, Comparison Functions and Operators IS NOT NULL, Comparison Functions and Operators IS NULL, IS NULL Optimization , Comparison Functions and Operators and indexes, How MySQL Uses Indexes isamchk, Overview of Client and Utility Programs isamlog, Overview of Client and Utility Programs IsClosed(), MultiLineString Functions IsEmpty(), General Geometry Functions ISNULL(), Comparison Functions and Operators ISOLATION LEVEL, SET TRANSACTION Syntax IsRing(), LineString Functions IsSimple(), General Geometry Functions IS_FREE_LOCK(), Miscellaneous Functions IS_USED_LOCK(), Miscellaneous Functions ITERATE, ITERATE Statement J Japanese character sets conversion, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Japanese, Korean, Chinese character sets frequently asked questions, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets JOIN, JOIN Syntax join option myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables K keepold option mysqlhotcopy, mysqlhotcopy — A Database Backup Program Key cache MyISAM, The MyISAM Key Cache key cache assigning indexes to, CACHE INDEX Syntax key space MyISAM, Space Needed for Keys keys, Column Indexes foreign, Foreign Keys , Using Foreign Keys multi-column, Multiple-Column Indexes searching on two, Searching on Two Keys keys option mysqlshow, mysqlshow — Display Database, Table, and Column Information keys-used option myisamchk, myisamchk Repair Options keywords, Reserved Words key_buffer_size myisamchk variable, myisamchk General Options KEY_COLUMN_USAGE INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table KILL, KILL Syntax known errors, Known Issues in MySQL Korean, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Korean, Chinese, Japanese character sets frequently asked questions, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets L language option mysqld, Command Options language support error messages, Setting the Error Message Language large-pages option mysqld, Command Options last row unique ID, How to Get the Unique ID for the Last Inserted Row LAST_DAY(), Date and Time Functions LAST_INSERT_ID(), Transactions and Atomic Operations , INSERT Syntax LAST_INSERT_ID() and stored routines, Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID() LAST_INSERT_ID() and triggers, Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID() LAST_INSERT_ID([expr]), Information Functions layout of installation, Installation Layouts LCASE(), String Functions LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD
Interface LD_RUN_PATH environment variable, Linux Source Distribution Notes , Solaris Notes , Environment Variables , Problems Using the Perl DBI/DBD
Interface LEAST(), Comparison Functions and Operators LEAVE, LEAVE Statement ledir option mysqld_safe, mysqld_safe — MySQL Server Startup Script LEFT JOIN, LEFT JOIN and RIGHT JOIN
Optimization , JOIN Syntax LEFT OUTER JOIN, JOIN Syntax LEFT(), String Functions leftmost prefix of indexes, How MySQL Uses Indexes legal names, Database, Table, Index, Column, and Alias Names length option myisam_ftdump, myisam_ftdump — Display Full-Text Index information LENGTH(), String Functions less than (<), Comparison Functions and Operators less than or equal (<=), Comparison Functions and Operators libmysqld, libmysqld, the Embedded MySQL Server Library libraries list of, Libraries used by and included with MySQL library mysqlclient, APIs and Libraries mysqld, APIs and Libraries LIKE, String Comparison Functions and indexes, How MySQL Uses Indexes and wildcards, How MySQL Uses Indexes LIMIT, LIMIT Optimization , Information Functions , SELECT Syntax limitations design, MySQL Design Limitations and Tradeoffs MySQL Limitations, Limits in MySQL replication, Replication Features and Known Problems limitations of MySQL Cluster, Known Limitations of MySQL Cluster limits file-size, The table is full MySQL Limits, limits in MySQL, Limits in MySQL line-numbers option mysql, mysql Options linefeed (\n), Strings LineFromText(), Creating Geometry Values Using WKT Functions LineFromWKB(), Creating Geometry Values Using WKB Functions lines-terminated-by option mysqldump, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program LINESTRING data type, MySQL Spatial Data Types LineString(), Creating Geometry Values Using MySQL-Specific Functions LineStringFromText(), Creating Geometry Values Using WKT Functions LineStringFromWKB(), Creating Geometry Values Using WKB Functions linking, Building Client Programs errors, Problems Linking to the MySQL Client Library problems, Problems Linking with the C API speed, How Compiling and Linking Affects the Speed of MySQL links symbolic, Using Symbolic Links Linux binary distribution, Linux Binary Distribution Notes source distribution, Linux Source Distribution Notes literals, Literal Values LN(), Mathematical Functions LOAD DATA FROM MASTER, LOAD DATA FROM MASTER Syntax LOAD DATA INFILE, LOAD DATA INFILE Syntax , Problems with NULL Values LOAD TABLE FROM MASTER, LOAD TABLE tbl_name FROM
MASTER Syntax loading tables, Loading Data into a Table LOAD_FILE(), String Functions local checkpoints (MySQL Cluster), Configuring Parameters for Local Checkpoints local option mysqlimport, mysqlimport — A Data Import Program local-infile option mysql, mysql Options mysqld, Security-Related mysqld Options local-load option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files localstatedir option configure, Typical configure Options LOCALTIME, Date and Time Functions LOCALTIMESTAMP, Date and Time Functions LOCATE(), String Functions LOCK IN SHARE MODE, SELECT Syntax lock option ndb_select_all, ndb_select_all — Print Rows from NDB Table LOCK TABLES, LOCK TABLES and UNLOCK TABLES
Syntax lock-all-tables option mysqldump, mysqldump — A Database Backup Program lock-tables option mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program locking, System Factors and Startup Parameter Tuning external, Command Options , System Variables , Using myisamchk for Crash Recovery , External Locking , SHOW PROCESSLIST Syntax internal, Internal Locking Methods page-level, Internal Locking Methods row-level, Transactions and Atomic Operations , Internal Locking Methods table-level, Internal Locking Methods locking methods, Internal Locking Methods LockPagesInMainMemory, Defining Data Nodes log changes, MySQL Change History log files, Typical configure Options , MySQL Server Logs maintaining, Server Log Maintenance names, Database Backups log files (MySQL Cluster), ndbd — The Storage Engine Node Process log option mysqld, Command Options mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqlmanager, MySQL Instance Manager Command Options LOG(), Mathematical Functions log-bin option mysqld, Command Options log-bin-index option mysqld, Command Options log-bin-trust-function-creators option mysqld, Command Options log-bin-trust-routine-creators option mysqld, Command Options log-error option mysqld, Command Options mysqld_safe, mysqld_safe — MySQL Server Startup Script log-isam option mysqld, Command Options log-long-format option mysqld, Command Options log-queries-not-using-indexes option mysqld, Command Options log-short-format option mysqld, Command Options log-slave-updates option mysqld, Replication Startup Options log-slow-admin-statements option mysqld, Command Options log-slow-queries option mysqld, Command Options log-tc option mysqld, Command Options log-tc-size option mysqld, Command Options log-warnings option mysqld, Command Options , Replication Startup Options LOG10(), Mathematical Functions LOG2(), Mathematical Functions LogDestination, Defining the Management Server logging commands (MySQL Cluster), Logging Management Commands logical operators, Logical Operators LogLevelCheckpoint (MySQL Cluster configuration
parameter), Defining Data Nodes LogLevelConnection (MySQL Cluster configuration
parameter), Defining Data Nodes LogLevelError, Defining Data Nodes LogLevelInfo, Defining Data Nodes LogLevelNodeRestart (MySQL Cluster configuration
parameter), Defining Data Nodes LogLevelShutdown (MySQL Cluster configuration
parameter), Defining Data Nodes LogLevelStartup (MySQL Cluster configuration
parameter), Defining Data Nodes LogLevelStatistic (MySQL Cluster configuration
parameter), Defining Data Nodes LONG data type, The BLOB and TEXT Types LONGBLOB data type, Overview of String Types LongMessageBuffer, Defining Data Nodes LONGTEXT data type, Overview of String Types LOOP, LOOP Statement loops option ndb_show_tables, ndb_show_tables — Display List of NDB Tables low-priority option mysqlimport, mysqlimport — A Data Import Program low-priority-updates option mysqld, Command Options LOWER(), String Functions LPAD(), String Functions LTRIM(), String Functions M Mac OS X, MySQL Connector/ODBC installation, Installing MySQL on Mac OS X mailing list address, General Information mailing lists, MySQL Mailing Lists archive location, MySQL Mailing Lists guidelines, Guidelines for Using the Mailing Lists main features of MySQL, The Main Features of MySQL maintaining log files, Server Log Maintenance tables, Setting Up a Table Maintenance Schedule MAKEDATE(), Date and Time Functions MAKETIME(), Date and Time Functions make_binary_distribution, Overview of Server-Side Programs MAKE_SET(), String Functions make_win_bin_dist, Overview of Server-Side Programs debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive exe-suffix option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive no-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive no-embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive only-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive make_win_src_distribution, Creating a Windows Source Package from the Latest Development Source , Overview of Server-Side Programs management node (MySQL Cluster) defined, Basic MySQL Cluster Concepts managing MySQL Cluster, Management of MySQL Cluster managing MySQL Cluster processes, Process Management in MySQL Cluster manual available formats, About This Manual online location, About This Manual typographical conventions, Conventions Used in This Manual master-connect-retry option mysqld, Replication Startup Options master-data option mysqldump, mysqldump — A Database Backup Program master-host option mysqld, Replication Startup Options master-info-file option mysqld, Replication Startup Options master-password option mysqld, Replication Startup Options master-port option mysqld, Replication Startup Options master-retry-count option mysqld, Replication Startup Options master-ssl option mysqld, Replication Startup Options master-ssl-ca option mysqld, Replication Startup Options master-ssl-capath option mysqld, Replication Startup Options master-ssl-cert option mysqld, Replication Startup Options master-ssl-cipher option mysqld, Replication Startup Options master-ssl-key option mysqld, Replication Startup Options master-user option mysqld, Replication Startup Options master/slave setup, Replication Implementation Overview MASTER_POS_WAIT(), Miscellaneous Functions , MASTER_POS_WAIT() Syntax MATCH ... AGAINST(), Full-Text Search Functions matching patterns, Pattern Matching math, Precision Math mathematical functions, Mathematical Functions MAX(), GROUP BY (Aggregate) Functions MAX(DISTINCT), GROUP BY (Aggregate) Functions max-binlog-dump-events option mysqld, Command Options max-record-length option myisamchk, myisamchk Repair Options max-relay-log-size option mysqld, Replication Startup Options MAXDB SQL mode, SQL Modes maximum memory used, mysqladmin — Client for Administering a MySQL Server maximums maximum tables per join, Limits of Joins MaxNoOfAttributes, Defining Data Nodes MaxNoOfConcurrentIndexOperations, Defining Data Nodes MaxNoOfConcurrentOperations, Defining Data Nodes MaxNoOfConcurrentScans, Defining Data Nodes MaxNoOfConcurrentTransactions, Defining Data Nodes MaxNoOfFiredTriggers, Defining Data Nodes MaxNoOfIndexes, Defining Data Nodes MaxNoOfLocalOperations, Defining Data Nodes MaxNoOfLocalScans, Defining Data Nodes MaxNoOfOpenFiles, Defining Data Nodes MaxNoOfOrderedIndexes, Defining Data Nodes MaxNoOfSavedMessages, Defining Data Nodes MaxNoOfTables, Defining Data Nodes MaxNoOfTriggers, Defining Data Nodes MaxNoOfUniqueHashIndexes, Defining Data Nodes MaxScanBatchSize, Defining SQL and Other API Nodes max_allowed_packet variable, mysql Options MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources max_join_size variable, mysql Options MAX_QUERIES_PER_HOUR, Limiting Account Resources MAX_UPDATES_PER_HOUR, Limiting Account Resources MAX_USER_CONNECTIONS, Limiting Account Resources MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs) MBRContains(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MBRDisjoint(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MBREqual(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MBRIntersects(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MBROverlaps(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MBRTouches(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MBRWithin(), Relations on Geometry Minimal Bounding Rectangles (MBRs) MD5(), Encryption and Compression Functions medium-check option myisamchk, myisamchk Check Options mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program MEDIUMBLOB data type, Overview of String Types MEDIUMINT data type, Overview of Numeric Types MEDIUMTEXT data type, Overview of String Types memlock option mysqld, Command Options MEMORY storage engine, Storage Engines , The MEMORY (HEAP) Storage Engine memory usage myisamchk, myisamchk Memory Usage memory use, How MySQL Uses Memory , mysqladmin — Client for Administering a MySQL Server in MySQL Cluster, Limits and Differences from Standard MySQL Limits MERGE storage engine, Storage Engines , The MERGE Storage Engine MERGE tables defined, The MERGE Storage Engine metadata database, The INFORMATION_SCHEMA Database method option mysqlhotcopy, mysqlhotcopy — A Database Backup Program methods locking, Internal Locking Methods mgmd (MySQL Cluster) defined, Basic MySQL Cluster Concepts MICROSECOND(), Date and Time Functions Microsoft Access, Microsoft Access Microsoft ADO, Microsoft ADO Microsoft Excel, Microsoft Excel and Column Types Microsoft Visual Basic, Microsoft Visual Basic Microsoft Visual InterDev, Microsoft Visual InterDev MID(), String Functions MIN(), GROUP BY (Aggregate) Functions MIN(DISTINCT), GROUP BY (Aggregate) Functions Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs) minus unary (-), Arithmetic Operators MINUTE(), Date and Time Functions mirror sites, How to Get MySQL miscellaneous functions, Miscellaneous Functions MIT-pthreads, MIT-pthreads Notes MLineFromText(), Creating Geometry Values Using WKT Functions MLineFromWKB(), Creating Geometry Values Using WKB Functions MOD (modulo), Mathematical Functions MOD(), Mathematical Functions modes batch, Using mysql in Batch Mode modulo (%), Mathematical Functions modulo (MOD), Mathematical Functions monitor terminal, Tutorial monitoring-interval option mysqlmanager, MySQL Instance Manager Command Options Mono, MySQL Connector/NET MONTH(), Date and Time Functions MONTHNAME(), Date and Time Functions MPointFromText(), Creating Geometry Values Using WKT Functions MPointFromWKB(), Creating Geometry Values Using WKB Functions MPolyFromText(), Creating Geometry Values Using WKT Functions MPolyFromWKB(), Creating Geometry Values Using WKB Functions mSQL compatibility, String Comparison Functions MSSQL SQL mode, SQL Modes multi-byte character sets, Can't initialize character set multi-byte characters, Multi-Byte Character Support multi-column indexes, Multiple-Column Indexes MULTILINESTRING data type, MySQL Spatial Data Types MultiLineString(), Creating Geometry Values Using MySQL-Specific Functions MultiLineStringFromText(), Creating Geometry Values Using WKT Functions MultiLineStringFromWKB(), Creating Geometry Values Using WKB Functions multiple servers, Running Multiple MySQL Servers on the Same Machine multiple-part index, CREATE INDEX Syntax multiplication (*), Arithmetic Operators MULTIPOINT data type, MySQL Spatial Data Types MultiPoint(), Creating Geometry Values Using MySQL-Specific Functions MultiPointFromText(), Creating Geometry Values Using WKT Functions MultiPointFromWKB(), Creating Geometry Values Using WKB Functions MULTIPOLYGON data type, MySQL Spatial Data Types MultiPolygon(), Creating Geometry Values Using MySQL-Specific Functions MultiPolygonFromText(), Creating Geometry Values Using WKT Functions MultiPolygonFromWKB(), Creating Geometry Values Using WKB Functions My derivation, History of MySQL my.cnf and MySQL Cluster, Multi-Computer Configuration , Configuration File , Basic Example Configuration in MySQL Cluster, MySQL Server Process Usage for MySQL Cluster my.cnf file, Replication Features and Known Problems MyISAM compressed tables, Compressed Table Characteristics size, Data Type Storage Requirements MyISAM key cache, The MyISAM Key Cache MyISAM storage engine, Storage Engines , The MyISAM Storage Engine myisam-recover option mysqld, Command Options , MyISAM Startup Options myisamchk, Typical configure Options , Overview of Client and Utility Programs analyze option, Other myisamchk Options backup option, myisamchk Repair Options block-search option, Other myisamchk Options character-sets-dir option, myisamchk Repair Options check option, myisamchk Check Options check-only-changed option, myisamchk Check Options correct-checksum option, myisamchk Repair Options data-file-length option, myisamchk Repair Options debug option, myisamchk General Options description option, Other myisamchk Options example output, Getting Information About a Table extend-check option, myisamchk Check Options , myisamchk Repair Options fast option, myisamchk Check Options force option, myisamchk Check Options , myisamchk Repair Options help option, myisamchk General Options information option, myisamchk Check Options keys-used option, myisamchk Repair Options max-record-length option, myisamchk Repair Options medium-check option, myisamchk Check Options no-symlinks option, myisamchk Repair Options options, myisamchk General Options parallel-recover option, myisamchk Repair Options quick option, myisamchk Repair Options read-only option, myisamchk Check Options recover option, myisamchk Repair Options safe-recover option, myisamchk Repair Options set-auto-increment[ option, Other myisamchk Options set-character-set option, myisamchk Repair Options set-collation option, myisamchk Repair Options silent option, myisamchk General Options sort-index option, Other myisamchk Options sort-records option, Other myisamchk Options sort-recover option, myisamchk Repair Options tmpdir option, myisamchk Repair Options unpack option, myisamchk Repair Options update-state option, myisamchk Check Options verbose option, myisamchk General Options version option, myisamchk General Options wait option, myisamchk General Options myisamlog, Overview of Client and Utility Programs myisampack, Overview of Client and Utility Programs , Silent Column Specification Changes , Compressed Table Characteristics backup option, myisampack — Generate Compressed, Read-Only MyISAM Tables character-sets-dir option, myisampack — Generate Compressed, Read-Only MyISAM Tables debug option, myisampack — Generate Compressed, Read-Only MyISAM Tables force option, myisampack — Generate Compressed, Read-Only MyISAM Tables help option, myisampack — Generate Compressed, Read-Only MyISAM Tables join option, myisampack — Generate Compressed, Read-Only MyISAM Tables silent option, myisampack — Generate Compressed, Read-Only MyISAM Tables test option, myisampack — Generate Compressed, Read-Only MyISAM Tables tmpdir option, myisampack — Generate Compressed, Read-Only MyISAM Tables verbose option, myisampack — Generate Compressed, Read-Only MyISAM Tables version option, myisampack — Generate Compressed, Read-Only MyISAM Tables wait option, myisampack — Generate Compressed, Read-Only MyISAM Tables myisam_block_size myisamchk
variable, myisamchk General Options myisam_ftdump, Overview of Client and Utility Programs count option, myisam_ftdump — Display Full-Text Index information dump option, myisam_ftdump — Display Full-Text Index information help option, myisam_ftdump — Display Full-Text Index information length option, myisam_ftdump — Display Full-Text Index information stats option, myisam_ftdump — Display Full-Text Index information verbose option, myisam_ftdump — Display Full-Text Index information MyODBC, MySQL Connector/ODBC MySQL defined, What is MySQL? introduction, What is MySQL? pronunciation, What is MySQL? mysql, Overview of Client and Utility Programs auto-rehash option, mysql Options batch option, mysql Options character-sets-dir option, mysql Options column-names option, mysql Options compress option, mysql Options database option, mysql Options debug option, mysql Options debug-info option, mysql Options default-character-set option, mysql Options delimiter option, mysql Options execute option, mysql Options force option, mysql Options help option, mysql Options host option, mysql Options html option, mysql Options i-am-a-dummy option, mysql Options ignore-spaces option, mysql Options line-numbers option, mysql Options local-infile option, mysql Options named-commands option, mysql Options no-auto-rehash option, mysql Options no-beep option, mysql Options no-named-commands option, mysql Options no-pager option, mysql Options no-tee option, mysql Options one-database option, mysql Options pager option, mysql Options password option, mysql Options port option, mysql Options prompt option, mysql Options protocol option, mysql Options quick option, mysql Options raw option, mysql Options reconnect option, mysql Options safe-updates option, mysql Options secure-auth option, mysql Options show-warnings option, mysql Options sigint-ignore option, mysql Options silent option, mysql Options skip-column-names option, mysql Options skip-line-numbers option, mysql Options socket option, mysql Options SSL options, mysql Options table option, mysql Options tee option, mysql Options unbuffered option, mysql Options user option, mysql Options verbose option, mysql Options version option, mysql Options vertical option, mysql Options wait option, mysql Options xml option, mysql Options MySQL AB defined, Overview of MySQL AB MySQL binary distribution, Choosing Which MySQL Distribution to Install MYSQL C type, C API Data types MySQL Cluster, MySQL Cluster administration, Command Options for MySQL Cluster Processes , MySQL Cluster-Related Command Options for mysqld , Command Options for ndbd , Command Options for ndb_mgmd , Command Options for ndb_mgm , Commands in the MySQL Cluster Management Client , Using CLUSTERLOG STATISTICS and DNS, Simple Multi-Computer How-To and IP addressing, Simple Multi-Computer How-To and networking, Hardware, Software, and Networking and transactions, MySQL 5.0 FAQ — MySQL Cluster API node, Basic MySQL Cluster Concepts , Defining SQL and Other API Nodes arbitrator, MySQL 5.0 FAQ — MySQL Cluster available platforms, MySQL Cluster backups, On-line Backup of MySQL Cluster , Cluster Backup Concepts , Using The Management Client to Create a Backup , Configuration for Cluster Backup , Backup Troubleshooting benchmarks, Understanding the Impact of Cluster Interconnects CHECKPOINT Events, Log Events cluster logs, Event Reports Generated in MySQL Cluster , Logging Management Commands CLUSTERLOG commands, Logging Management Commands CLUSTERLOG STATISTICS command, Using CLUSTERLOG STATISTICS commands, Command Options for MySQL Cluster Processes , MySQL Cluster-Related Command Options for mysqld , Command Options for ndbd , Command Options for ndb_mgmd , Command Options for ndb_mgm , Commands in the MySQL Cluster Management Client compiling from source, Building MySQL Cluster from Source Code concepts, Basic MySQL Cluster Concepts configuration, Simple Multi-Computer How-To , MySQL Cluster Configuration , Quick Test Setup of MySQL Cluster , Defining Cluster Computers , Defining the Management Server , Defining Data Nodes , Defining SQL and Other API Nodes , Configuring Parameters for Local Checkpoints , MySQL Server Process Usage for MySQL Cluster , ndb_mgmd — The Management Server Process configuration (example), Basic Example Configuration configuration changes, Performing a Rolling Restart of the Cluster configuration files, Multi-Computer Configuration , Configuration File configuration parameters, Overview of Cluster Configuration Parameters , Data Node Configuration Parameters , Management Node Configuration Parameters , SQL Node and API Node Configuration Parameters configuring, Configuration for Cluster Backup CONNECTION Events, Log Events connectstring, The Cluster Connectstring data node, Basic MySQL Cluster Concepts , Defining Data Nodes data types supported, MySQL 5.0 FAQ — MySQL Cluster defining node hosts, Defining Cluster Computers direct connections between nodes, TCP/IP Connections Using Direct Connections ENTER SINGLE USER MODE command, Commands in the MySQL Cluster Management Client ERROR Events, Log Events error logs, ndbd — The Storage Engine Node Process error messages, MySQL 5.0 FAQ — MySQL Cluster event log format, Log Events event logging thresholds, Logging Management Commands event logs, Event Reports Generated in MySQL Cluster , Logging Management Commands event severity levels, Logging Management Commands event types, Event Reports Generated in MySQL Cluster , Log Events EXIT command, Commands in the MySQL Cluster Management Client EXIT SINGLE USER MODE command, Commands in the MySQL Cluster Management Client FAQ, MySQL 5.0 FAQ — MySQL Cluster general description, MySQL Cluster Overview hardware requirements, MySQL 5.0 FAQ — MySQL Cluster HELP command, Commands in the MySQL Cluster Management Client how to obtain, MySQL 5.0 FAQ — MySQL Cluster importing existing tables, MySQL 5.0 FAQ — MySQL Cluster INFO Events, Log Events information sources, MySQL Cluster installation, Simple Multi-Computer How-To , Multi-Computer Installation , Installing the Cluster Software interconnects, Using High-Speed Interconnects with MySQL Cluster log files, ndbd — The Storage Engine Node Process logging commands, Logging Management Commands management commands, Using CLUSTERLOG STATISTICS management node, Basic MySQL Cluster Concepts , Defining the Management Server managing, Management of MySQL Cluster memory requirements, MySQL 5.0 FAQ — MySQL Cluster memory usage and recovery, Performing a Rolling Restart of the Cluster , Limits and Differences from Standard MySQL Limits mgm, Command Options for MySQL Cluster Processes mgm client, Commands in the MySQL Cluster Management Client mgm management client, Using CLUSTERLOG STATISTICS mgm process, Command Options for ndb_mgm mgmd, Command Options for MySQL Cluster Processes mgmd process, Command Options for ndb_mgmd mysqld process, MySQL Server Process Usage for MySQL Cluster , MySQL Cluster-Related Command Options for mysqld ndbd, Command Options for MySQL Cluster Processes ndbd process, Command Options for ndbd , Using CLUSTERLOG STATISTICS ndb_mgm, Initial Startup ndb_size.pl (utility), MySQL 5.0 FAQ — MySQL Cluster network configuration (SCI), Configuring MySQL Cluster to use SCI Sockets network transporters, Using High-Speed Interconnects with MySQL Cluster , Configuring MySQL Cluster to use SCI Sockets networking, TCP/IP Connections Using Direct Connections , Shared-Memory Connections , SCI Transport Connections networking requirements, MySQL 5.0 FAQ — MySQL Cluster node failure (single user mode), Single User Mode node identifiers, Shared-Memory Connections , SCI Transport Connections node logs, Event Reports Generated in MySQL Cluster node types, MySQL 5.0 FAQ — MySQL Cluster NODERESTART Events, Log Events nodes and node groups, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions nodes and types, Basic MySQL Cluster Concepts number of computers required, MySQL 5.0 FAQ — MySQL Cluster obtaining, Multi-Computer Installation partitions, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions performance, Understanding the Impact of Cluster Interconnects performing queries, Loading Sample Data and Performing Queries platforms supported, MySQL 5.0 FAQ — MySQL Cluster process management, Process Management in MySQL Cluster quick configuration, Quick Test Setup of MySQL Cluster QUIT command, Commands in the MySQL Cluster Management Client replicas, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions requirements, Hardware, Software, and Networking resetting, Performing a Rolling Restart of the Cluster RESTART command, Commands in the MySQL Cluster Management Client restarting, Safe Shutdown and Restart roles of computers, MySQL 5.0 FAQ — MySQL Cluster runtime statistics, Using CLUSTERLOG STATISTICS SCI (Scalable Coherent Interface), SCI Transport Connections , Configuring MySQL Cluster to use SCI Sockets SCI drivers, Configuring MySQL Cluster to use SCI Sockets SCI network configuration, Configuring MySQL Cluster to use SCI Sockets SCI software installation, Configuring MySQL Cluster to use SCI Sockets SCI software requirements, Configuring MySQL Cluster to use SCI Sockets SCI, performance vs TCP/IP, Understanding the Impact of Cluster Interconnects security, MySQL 5.0 FAQ — MySQL Cluster shared memory transport, Shared-Memory Connections SHOW command, Commands in the MySQL Cluster Management Client SHUTDOWN command, Commands in the MySQL Cluster Management Client shutting down, Safe Shutdown and Restart single user mode, Commands in the MySQL Cluster Management Client , Single User Mode SQL node, Basic MySQL Cluster Concepts , Defining SQL and Other API Nodes SQL nodes, MySQL Server Process Usage for MySQL Cluster SQL statements, MySQL 5.0 FAQ — MySQL Cluster SQL statements for monitoring, Quick Reference: MySQL Cluster SQL Statements START BACKUP command, Using The Management Client to Create a Backup START command, Commands in the MySQL Cluster Management Client starting and stopping, MySQL 5.0 FAQ — MySQL Cluster starting nodes, Initial Startup starting or restarting, MySQL Cluster Startup Phases starting with --initial, Quick Test Setup of MySQL Cluster STARTUP Events, Log Events STATISTICS Events, Log Events STATUS command, Commands in the MySQL Cluster Management Client STOP command, Commands in the MySQL Cluster Management Client storage requirements, Data Type Storage Requirements Table is full error, MySQL 5.0 FAQ — MySQL Cluster terminology, MySQL Cluster Glossary trace files, ndbd — The Storage Engine Node Process transaction handling, Limits Relating to Transaction Handling transactions, Defining Data Nodes transporters Scalable Coherent Interface (SCI), SCI Transport Connections shared memory (SHM), Shared-Memory Connections TCP/IP, TCP/IP Connections Using Direct Connections troubleshooting backups, Backup Troubleshooting upgrades and downgrades, Upgrading and Downgrading MySQL Cluster , Performing a Rolling Restart of the Cluster , Cluster Upgrade and Downgrade Compatibility using in a virtual machine, MySQL 5.0 FAQ — MySQL Cluster using tables and data, Loading Sample Data and Performing Queries vs replication, MySQL 5.0 FAQ — MySQL Cluster MySQL Cluster Glossary, MySQL Cluster Glossary MySQL Cluster How-To, Simple Multi-Computer How-To MySQL Cluster in MySQL 5.0 and 5.1, MySQL Cluster Development Roadmap MySQL Cluster limitations, Known Limitations of MySQL Cluster and differences from standard MySQL limits, Limits and Differences from Standard MySQL Limits binary logging, Issues Exclusive to MySQL Cluster database objects, Limits Associated with Database Objects error handling and reporting, Error Handling geometry data types, Non-Compliance In SQL Syntax implementation, Issues Exclusive to MySQL Cluster imposed by configuration, Limits and Differences from Standard MySQL Limits INSERT IGNORE, UPDATE IGNORE, and REPLACE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1 memory usage and transaction handling, Limits Relating to Transaction Handling multiple management servers, Limitations Relating to Multiple Cluster Nodes multiple MySQL servers, Limitations Relating to Multiple Cluster Nodes performance, Limitations Relating to Performance resolved in current version from previous versions, Previous MySQL Cluster Issues Resolved in MySQL 5.1 syntax, Non-Compliance In SQL Syntax transactions, Limits Relating to Transaction Handling unsupported features, Unsupported Or Missing Features MySQL Cluster processes (types), Process Management in MySQL Cluster MySQL Cluster utilities, Cluster Utility Programs mysql command options, mysql Options mysql commands list of, mysql Commands MySQL Community Server changes, MySQL Community Server Enhancements and Release Notes enhancements, MySQL Community Server Enhancements and Release Notes release notes, MySQL Community Server Enhancements and Release Notes MySQL Dolphin name, History of MySQL MySQL Enterprise changes, MySQL Enterprise Release Notes MySQL history, History of MySQL mysql history file, mysql Options MySQL mailing lists, MySQL Mailing Lists MySQL name, History of MySQL mysql prompt command, mysql Commands mysql source (command for reading from text files), Using mysql in Batch Mode , Executing SQL Statements from a Text File MySQL source distribution, Choosing Which MySQL Distribution to Install mysql status command, mysql Commands MySQL storage engines, Storage Engines MySQL version, How to Get MySQL mysql \. (command for reading from text files), Using mysql in Batch Mode , Executing SQL Statements from a Text File MySQL++, MySQL C++ API mysql.server, Overview of Server-Side Programs basedir option, mysql.server — MySQL Server Startup Script datadir option, mysql.server — MySQL Server Startup Script pid-file option, mysql.server — MySQL Server Startup Script service-startup-timeout option, mysql.server — MySQL Server Startup Script use-manager option, mysql.server — MySQL Server Startup Script use-mysqld_safe option, mysql.server — MySQL Server Startup Script user option, mysql.server — MySQL Server Startup Script mysql.sock changing location of, Typical configure Options protection, How to Protect or Change the MySQL Unix Socket File MYSQL323 SQL mode, SQL Modes MYSQL40 SQL mode, SQL Modes mysqlaccess, Overview of Client and Utility Programs brief option, mysqlaccess — Client for Checking Access Privileges commit option, mysqlaccess — Client for Checking Access Privileges copy option, mysqlaccess — Client for Checking Access Privileges db option, mysqlaccess — Client for Checking Access Privileges debug option, mysqlaccess — Client for Checking Access Privileges help option, mysqlaccess — Client for Checking Access Privileges host option, mysqlaccess — Client for Checking Access Privileges howto option, mysqlaccess — Client for Checking Access Privileges old_server option, mysqlaccess — Client for Checking Access Privileges password option, mysqlaccess — Client for Checking Access Privileges plan option, mysqlaccess — Client for Checking Access Privileges preview option, mysqlaccess — Client for Checking Access Privileges relnotes option, mysqlaccess — Client for Checking Access Privileges rhost option, mysqlaccess — Client for Checking Access Privileges rollback option, mysqlaccess — Client for Checking Access Privileges spassword option, mysqlaccess — Client for Checking Access Privileges superuser option, mysqlaccess — Client for Checking Access Privileges table option, mysqlaccess — Client for Checking Access Privileges user option, mysqlaccess — Client for Checking Access Privileges version option, mysqlaccess — Client for Checking Access Privileges mysqladmin, Overview of Client and Utility Programs , CREATE DATABASE Syntax , DROP DATABASE Syntax , SHOW STATUS Syntax , SHOW VARIABLES Syntax , FLUSH Syntax , KILL Syntax character-sets-dir option, mysqladmin — Client for Administering a MySQL Server compress option, mysqladmin — Client for Administering a MySQL Server count option, mysqladmin — Client for Administering a MySQL Server debug option, mysqladmin — Client for Administering a MySQL Server default-character-set option, mysqladmin — Client for Administering a MySQL Server force option, mysqladmin — Client for Administering a MySQL Server help option, mysqladmin — Client for Administering a MySQL Server host option, mysqladmin — Client for Administering a MySQL Server password option, mysqladmin — Client for Administering a MySQL Server port option, mysqladmin — Client for Administering a MySQL Server protocol option, mysqladmin — Client for Administering a MySQL Server relative option, mysqladmin — Client for Administering a MySQL Server silent option, mysqladmin — Client for Administering a MySQL Server sleep option, mysqladmin — Client for Administering a MySQL Server socket option, mysqladmin — Client for Administering a MySQL Server SSL options, mysqladmin — Client for Administering a MySQL Server user option, mysqladmin — Client for Administering a MySQL Server verbose option, mysqladmin — Client for Administering a MySQL Server version option, mysqladmin — Client for Administering a MySQL Server vertical option, mysqladmin — Client for Administering a MySQL Server wait option, mysqladmin — Client for Administering a MySQL Server mysqladmin command options, mysqladmin — Client for Administering a MySQL Server mysqladmin option mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqlbinlog, Overview of Client and Utility Programs character-sets-dir option, mysqlbinlog — Utility for Processing Binary Log Files database option, mysqlbinlog — Utility for Processing Binary Log Files debug option, mysqlbinlog — Utility for Processing Binary Log Files disable-log-bin option, mysqlbinlog — Utility for Processing Binary Log Files force-read option, mysqlbinlog — Utility for Processing Binary Log Files help option, mysqlbinlog — Utility for Processing Binary Log Files hexdump option, mysqlbinlog — Utility for Processing Binary Log Files host option, mysqlbinlog — Utility for Processing Binary Log Files local-load option, mysqlbinlog — Utility for Processing Binary Log Files offset option, mysqlbinlog — Utility for Processing Binary Log Files password option, mysqlbinlog — Utility for Processing Binary Log Files port option, mysqlbinlog — Utility for Processing Binary Log Files position option, mysqlbinlog — Utility for Processing Binary Log Files protocol option, mysqlbinlog — Utility for Processing Binary Log Files read-from-remote-server option, mysqlbinlog — Utility for Processing Binary Log Files result-file option, mysqlbinlog — Utility for Processing Binary Log Files set-charset option, mysqlbinlog — Utility for Processing Binary Log Files short-form option, mysqlbinlog — Utility for Processing Binary Log Files socket option, mysqlbinlog — Utility for Processing Binary Log Files start-datetime option, mysqlbinlog — Utility for Processing Binary Log Files start-position option, mysqlbinlog — Utility for Processing Binary Log Files stop-datetime option, mysqlbinlog — Utility for Processing Binary Log Files stop-position option, mysqlbinlog — Utility for Processing Binary Log Files to-last-log option, mysqlbinlog — Utility for Processing Binary Log Files user option, mysqlbinlog — Utility for Processing Binary Log Files version option, mysqlbinlog — Utility for Processing Binary Log Files mysqlbug script, How to Report Bugs or Problems mysqlcheck, Overview of Client and Utility Programs all-databases option, mysqlcheck — A Table Maintenance and Repair Program all-in-1 option, mysqlcheck — A Table Maintenance and Repair Program analyze option, mysqlcheck — A Table Maintenance and Repair Program auto-repair option, mysqlcheck — A Table Maintenance and Repair Program character-sets-dir option, mysqlcheck — A Table Maintenance and Repair Program check option, mysqlcheck — A Table Maintenance and Repair Program check-only-changed option, mysqlcheck — A Table Maintenance and Repair Program check-upgrade option, mysqlcheck — A Table Maintenance and Repair Program compress option, mysqlcheck — A Table Maintenance and Repair Program databases option, mysqlcheck — A Table Maintenance and Repair Program debug option, mysqlcheck — A Table Maintenance and Repair Program default-character-set option, mysqlcheck — A Table Maintenance and Repair Program extended option, mysqlcheck — A Table Maintenance and Repair Program fast option, mysqlcheck — A Table Maintenance and Repair Program force option, mysqlcheck — A Table Maintenance and Repair Program help option, mysqlcheck — A Table Maintenance and Repair Program host option, mysqlcheck — A Table Maintenance and Repair Program medium-check option, mysqlcheck — A Table Maintenance and Repair Program optimize option, mysqlcheck — A Table Maintenance and Repair Program password option, mysqlcheck — A Table Maintenance and Repair Program port option, mysqlcheck — A Table Maintenance and Repair Program protocol option, mysqlcheck — A Table Maintenance and Repair Program quick option, mysqlcheck — A Table Maintenance and Repair Program repair option, mysqlcheck — A Table Maintenance and Repair Program silent option, mysqlcheck — A Table Maintenance and Repair Program socket option, mysqlcheck — A Table Maintenance and Repair Program SSL options, mysqlcheck — A Table Maintenance and Repair Program tables option, mysqlcheck — A Table Maintenance and Repair Program use-frm option, mysqlcheck — A Table Maintenance and Repair Program user option, mysqlcheck — A Table Maintenance and Repair Program verbose option, mysqlcheck — A Table Maintenance and Repair Program version option, mysqlcheck — A Table Maintenance and Repair Program mysqlclient library, APIs and Libraries mysqld, Overview of Server-Side Programs abort-slave-event-count option, Command Options allow-suspicious-udfs option, Command Options , Security-Related mysqld Options ansi option, Command Options as MySQL Cluster process, MySQL Server Process Usage for MySQL Cluster , MySQL Cluster-Related Command Options for mysqld basedir option, Command Options bdb-home option, BDB Startup Options bdb-lock-detect option, BDB Startup Options bdb-logdir option, BDB Startup Options bdb-no-recover option, BDB Startup Options bdb-no-sync option, BDB Startup Options bdb-shared-data option, BDB Startup Options bdb-tmpdir option, BDB Startup Options bind-address option, Command Options binlog-do-db option, The Binary Log binlog-ignore-db option, The Binary Log bootstrap option, Command Options character-set-client-handshake option, Command Options character-set-filesystem option, Command Options character-set-server option, Command Options character-sets-dir option, Command Options chroot option, Command Options collation-server option, Command Options command options, Command Options console option, Command Options core-file option, Command Options datadir option, Command Options debug option, Command Options default-character-set option, Command Options default-collation option, Command Options default-storage-engine option, Command Options default-table-type option, Command Options default-time-zone option, Command Options delay-key-write option, Command Options , MyISAM Startup Options des-key-file option, Command Options disconnect-slave-event-count option, Command Options enable-named-pipe option, Command Options enable-pstack option, Command Options exit-info option, Command Options external-locking option, Command Options flush option, Command Options gdb option, Command Options help option, Command Options init-file option, Command Options innodb option, InnoDB Startup Options and System Variables innodb-safe-binlog option, Command Options innodb_status_file option, InnoDB Startup Options and System Variables language option, Command Options large-pages option, Command Options local-infile option, Security-Related mysqld Options log option, Command Options log-bin option, Command Options log-bin-index option, Command Options log-bin-trust-function-creators option, Command Options log-bin-trust-routine-creators option, Command Options log-error option, Command Options log-isam option, Command Options log-long-format option, Command Options log-queries-not-using-indexes option, Command Options log-short-format option, Command Options log-slave-updates option, Replication Startup Options log-slow-admin-statements option, Command Options log-slow-queries option, Command Options log-tc option, Command Options log-tc-size option, Command Options log-warnings option, Command Options , Replication Startup Options low-priority-updates option, Command Options master-connect-retry option, Replication Startup Options master-host option, Replication Startup Options master-info-file option, Replication Startup Options master-password option, Replication Startup Options master-port option, Replication Startup Options master-retry-count option, Replication Startup Options master-ssl option, Replication Startup Options master-ssl-ca option, Replication Startup Options master-ssl-capath option, Replication Startup Options master-ssl-cert option, Replication Startup Options master-ssl-cipher option, Replication Startup Options master-ssl-key option, Replication Startup Options master-user option, Replication Startup Options max-binlog-dump-events option, Command Options max-relay-log-size option, Replication Startup Options memlock option, Command Options myisam-recover option, Command Options , MyISAM Startup Options ndb-connectstring option, Command Options ndbcluster option, Command Options old-passwords option, Command Options , Security-Related mysqld Options one-thread option, Command Options open-files-limit option, Command Options pid-file option, Command Options port option, Command Options port-open-timeout option, Command Options read-only option, Replication Startup Options relay-log option, Replication Startup Options relay-log-index option, Replication Startup Options relay-log-info-file option, Replication Startup Options relay-log-purge option, Replication Startup Options relay-log-space-limit option, Replication Startup Options replicate-do-db option, Replication Startup Options replicate-do-table option, Replication Startup Options replicate-ignore-db option, Replication Startup Options replicate-ignore-table option, Replication Startup Options replicate-rewrite-db option, Replication Startup Options replicate-same-server-id option, Replication Startup Options replicate-wild-do-table option, Replication Startup Options replicate-wild-ignore-table option, Replication Startup Options report-host option, Replication Startup Options report-password option, Replication Startup Options report-port option, Replication Startup Options report-user option, Replication Startup Options role in MySQL Cluster, Basic MySQL Cluster Concepts safe-mode option, Command Options safe-show-database option, Command Options , Security-Related mysqld Options safe-user-create option, Command Options , Security-Related mysqld Options secure-auth option, Command Options , Security-Related mysqld Options secure-file-priv option, Command Options , Security-Related mysqld Options shared-memory option, Command Options shared-memory-base-name option, Command Options show-slave-auth-info option, Replication Startup Options skip-bdb option, Command Options , BDB Startup Options skip-concurrent-insert option, Command Options skip-external-locking option, Command Options skip-grant-tables option, Command Options , Security-Related mysqld Options skip-host-cache option, Command Options skip-innodb option, Command Options skip-merge option, Command Options skip-name-resolve option, Command Options , Security-Related mysqld Options skip-ndbcluster option, Command Options skip-networking option, Command Options , Security-Related mysqld Options skip-safemalloc option, Command Options skip-show-database option, Command Options , Security-Related mysqld Options skip-slave-start option, Replication Startup Options skip-stack-trace option, Command Options skip-symbolic-links option, Command Options skip-thread-priority option, Command Options slave-load-tmpdir option, Replication Startup Options slave-net-timeout option, Replication Startup Options slave-skip-errors option, Replication Startup Options slave_compressed_protocol option, Replication Startup Options socket option, Command Options sporadic-binlog-dump-fail option, Command Options sql-mode option, Command Options SSL options, Command Options , Making MySQL Secure Against Attackers standalone option, Command Options starting, How to Run MySQL as a Normal User symbolic-links option, Command Options sync-bdb-logs option, BDB Startup Options sysdate-is-now option, Command Options tc-heuristic-recover option, Command Options temp-pool option, Command Options tmpdir option, Command Options transaction-isolation option, Command Options user option, Command Options version option, Command Options mysqld library, APIs and Libraries mysqld option mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqld options, Tuning Server Parameters mysqld server buffer sizes, Tuning Server Parameters mysqld-version option mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqldump, Copying MySQL Databases to Another Machine , Overview of Client and Utility Programs add-drop-database option, mysqldump — A Database Backup Program add-drop-table option, mysqldump — A Database Backup Program add-locks option, mysqldump — A Database Backup Program all-databases option, mysqldump — A Database Backup Program allow-keywords option, mysqldump — A Database Backup Program character-sets-dir option, mysqldump — A Database Backup Program comments option, mysqldump — A Database Backup Program compact option, mysqldump — A Database Backup Program compatible option, mysqldump — A Database Backup Program complete-insert option, mysqldump — A Database Backup Program compress option, mysqldump — A Database Backup Program create-options option, mysqldump — A Database Backup Program databases option, mysqldump — A Database Backup Program debug option, mysqldump — A Database Backup Program default-character-set option, mysqldump — A Database Backup Program delayed-insert option, mysqldump — A Database Backup Program delete-master-logs option, mysqldump — A Database Backup Program disable-keys option, mysqldump — A Database Backup Program extended-insert option, mysqldump — A Database Backup Program fields-enclosed-by option, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program fields-escaped-by option, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program fields-optionally-enclosed-by option, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program fields-terminated-by option, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program first-slave option, mysqldump — A Database Backup Program flush-logs option, mysqldump — A Database Backup Program flush-privileges option, mysqldump — A Database Backup Program force option, mysqldump — A Database Backup Program help option, mysqldump — A Database Backup Program hex-blob option, mysqldump — A Database Backup Program host option, mysqldump — A Database Backup Program ignore-table option, mysqldump — A Database Backup Program insert-ignore option, mysqldump — A Database Backup Program lines-terminated-by option, mysqldump — A Database Backup Program , mysqlimport — A Data Import Program lock-all-tables option, mysqldump — A Database Backup Program lock-tables option, mysqldump — A Database Backup Program master-data option, mysqldump — A Database Backup Program no-autocommit option, mysqldump — A Database Backup Program no-create-db option, mysqldump — A Database Backup Program no-create-info option, mysqldump — A Database Backup Program no-data option, mysqldump — A Database Backup Program opt option, mysqldump — A Database Backup Program order-by-primary option, mysqldump — A Database Backup Program password option, mysqldump — A Database Backup Program port option, mysqldump — A Database Backup Program problems, mysqldump — A Database Backup Program , Restrictions on Views protocol option, mysqldump — A Database Backup Program quick option, mysqldump — A Database Backup Program quote-names option, mysqldump — A Database Backup Program result-file option, mysqldump — A Database Backup Program routines option, mysqldump — A Database Backup Program set-charset option, mysqldump — A Database Backup Program single-transaction option, mysqldump — A Database Backup Program skip-comments option, mysqldump — A Database Backup Program skip-opt option, mysqldump — A Database Backup Program socket option, mysqldump — A Database Backup Program SSL options, mysqldump — A Database Backup Program tab option, mysqldump — A Database Backup Program tables option, mysqldump — A Database Backup Program triggers option, mysqldump — A Database Backup Program tz-utc option, mysqldump — A Database Backup Program user option, mysqldump — A Database Backup Program verbose option, mysqldump — A Database Backup Program version option, mysqldump — A Database Backup Program views, mysqldump — A Database Backup Program , Restrictions on Views where option, mysqldump — A Database Backup Program workarounds, mysqldump — A Database Backup Program , Restrictions on Views xml option, mysqldump — A Database Backup Program mysqld_multi, Overview of Server-Side Programs config-file option, mysqld_multi — Manage Multiple MySQL Servers example option, mysqld_multi — Manage Multiple MySQL Servers help option, mysqld_multi — Manage Multiple MySQL Servers log option, mysqld_multi — Manage Multiple MySQL Servers mysqladmin option, mysqld_multi — Manage Multiple MySQL Servers mysqld option, mysqld_multi — Manage Multiple MySQL Servers no-log option, mysqld_multi — Manage Multiple MySQL Servers password option, mysqld_multi — Manage Multiple MySQL Servers silent option, mysqld_multi — Manage Multiple MySQL Servers tcp-ip option, mysqld_multi — Manage Multiple MySQL Servers user option, mysqld_multi — Manage Multiple MySQL Servers verbose option, mysqld_multi — Manage Multiple MySQL Servers version option, mysqld_multi — Manage Multiple MySQL Servers mysqld_safe, Overview of Server-Side Programs autoclose option, mysqld_safe — MySQL Server Startup Script basedir option, mysqld_safe — MySQL Server Startup Script core-file-size option, mysqld_safe — MySQL Server Startup Script datadir option, mysqld_safe — MySQL Server Startup Script defaults-extra-file option, mysqld_safe — MySQL Server Startup Script defaults-file option, mysqld_safe — MySQL Server Startup Script help option, mysqld_safe — MySQL Server Startup Script ledir option, mysqld_safe — MySQL Server Startup Script log-error option, mysqld_safe — MySQL Server Startup Script mysqld option, mysqld_safe — MySQL Server Startup Script mysqld-version option, mysqld_safe — MySQL Server Startup Script nice option, mysqld_safe — MySQL Server Startup Script no-defaults option, mysqld_safe — MySQL Server Startup Script open-files-limit option, mysqld_safe — MySQL Server Startup Script pid-file option, mysqld_safe — MySQL Server Startup Script port option, mysqld_safe — MySQL Server Startup Script socket option, mysqld_safe — MySQL Server Startup Script timezone option, mysqld_safe — MySQL Server Startup Script user option, mysqld_safe — MySQL Server Startup Script mysqlhotcopy, Overview of Client and Utility Programs addtodest option, mysqlhotcopy — A Database Backup Program allowold option, mysqlhotcopy — A Database Backup Program checkpoint option, mysqlhotcopy — A Database Backup Program chroot option, mysqlhotcopy — A Database Backup Program debug option, mysqlhotcopy — A Database Backup Program dryrun option, mysqlhotcopy — A Database Backup Program flushlog option, mysqlhotcopy — A Database Backup Program help option, mysqlhotcopy — A Database Backup Program host option, mysqlhotcopy — A Database Backup Program keepold option, mysqlhotcopy — A Database Backup Program method option, mysqlhotcopy — A Database Backup Program noindices option, mysqlhotcopy — A Database Backup Program password option, mysqlhotcopy — A Database Backup Program port option, mysqlhotcopy — A Database Backup Program quiet option, mysqlhotcopy — A Database Backup Program record_log_pos option, mysqlhotcopy — A Database Backup Program regexp option, mysqlhotcopy — A Database Backup Program resetmaster option, mysqlhotcopy — A Database Backup Program resetslave option, mysqlhotcopy — A Database Backup Program socket option, mysqlhotcopy — A Database Backup Program suffix option, mysqlhotcopy — A Database Backup Program tmpdir option, mysqlhotcopy — A Database Backup Program user option, mysqlhotcopy — A Database Backup Program mysqlimport, Copying MySQL Databases to Another Machine , Overview of Client and Utility Programs , LOAD DATA INFILE Syntax character-sets-dir option, mysqlimport — A Data Import Program columns option, mysqlimport — A Data Import Program compress option, mysqlimport — A Data Import Program debug option, mysqlimport — A Data Import Program default-character-set option, mysqlimport — A Data Import Program delete option, mysqlimport — A Data Import Program force option, mysqlimport — A Data Import Program help option, mysqlimport — A Data Import Program host option, mysqlimport — A Data Import Program ignore option, mysqlimport — A Data Import Program ignore-lines option, mysqlimport — A Data Import Program local option, mysqlimport — A Data Import Program lock-tables option, mysqlimport — A Data Import Program low-priority option, mysqlimport — A Data Import Program password option, mysqlimport — A Data Import Program port option, mysqlimport — A Data Import Program protocol option, mysqlimport — A Data Import Program replace option, mysqlimport — A Data Import Program silent option, mysqlimport — A Data Import Program socket option, mysqlimport — A Data Import Program SSL options, mysqlimport — A Data Import Program user option, mysqlimport — A Data Import Program verbose option, mysqlimport — A Data Import Program version option, mysqlimport — A Data Import Program mysqlmanager, Overview of Server-Side Programs angel-pid-file option, MySQL Instance Manager Command Options bind-address option, MySQL Instance Manager Command Options default-mysqld-path option, MySQL Instance Manager Command Options defaults-file option, MySQL Instance Manager Command Options help option, MySQL Instance Manager Command Options install option, MySQL Instance Manager Command Options log option, MySQL Instance Manager Command Options monitoring-interval option, MySQL Instance Manager Command Options password-file option, MySQL Instance Manager Command Options pid-file option, MySQL Instance Manager Command Options port option, MySQL Instance Manager Command Options print-defaults option, MySQL Instance Manager Command Options print-password-line option, MySQL Instance Manager Command Options remove option, MySQL Instance Manager Command Options run-as-service option, MySQL Instance Manager Command Options socket option, MySQL Instance Manager Command Options standalone option, MySQL Instance Manager Command Options user option, MySQL Instance Manager Command Options version option, MySQL Instance Manager Command Options wait-timeout option, MySQL Instance Manager Command Options mysqlshow, Overview of Client and Utility Programs character-sets-dir option, mysqlshow — Display Database, Table, and Column Information compress option, mysqlshow — Display Database, Table, and Column Information count option, mysqlshow — Display Database, Table, and Column Information debug option, mysqlshow — Display Database, Table, and Column Information default-character-set option, mysqlshow — Display Database, Table, and Column Information help option, mysqlshow — Display Database, Table, and Column Information host option, mysqlshow — Display Database, Table, and Column Information keys option, mysqlshow — Display Database, Table, and Column Information password option, mysqlshow — Display Database, Table, and Column Information port option, mysqlshow — Display Database, Table, and Column Information protocol option, mysqlshow — Display Database, Table, and Column Information show-table-type option, mysqlshow — Display Database, Table, and Column Information socket option, mysqlshow — Display Database, Table, and Column Information SSL options, mysqlshow — Display Database, Table, and Column Information status option, mysqlshow — Display Database, Table, and Column Information user option, mysqlshow — Display Database, Table, and Column Information verbose option, mysqlshow — Display Database, Table, and Column Information version option, mysqlshow — Display Database, Table, and Column Information mysqltest MySQL Test Suite, MySQL Test Suite mysql_affected_rows(), mysql_affected_rows() mysql_autocommit(), mysql_autocommit() MYSQL_BIND C type, C API Prepared Statement Data types 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_convert_table_format, Overview of Client and Utility Programs mysql_create_db(), mysql_create_db() mysql_data_seek(), mysql_data_seek() MYSQL_DEBUG environment variable, Environment Variables , Overview of Client and Utility Programs 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_explain_log, Overview of Client and Utility Programs date option, mysql_explain_log — Use EXPLAIN on Statements in Query Log help option, mysql_explain_log — Use EXPLAIN on Statements in Query Log host option, mysql_explain_log — Use EXPLAIN on Statements in Query Log password option, mysql_explain_log — Use EXPLAIN on Statements in Query Log printerror option, mysql_explain_log — Use EXPLAIN on Statements in Query Log socket option, mysql_explain_log — Use EXPLAIN on Statements in Query Log user option, mysql_explain_log — Use EXPLAIN on Statements in Query Log 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 Data types mysql_field_count(), mysql_field_count() , mysql_num_fields() MYSQL_FIELD_OFFSET C type, C API Data types mysql_field_seek(), mysql_field_seek() mysql_field_tell(), mysql_field_tell() mysql_find_rows, Overview of Client and Utility Programs help option, mysql_find_rows — Extract Queries from Update Log regexp option, mysql_find_rows — Extract Queries from Update Log rows option, mysql_find_rows — Extract Queries from Update Log skip-use-db option, mysql_find_rows — Extract Queries from Update Log start_row option, mysql_find_rows — Extract Queries from Update Log mysql_fix_extensions, Overview of Client and Utility Programs mysql_fix_privilege_tables, Overview of Server-Side Programs 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_get_ssl_cipher(), mysql_get_ssl_cipher() MYSQL_GROUP_SUFFIX environment variable, Environment Variables mysql_hex_string(), mysql_hex_string() MYSQL_HISTFILE environment variable, Environment Variables , mysql Options MYSQL_HOME environment variable, Environment Variables MYSQL_HOST environment variable, Environment Variables , Connecting to the MySQL Server mysql_info(), ALTER TABLE Syntax , INSERT Syntax , LOAD DATA INFILE Syntax , UPDATE Syntax , mysql_info() mysql_init(), mysql_init() mysql_insert_id(), Transactions and Atomic Operations , INSERT Syntax , mysql_insert_id() mysql_install_db, Overview of Server-Side Programs mysql_install_db script, Problems Running mysql_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, Environment Variables MYSQL_PWD environment variable, Environment Variables , Connecting to the MySQL Server , Overview of Client and Utility Programs mysql_query(), mysql_query() , Common Questions and Problems When Using the C API mysql_real_connect(), mysql_real_connect() mysql_real_escape_string(), Strings , mysql_real_escape_string() mysql_real_query(), mysql_real_query() mysql_refresh(), mysql_refresh() mysql_reload(), mysql_reload() MYSQL_RES C type, C API Data types mysql_rollback(), mysql_rollback() MYSQL_ROW C type, C API Data types mysql_row_seek(), mysql_row_seek() mysql_row_tell(), mysql_row_tell() mysql_secure_installation, Overview of Server-Side Programs mysql_select_db(), mysql_select_db() mysql_server_end(), mysql_server_end() mysql_server_init(), mysql_server_init() mysql_setpermission, Overview of Client and Utility Programs help option, mysql_setpermission — Interactively Set Permissions in Grant
Tables host option, mysql_setpermission — Interactively Set Permissions in Grant
Tables password option, mysql_setpermission — Interactively Set Permissions in Grant
Tables port option, mysql_setpermission — Interactively Set Permissions in Grant
Tables socket option, mysql_setpermission — Interactively Set Permissions in Grant
Tables user option, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_set_character_set(), mysql_set_character_set() mysql_set_local_infile_default(), mysql_set_local_infile_default() 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 Prepared Statement Data types 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() , Common Questions and Problems When Using the C API mysql_tableinfo, Overview of Client and Utility Programs clear option, mysql_tableinfo — Generate Database Metadata clear-only option, mysql_tableinfo — Generate Database Metadata col option, mysql_tableinfo — Generate Database Metadata help option, mysql_tableinfo — Generate Database Metadata host option, mysql_tableinfo — Generate Database Metadata idx option, mysql_tableinfo — Generate Database Metadata password option, mysql_tableinfo — Generate Database Metadata port option, mysql_tableinfo — Generate Database Metadata prefix option, mysql_tableinfo — Generate Database Metadata quiet option, mysql_tableinfo — Generate Database Metadata socket option, mysql_tableinfo — Generate Database Metadata tbl-status option, mysql_tableinfo — Generate Database Metadata user option, mysql_tableinfo — Generate Database Metadata MYSQL_TCP_PORT environment variable, Environment Variables , Running Multiple Servers on Unix , Using Client Programs in a Multiple-Server Environment , Overview of Client and Utility Programs 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_TIME C type, C API Prepared Statement Data types mysql_tzinfo_to_sql, Overview of Server-Side Programs MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db , Environment Variables , Running Multiple Servers on Unix , Using Client Programs in a Multiple-Server Environment , Overview of Client and Utility Programs mysql_upgrade, Overview of Server-Side Programs , Causes of Access denied Errors basedir option, mysql_upgrade — Check Tables for MySQL Upgrade datadir option, mysql_upgrade — Check Tables for MySQL Upgrade force option, mysql_upgrade — Check Tables for MySQL Upgrade help option, mysql_upgrade — Check Tables for MySQL Upgrade user option, mysql_upgrade — Check Tables for MySQL Upgrade verbose option, mysql_upgrade — Check Tables for MySQL Upgrade mysql_use_result(), mysql_use_result() mysql_waitpid, Overview of Client and Utility Programs help option, mysql_waitpid — Kill Process and Wait for Its Termination verbose option, mysql_waitpid — Kill Process and Wait for Its Termination version option, mysql_waitpid — Kill Process and Wait for Its Termination mysql_warning_count(), mysql_warning_count() mysql_zap, Overview of Client and Utility Programs my_bool C type, C API Data types my_bool values printing, C API Data types my_init(), my_init() my_print_defaults, Overview of Client and Utility Programs config-file option, my_print_defaults — Display Options from Option Files debug option, my_print_defaults — Display Options from Option Files defaults-extra-file option, my_print_defaults — Display Options from Option Files defaults-file option, my_print_defaults — Display Options from Option Files defaults-group-suffix option, my_print_defaults — Display Options from Option Files extra-file option, my_print_defaults — Display Options from Option Files help option, my_print_defaults — Display Options from Option Files no-defaults option, my_print_defaults — Display Options from Option Files verbose option, my_print_defaults — Display Options from Option Files version option, my_print_defaults — Display Options from Option Files my_ulonglong C type, C API Data types my_ulonglong values printing, C API Data types N named pipes, Selecting a MySQL Server Type , Testing The MySQL Installation named-commands option mysql, mysql Options names, Database, Table, Index, Column, and Alias Names case sensitivity, Identifier Case Sensitivity variables, User-Defined Variables NAME_CONST(), Miscellaneous Functions name_file option comp_err, comp_err — Compile MySQL Error Message File naming releases of MySQL, Choosing Which Version of MySQL to Install NATIONAL CHAR data type, Overview of String Types native functions adding, Adding a New Native Function native thread support, Operating Systems Supported by MySQL Community Server NATURAL LEFT JOIN, JOIN Syntax NATURAL LEFT OUTER JOIN, JOIN Syntax NATURAL RIGHT JOIN, JOIN Syntax NATURAL RIGHT OUTER JOIN, JOIN Syntax NCHAR data type, Overview of String Types NDB, MySQL 5.0 FAQ — MySQL Cluster ndb option perror, perror — Explain Error Codes NDB storage engine, MySQL Cluster FAQ, MySQL 5.0 FAQ — MySQL Cluster ndb-connectstring option mysqld, Command Options ndb_config, ndb_config — Extract NDB Configuration Information ndbcluster option mysqld, Command Options ndbd (MySQL Cluster) defined, Basic MySQL Cluster Concepts ndb_config, Cluster Utility Programs config-file option, ndb_config — Extract NDB Configuration Information fields option, ndb_config — Extract NDB Configuration Information host option, ndb_config — Extract NDB Configuration Information id option, ndb_config — Extract NDB Configuration Information ndb-connectstring option, ndb_config — Extract NDB Configuration Information nodeid option, ndb_config — Extract NDB Configuration Information nodes option, ndb_config — Extract NDB Configuration Information query option, ndb_config — Extract NDB Configuration Information rows option, ndb_config — Extract NDB Configuration Information type option, ndb_config — Extract NDB Configuration Information usage option, ndb_config — Extract NDB Configuration Information version option, ndb_config — Extract NDB Configuration Information ndb_cpcd, Cluster Utility Programs ndb_delete_all, Cluster Utility Programs transactional option, ndb_delete_all — Delete All Rows from NDB Table ndb_desc, Cluster Utility Programs extra-partition-info option, ndb_desc — Describe NDB Tables ndb_drop_index, Cluster Utility Programs ndb_drop_table, Cluster Utility Programs ndb_error_reporter, Cluster Utility Programs ndb_mgm (MySQL Cluster management node client), Initial Startup ndb_mgmd (MySQL Cluster) defined, Basic MySQL Cluster Concepts ndb_print_backup_file, Cluster Utility Programs ndb_print_schema_file, Cluster Utility Programs ndb_print_sys_file, Cluster Utility Programs ndb_restore errors, ndb_restore — Restore a Cluster Backup ndb_select_all, Cluster Utility Programs delimiter option, ndb_select_all — Print Rows from NDB Table descending option, ndb_select_all — Print Rows from NDB Table gci option, ndb_select_all — Print Rows from NDB Table header option, ndb_select_all — Print Rows from NDB Table lock option, ndb_select_all — Print Rows from NDB Table nodata option, ndb_select_all — Print Rows from NDB Table order option, ndb_select_all — Print Rows from NDB Table rowid option, ndb_select_all — Print Rows from NDB Table tupscan option, ndb_select_all — Print Rows from NDB Table useHexFormat option, ndb_select_all — Print Rows from NDB Table ndb_select_count, Cluster Utility Programs ndb_show_tables, Cluster Utility Programs loops option, ndb_show_tables — Display List of NDB Tables parsable option, ndb_show_tables — Display List of NDB Tables type option, ndb_show_tables — Display List of NDB Tables unqualified option, ndb_show_tables — Display List of NDB Tables ndb_size.pl, Cluster Utility Programs ndb_size.pl (utility), MySQL 5.0 FAQ — MySQL Cluster ndb_waiter, Cluster Utility Programs no-contact option, ndb_waiter — Wait for Cluster to Reach a Given Status not-started option, ndb_waiter — Wait for Cluster to Reach a Given Status timeout option, ndb_waiter — Wait for Cluster to Reach a Given Status negative values, Numbers nested queries, Subquery Syntax net etiquette, Guidelines for Using the Mailing Lists netmask notation in mysql.user table, Access Control, Stage 1: Connection Verification NetWare, Installing MySQL on NetWare net_buffer_length variable, mysql Options New features in MySQL Cluster, MySQL Cluster Development Roadmap new procedures adding, Adding New Procedures to MySQL new users adding, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems , Source Installation Overview newline (\n), Strings next-key lock, InnoDB Startup Options and System Variables , InnoDB and TRANSACTION ISOLATION
LEVEL , Next-Key Locking: Avoiding the Phantom Problem NFS InnoDB, InnoDB Configuration , Restrictions on InnoDB Tables nice option mysqld_safe, mysqld_safe — MySQL Server Startup Script no matching rows, Solving Problems with No Matching Rows no-auto-rehash option mysql, mysql Options no-autocommit option mysqldump, mysqldump — A Database Backup Program no-beep option mysql, mysql Options no-contact option ndb_waiter, ndb_waiter — Wait for Cluster to Reach a Given Status no-create-db option mysqldump, mysqldump — A Database Backup Program no-create-info option mysqldump, mysqldump — A Database Backup Program no-data option mysqldump, mysqldump — A Database Backup Program no-debug option make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive no-defaults option, Using Option Files mysqld_safe, mysqld_safe — MySQL Server Startup Script my_print_defaults, my_print_defaults — Display Options from Option Files no-embedded option make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive no-log option mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers no-named-commands option mysql, mysql Options no-pager option mysql, mysql Options no-symlinks option myisamchk, myisamchk Repair Options no-tee option mysql, mysql Options nodata option ndb_select_all, ndb_select_all — Print Rows from NDB Table node groups (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions node identifiers (MySQL Cluster), Shared-Memory Connections , SCI Transport Connections node logs (MySQL Cluster), Event Reports Generated in MySQL Cluster nodeid option ndb_config, ndb_config — Extract NDB Configuration Information NODERESTART Events (MySQL Cluster), Log Events nodes option ndb_config, ndb_config — Extract NDB Configuration Information noindices option mysqlhotcopy, mysqlhotcopy — A Database Backup Program non-delimited strings, The DATETIME, DATE, and
TIMESTAMP Types Non-transactional tables, Rollback Failure for Non-Transactional Tables NoOfDiskPagesToDiskAfterRestartACC calculating, Configuring Parameters for Local Checkpoints NoOfDiskPagesToDiskAfterRestartACC (MySQL Cluster
configuration parameter), Defining Data Nodes NoOfDiskPagesToDiskAfterRestartTUP calculating, Configuring Parameters for Local Checkpoints NoOfDiskPagesToDiskAfterRestartTUP (MySQL Cluster
configuration parameter), Defining Data Nodes NoOfDiskPagesToDiskDuringRestartACC (MySQL Cluster
configuration parameter), Defining Data Nodes NoOfDiskPagesToDiskDuringRestartTUP (MySQL Cluster
configuration parameter), Defining Data Nodes NoOfFragmentLogFiles, Defining Data Nodes calculating, Configuring Parameters for Local Checkpoints NoOfReplicas, Defining Data Nodes NOT logical, Logical Operators NOT BETWEEN, Comparison Functions and Operators not equal (!=), Comparison Functions and Operators not equal (<>), Comparison Functions and Operators NOT EXISTS with subqueries, EXISTS and NOT EXISTS NOT IN, Comparison Functions and Operators NOT LIKE, String Comparison Functions NOT NULL constraint, Constraints on Invalid Data NOT REGEXP, String Comparison Functions not-started option ndb_waiter, ndb_waiter — Wait for Cluster to Reach a Given Status Novell NetWare, Installing MySQL on NetWare NOW(), Date and Time Functions NO_AUTO_CREATE_USER SQL mode, SQL Modes NO_AUTO_VALUE_ON_ZERO SQL mode, SQL Modes NO_BACKSLASH_ESCAPES SQL mode, SQL Modes NO_DIR_IN_CREATE SQL mode, SQL Modes NO_FIELD_OPTIONS SQL mode, SQL Modes NO_KEY_OPTIONS SQL mode, SQL Modes NO_TABLE_OPTIONS SQL mode, SQL Modes NO_UNSIGNED_SUBTRACTION SQL mode, SQL Modes NO_ZERO_DATE SQL mode, SQL Modes NO_ZERO_IN_DATE SQL mode, SQL Modes NUL, Strings NULL, Working with NULL Values , Problems with NULL Values ORDER BY, ORDER BY Optimization , SELECT Syntax testing for null, Comparison Functions and Operators , Control Flow Functions NULL value, Working with NULL Values , NULL Values NULL values and AUTO_INCREMENT columns, Problems with NULL Values and indexes, CREATE TABLE Syntax and TIMESTAMP columns, Problems with NULL Values vs. empty values, Problems with NULL Values NULLIF(), Control Flow Functions numbers, Numbers NUMERIC data type, Overview of Numeric Types numeric types, Data Type Storage Requirements numeric-dump-file option resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols NumGeometries(), GeometryCollection Functions NumInteriorRings(), Polygon Functions NumPoints(), LineString Functions O Obtaining MySQL Cluster, Multi-Computer Installation OCT(), String Functions OCTET_LENGTH(), String Functions ODBC, MySQL Connector/ODBC ODBC compatibility, Identifier Qualifiers , Overview of Numeric Types , Type Conversion in Expression Evaluation , Comparison Functions and Operators , CREATE TABLE Syntax , JOIN Syntax offset option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files OLAP, GROUP BY Modifiers old-passwords option mysqld, Command Options , Security-Related mysqld Options OLD_PASSWORD(), Encryption and Compression Functions old_server option mysqlaccess, mysqlaccess — Client for Checking Access Privileges ON DUPLICATE KEY, INSERT Syntax one-database option mysql, mysql Options one-thread option mysqld, Command Options online location of manual, About This Manual only-debug option make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive ONLY_FULL_GROUP_BY SQL mode, GROUP BY and HAVING with Hidden
Fields ONLY_FULL_GROUP_BY SQL mode, SQL Modes OPEN, Cursor OPEN Statement Open Source defined, What is MySQL? open tables, How MySQL Opens and Closes Tables , mysqladmin — Client for Administering a MySQL Server open-files-limit option mysqld, Command Options mysqld_safe, mysqld_safe — MySQL Server Startup Script OpenGIS, Introduction to MySQL Spatial Support opening tables, How MySQL Opens and Closes Tables opens, mysqladmin — Client for Administering a MySQL Server OpenSSL, Using Secure Connections , Using SSL Connections open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files operating systems file-size limits, The table is full supported, Operating Systems Supported by MySQL Community Server Windows versus Unix, MySQL on Windows Compared to MySQL on Unix operations arithmetic, Arithmetic Operators operators, Functions and Operators assignment, User-Defined Variables cast, Arithmetic Operators , Cast Functions and Operators logical, Logical Operators precedence, Operator Precedence opt option mysqldump, mysqldump — A Database Backup Program optimization subquery, Optimizing IN/=ANY Subqueries tips, Other Optimization Tips optimizations, WHERE Clause Optimization , Index Merge Optimization optimize option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program OPTIMIZE TABLE, OPTIMIZE TABLE Syntax optimizer controlling, Controlling Query Optimizer Performance optimizing DISTINCT, DISTINCT Optimization filesort, ORDER BY Optimization GROUP BY, GROUP BY Optimization LEFT JOIN, LEFT JOIN and RIGHT JOIN
Optimization LIMIT, LIMIT Optimization tables, Table Optimization option files, Using Option Files , Causes of Access denied Errors options command-line mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server configure, Typical configure Options myisamchk, myisamchk General Options provided by MySQL, Tutorial replication, Replication Features and Known Problems OR, Searching on Two Keys , Index Merge Optimization bitwise, Bit Functions logical, Logical Operators OR Index Merge optimization, Index Merge Optimization Oracle compatibility, MySQL Extensions to Standard SQL , GROUP BY (Aggregate) Functions , DESCRIBE Syntax ORACLE SQL mode, SQL Modes ORD(), String Functions ORDER BY, Sorting Rows , ALTER TABLE Syntax , SELECT Syntax NULL, ORDER BY Optimization , SELECT Syntax order option ndb_select_all, ndb_select_all — Print Rows from NDB Table order-by-primary option mysqldump, mysqldump — A Database Backup Program OUTFILE, SELECT Syntax out_dir option comp_err, comp_err — Compile MySQL Error Message File out_file option comp_err, comp_err — Compile MySQL Error Message File Overlaps(), Functions That Test Spatial Relationships Between Geometries overview, General Information P packages list of, Packages that support MySQL pack_isam, Overview of Client and Utility Programs page-level locking, Internal Locking Methods pager option mysql, mysql Options parallel-recover option myisamchk, myisamchk Repair Options parameters server, Tuning Server Parameters parentheses ( and ), Operator Precedence parsable option ndb_show_tables, ndb_show_tables — Display List of NDB Tables partitions (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions password root user, Securing the Initial MySQL Accounts password encryption reversibility of, Encryption and Compression Functions password option mysql, mysql Options mysqlaccess, mysqlaccess — Client for Checking Access Privileges mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_tableinfo, mysql_tableinfo — Generate Database Metadata PASSWORD(), Access Control, Stage 1: Connection Verification , Assigning Account Passwords , Encryption and Compression Functions , Ignoring user password-file option mysqlmanager, MySQL Instance Manager Command Options passwords for users, MySQL Usernames and Passwords forgotten, How to Reset the Root Password lost, How to Reset the Root Password resetting, How to Reset the Root Password security, What the Privilege System Does setting, Assigning Account Passwords , GRANT Syntax , SET PASSWORD Syntax PATH environment variable, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems , Environment Variables , Invoking MySQL Programs pattern matching, Pattern Matching , Regular Expressions performance benchmarks, Using Your Own Benchmarks disk issues, Disk Issues estimating, Estimating Query Performance improving, Replication FAQ , Make Your Data as Small as Possible PERIOD_ADD(), Date and Time Functions PERIOD_DIFF(), Date and Time Functions Perl installing, Perl Installation Notes installing on Windows, Installing ActiveState Perl on Windows Perl API, MySQL Perl API Perl DBI/DBD installation problems, Problems Using the Perl DBI/DBD
Interface permission checks effect on speed, Optimizing SELECT and Other Statements perror, Overview of Client and Utility Programs --ndb option, MySQL 5.0 FAQ — MySQL Cluster help option, perror — Explain Error Codes ndb option, perror — Explain Error Codes silent option, perror — Explain Error Codes verbose option, perror — Explain Error Codes version option, perror — Explain Error Codes PHP API, MySQL PHP API PI(), Mathematical Functions pid-file option mysql.server, mysql.server — MySQL Server Startup Script mysqld, Command Options mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqlmanager, MySQL Instance Manager Command Options PIPES_AS_CONCAT SQL mode, SQL Modes plan option mysqlaccess, mysqlaccess — Client for Checking Access Privileges POINT data type, MySQL Spatial Data Types point in time recovery, Point-in-Time Recovery Point(), Creating Geometry Values Using MySQL-Specific Functions PointFromText(), Creating Geometry Values Using WKT Functions PointFromWKB(), Creating Geometry Values Using WKB Functions PointN(), LineString Functions PointOnSurface(), MultiPolygon Functions PolyFromText(), Creating Geometry Values Using WKT Functions PolyFromWKB(), Creating Geometry Values Using WKB Functions POLYGON data type, MySQL Spatial Data Types Polygon(), Creating Geometry Values Using MySQL-Specific Functions PolygonFromText(), Creating Geometry Values Using WKT Functions PolygonFromWKB(), Creating Geometry Values Using WKB Functions port option mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlmanager, MySQL Instance Manager Command Options mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_tableinfo, mysql_tableinfo — Generate Database Metadata port-open-timeout option mysqld, Command Options portability, Designing Applications for Portability types, Using Data Types from Other Database Engines PortNumber, Defining the Management Server , Cluster TCP/IP Connections position option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files POSITION(), String Functions post-install multiple servers, Running Multiple MySQL Servers on the Same Machine post-installation setup and testing, Post-Installation Setup and Testing PostgreSQL compatibility, MySQL Extensions to Standard SQL POSTGRESQL SQL mode, SQL Modes POW(), Mathematical Functions POWER(), Mathematical Functions precedence operator, Operator Precedence precision arithmetic, Precision Math precision math, Precision Math prefix option mysql_tableinfo, mysql_tableinfo — Generate Database Metadata PREPARE, SQL Syntax for Prepared Statements XA transactions, XA Transaction SQL Syntax preview option mysqlaccess, mysqlaccess — Client for Checking Access Privileges previx option configure, Typical configure Options PRIMARY KEY, ALTER TABLE Syntax , CREATE TABLE Syntax constraint, PRIMARY KEY and UNIQUE Index
Constraints primary key deleting, ALTER TABLE Syntax print-defaults option, Using Option Files mysqlmanager, MySQL Instance Manager Command Options print-password-line option mysqlmanager, MySQL Instance Manager Command Options printerror option mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log privilege changes, Access Control, Stage 2: Request Verification privilege information location, Privileges Provided by MySQL privilege system, What the Privilege System Does described, How the Privilege System Works privileges access, The MySQL Access Privilege System adding, Adding New User Accounts to MySQL default, Securing the Initial MySQL Accounts deleting, Removing User Accounts from MySQL , DROP USER Syntax display, SHOW GRANTS Syntax dropping, Removing User Accounts from MySQL , DROP USER Syntax granting, GRANT Syntax revoking, REVOKE Syntax problems access denied errors, Access denied common errors, Problems and Common Errors compiling, Dealing with Problems Compiling MySQL DATE columns, Problems Using DATE Columns date values, The DATETIME, DATE, and
TIMESTAMP Types installing on IBM-AIX, IBM-AIX notes installing on Solaris, Solaris Notes installing Perl, Problems Using the Perl DBI/DBD
Interface linking, Problems Linking to the MySQL Client Library ODBC, Connector/ODBC Support reporting, How to Report Bugs or Problems starting the server, Starting and Troubleshooting the MySQL Server table locking, Table Locking Issues time zone, Time Zone Problems PROCEDURE, SELECT Syntax procedures adding, Adding New Procedures to MySQL stored, Stored Routines and Triggers , Stored Procedures and Functions process management (MySQL Cluster), Process Management in MySQL Cluster process support, Operating Systems Supported by MySQL Community Server processes display, SHOW PROCESSLIST Syntax processing arguments, UDF Argument Processing PROCESSLIST, SHOW PROCESSLIST Syntax PROFILING INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PROFILING Table program variables setting, Using Options to Set Program Variables programs client, Overview of Client and Utility Programs , Building Client Programs crash-me, Designing Applications for Portability server side, Overview of Server-Side Programs utility, Overview of Client and Utility Programs prompt option mysql, mysql Options prompts meanings, Entering Queries pronunciation MySQL, What is MySQL? protocol option mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information PURGE MASTER LOGS, PURGE MASTER LOGS Syntax PURGE STALE SESSIONS, MySQL Cluster Startup Phases Python API, MySQL Python API Q QUARTER(), Date and Time Functions queries entering, Entering Queries estimating performance, Estimating Query Performance examples, Examples of Common Queries speed of, Optimizing SELECT and Other Statements Twin Studies project, Queries from the Twin Project Query Cache, The MySQL Query Cache query option ndb_config, ndb_config — Extract NDB Configuration Information questions, mysqladmin — Client for Administering a MySQL Server answering, Guidelines for Using the Mailing Lists quick option myisamchk, myisamchk Repair Options mysql, mysql Options mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program quiet option mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysql_tableinfo, mysql_tableinfo — Generate Database Metadata QUIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client QUOTE(), String Functions quote-names option mysqldump, mysqldump — A Database Backup Program quotes in strings, Strings quoting, Strings quoting binary data, Strings quoting of identifiers, Database, Table, Index, Column, and Alias Names R RADIANS(), Mathematical Functions RAND(), Mathematical Functions raw option mysql, mysql Options re-creating grant tables, Problems Running mysql_install_db read-from-remote-server option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files read-only option myisamchk, myisamchk Check Options mysqld, Replication Startup Options read_buffer_size myisamchk
variable, myisamchk General Options REAL data type, Overview of Numeric Types REAL_AS_FLOAT SQL mode, SQL Modes ReceiveBufferMemory, Cluster TCP/IP Connections reconfiguring, Dealing with Problems Compiling MySQL reconnect option mysql, mysql Options record_log_pos option mysqlhotcopy, mysqlhotcopy — A Database Backup Program RECOVER XA transactions, XA Transaction SQL Syntax recover option myisamchk, myisamchk Repair Options recovery from crash, Using myisamchk for Crash Recovery point in time, Point-in-Time Recovery RedoBuffer, Defining Data Nodes reducing data size, Make Your Data as Small as Possible references, ALTER TABLE Syntax ref_or_null, IS NULL Optimization REGEXP, String Comparison Functions REGEXP operator, Regular Expressions regexp option mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysql_find_rows, mysql_find_rows — Extract Queries from Update Log regular expression syntax, Regular Expressions Related(), Functions That Test Spatial Relationships Between Geometries relational databases defined, What is MySQL? relative option mysqladmin, mysqladmin — Client for Administering a MySQL Server relay-log option mysqld, Replication Startup Options relay-log-index option mysqld, Replication Startup Options relay-log-info-file option mysqld, Replication Startup Options relay-log-purge option mysqld, Replication Startup Options relay-log-space-limit option mysqld, Replication Startup Options release notes, MySQL Enterprise Release Notes , MySQL Community Server Enhancements and Release Notes MySQL Community Server, MySQL Community Server Enhancements and Release Notes MySQL Enterprise, MySQL Enterprise Release Notes Release Notes MySQL Community Server, MySQL Community Server 5.0 Enhancements and Release Notes MySQL Enterprise, MySQL Enterprise 5.0 Release Notes release numbers, Choosing Which MySQL Distribution to Install RELEASE SAVEPOINT, SAVEPOINT and ROLLBACK TO
SAVEPOINT Syntax releases naming scheme, Choosing Which Version of MySQL to Install testing, Choosing Which Version of MySQL to Install updating, How and When Updates Are Released RELEASE_LOCK(), Miscellaneous Functions relnotes option mysqlaccess, mysqlaccess — Client for Checking Access Privileges remove option mysqlmanager, MySQL Instance Manager Command Options RENAME TABLE, RENAME TABLE Syntax RENAME USER, RENAME USER Syntax renaming user accounts, RENAME USER Syntax reordering columns, How to Change the Order of Columns in a Table repair option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program repair options myisamchk, myisamchk Repair Options REPAIR TABLE, REPAIR TABLE Syntax repairing tables, How to Repair Tables REPEAT, REPEAT Statement REPEAT(), String Functions replace, Overview of Client and Utility Programs REPLACE, REPLACE Syntax replace option mysqlimport, mysqlimport — A Data Import Program REPLACE(), String Functions replicas (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions replicate-do-db option mysqld, Replication Startup Options replicate-do-table option mysqld, Replication Startup Options replicate-ignore-db option mysqld, Replication Startup Options replicate-ignore-table option mysqld, Replication Startup Options replicate-rewrite-db option mysqld, Replication Startup Options replicate-same-server-id option mysqld, Replication Startup Options replicate-wild-do-table option mysqld, Replication Startup Options replicate-wild-ignore-table option mysqld, Replication Startup Options replication, Replication replication limitations, Replication Features and Known Problems replication masters statements, SQL Statements for Controlling Master Servers replication options, Replication Features and Known Problems replication slaves statements, SQL Statements for Controlling Slave Servers report-host option mysqld, Replication Startup Options report-password option mysqld, Replication Startup Options report-port option mysqld, Replication Startup Options report-user option mysqld, Replication Startup Options reporting bugs, How to Report Bugs or Problems Connector/NET problems, Connector/NET Support Connector/ODBC problems, Connector/ODBC Support errors, General Information , How to Report Bugs or Problems REQUIRE GRANT option, GRANT Syntax reserved words, Reserved Words RESET MASTER, RESET MASTER Syntax RESET SLAVE, RESET SLAVE Syntax resetmaster option mysqlhotcopy, mysqlhotcopy — A Database Backup Program resetslave option mysqlhotcopy, mysqlhotcopy — A Database Backup Program resolveip, Overview of Client and Utility Programs help option, resolveip — Resolve Hostname to IP Address or Vice
Versa silent option, resolveip — Resolve Hostname to IP Address or Vice
Versa version option, resolveip — Resolve Hostname to IP Address or Vice
Versa resolve_stack_dump, Overview of Client and Utility Programs help option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols numeric-dump-file option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols symbols-file option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols version option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols RESTART command (MySQL Cluster), Commands in the MySQL Cluster Management Client restarting the server, Unix Post-Installation Procedures RestartOnErrorInsert, Defining Data Nodes RESTORE TABLE, RESTORE TABLE Syntax restrictions server-side cursors, Restrictions on Server-Side Cursors stored routines, Restrictions on Stored Routines and Triggers subqueries, Restrictions on Subqueries triggers, Restrictions on Stored Routines and Triggers views, Restrictions on Views result-file option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqldump, mysqldump — A Database Backup Program retrieving data from tables, Retrieving Information from a Table return (\r), Strings return values UDFs, UDF Return Values and Error Handling REVERSE(), String Functions REVOKE, REVOKE Syntax revoking privileges, REVOKE Syntax rhost option mysqlaccess, mysqlaccess — Client for Checking Access Privileges RIGHT JOIN, JOIN Syntax RIGHT OUTER JOIN, JOIN Syntax RIGHT(), String Functions RLIKE, String Comparison Functions ROLLBACK, Transactions and Atomic Operations , START TRANSACTION, COMMIT, and
ROLLBACK Syntax XA transactions, XA Transaction SQL Syntax rollback option mysqlaccess, mysqlaccess — Client for Checking Access Privileges ROLLBACK TO SAVEPOINT, SAVEPOINT and ROLLBACK TO
SAVEPOINT Syntax rolling restart (MySQL Cluster), Performing a Rolling Restart of the Cluster rolling upgrades and downgrades (MySQL Cluster), Performing a Rolling Restart of the Cluster ROLLUP, GROUP BY Modifiers root password, Securing the Initial MySQL Accounts root user password resetting, How to Reset the Root Password ROUND(), Mathematical Functions rounding, Precision Math rounding errors, Overview of Numeric Types ROUTINES INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ROUTINES Table routines option mysqldump, mysqldump — A Database Backup Program ROW, Row Subqueries row subqueries, Row Subqueries row-level locking, Internal Locking Methods rowid option ndb_select_all, ndb_select_all — Print Rows from NDB Table rows counting, Counting Rows deleting, Deleting Rows from Related Tables locking, Transactions and Atomic Operations matching problems, Solving Problems with No Matching Rows selecting, Selecting Particular Rows sorting, Sorting Rows rows option mysql_find_rows, mysql_find_rows — Extract Queries from Update Log ndb_config, ndb_config — Extract NDB Configuration Information ROW_COUNT(), Information Functions RPAD(), String Functions RPM file, Installing MySQL from RPM Packages on Linux RPM Package Manager, Installing MySQL from RPM Packages on Linux RTRIM(), String Functions run-as-service option mysqlmanager, MySQL Instance Manager Command Options running ANSI mode, Running MySQL in ANSI Mode batch mode, Using mysql in Batch Mode multiple servers, Running Multiple MySQL Servers on the Same Machine queries, Entering Queries running configure after prior invocation, Dealing with Problems Compiling MySQL S safe-mode option mysqld, Command Options safe-recover option myisamchk, myisamchk Repair Options safe-show-database option mysqld, Command Options , Security-Related mysqld Options safe-updates option, Using the --safe-updates Option mysql, mysql Options safe-user-create option mysqld, Command Options , Security-Related mysqld Options Sakila, History of MySQL SAVEPOINT, SAVEPOINT and ROLLBACK TO
SAVEPOINT Syntax scale arithmetic, Precision Math schema altering, ALTER DATABASE Syntax creating, CREATE DATABASE Syntax deleting, DROP DATABASE Syntax SCHEMA(), Information Functions SCHEMATA INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMATA Table SCHEMA_PRIVILEGES INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table SCI (Scalable Coherent Interface), SCI Transport Connections , Configuring MySQL Cluster to use SCI Sockets script files, Using mysql in Batch Mode scripts mysqlbug, How to Report Bugs or Problems mysql_install_db, Problems Running mysql_install_db searching and case sensitivity, Case Sensitivity in Searches full-text, Full-Text Search Functions MySQL Web pages, How to Report Bugs or Problems two keys, Searching on Two Keys SECOND(), Date and Time Functions secure-auth option mysql, mysql Options mysqld, Command Options , Security-Related mysqld Options secure-file-priv option mysqld, Command Options , Security-Related mysqld Options security against attackers, Making MySQL Secure Against Attackers security system, The MySQL Access Privilege System SEC_TO_TIME(), Date and Time Functions SELECT LIMIT, SELECT Syntax optimizing, Optimizing Queries with EXPLAIN Query Cache, The MySQL Query Cache SELECT INTO, SELECT ... INTO Statement SELECT INTO TABLE, SELECT INTO TABLE SELECT speed, Speed of SELECT Queries selecting databases, Creating and Selecting a Database select_limit variable, mysql Options SendBufferMemory, Cluster TCP/IP Connections SendLimit, SCI Transport Connections SendSignalId, Cluster TCP/IP Connections , Shared-Memory Connections , SCI Transport Connections SEQUENCE, Using AUTO_INCREMENT sequence emulation, Information Functions sequences, Using AUTO_INCREMENT SERIAL, Overview of Numeric Types SERIAL DEFAULT VALUE, Data Type Default Values server connecting, Connecting to and Disconnecting from the Server , Connecting to the MySQL Server disconnecting, Connecting to and Disconnecting from the Server restart, Unix Post-Installation Procedures shutdown, Unix Post-Installation Procedures starting, Unix Post-Installation Procedures starting and stopping, Starting and Stopping MySQL Automatically starting problems, Starting and Troubleshooting the MySQL Server server variables, System Variables , SHOW VARIABLES Syntax server-side cursor restrictions, Restrictions on Server-Side Cursors server-side programs, Overview of Server-Side Programs ServerPort, Defining Data Nodes servers multiple, Running Multiple MySQL Servers on the Same Machine service-startup-timeout option mysql.server, mysql.server — MySQL Server Startup Script SESSION_USER(), Information Functions SET, SET Syntax , Variable SET Statement AUTOCOMMIT, SET Syntax BIG_TABLES, SET Syntax CHARACTER SET, Connection Character Sets and Collations , SET Syntax FOREIGN_KEY_CHECKS, SET Syntax IDENTITY, SET Syntax INSERT_ID, SET Syntax LAST_INSERT_ID, SET Syntax NAMES, Connection Character Sets and Collations , SET Syntax ONE_SHOT, SET Syntax PROFILING, SET Syntax PROFILING_HISTORY_SIZE, SET Syntax size, Data Type Storage Requirements SQL_AUTO_IS_NULL, SET Syntax SQL_BIG_SELECTS, SET Syntax SQL_BUFFER_SELECT, SET Syntax SQL_LOG_BIN, SET Syntax SQL_LOG_OFF, SET Syntax SQL_LOG_UPDATE, SET Syntax SQL_NOTES, SET Syntax SQL_QUOTE_SHOW_CREATE, SET Syntax SQL_SAFE_UPDATES, SET Syntax SQL_SELECT_LIMIT, SET Syntax SQL_WARNINGS, SET Syntax TIMESTAMP, SET Syntax UNIQUE_CHECKS, SET Syntax SET data type, Overview of String Types , The SET Type SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax SET OPTION, SET Syntax SET PASSWORD, SET PASSWORD Syntax SET PASSWORD statement, Assigning Account Passwords SET SQL_LOG_BIN, SET SQL_LOG_BIN Syntax SET TRANSACTION, SET TRANSACTION Syntax set-auto-increment[ option myisamchk, Other myisamchk Options set-character-set option myisamchk, myisamchk Repair Options set-charset option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqldump, mysqldump — A Database Backup Program set-collation option myisamchk, myisamchk Repair Options setting passwords, Assigning Account Passwords setting passwords, SET PASSWORD Syntax setting program variables, Using Options to Set Program Variables setup post-installation, Post-Installation Setup and Testing SHA(), Encryption and Compression Functions SHA1(), Encryption and Compression Functions shared memory transporter, Shared-Memory Connections shared-memory option mysqld, Command Options shared-memory-base-name option mysqld, Command Options SharedBufferSize, SCI Transport Connections shell syntax, Conventions Used in This Manual ShmKey, Shared-Memory Connections ShmSize, Shared-Memory Connections short-form option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files SHOW in MySQL Cluster management client, Quick Test Setup of MySQL Cluster SHOW BINARY LOGS, SHOW BINARY LOGS Syntax SHOW BINLOG EVENTS, SHOW Syntax , SHOW BINLOG EVENTS Syntax SHOW CHARACTER SET, SHOW CHARACTER SET Syntax SHOW COLLATION, SHOW COLLATION Syntax SHOW COLUMNS, SHOW Syntax , SHOW COLUMNS Syntax SHOW command (MySQL Cluster), Commands in the MySQL Cluster Management Client SHOW CREATE DATABASE, SHOW Syntax , SHOW CREATE DATABASE Syntax SHOW CREATE FUNCTION, SHOW Syntax , SHOW CREATE PROCEDURE and SHOW CREATE
FUNCTION Syntax SHOW CREATE PROCEDURE, SHOW Syntax , SHOW CREATE PROCEDURE and SHOW CREATE
FUNCTION Syntax SHOW CREATE SCHEMA, SHOW Syntax , SHOW CREATE DATABASE Syntax SHOW CREATE TABLE, SHOW Syntax , SHOW CREATE TABLE Syntax SHOW CREATE VIEW, SHOW Syntax , SHOW CREATE VIEW Syntax SHOW DATABASES, SHOW Syntax , SHOW DATABASES Syntax SHOW ENGINE, SHOW Syntax , SHOW ENGINE Syntax used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements SHOW ENGINE BDB LOGS, SHOW ENGINE Syntax SHOW ENGINE INNODB STATUS, SHOW ENGINE Syntax SHOW ENGINE NDB STATUS, SHOW ENGINE Syntax , Quick Reference: MySQL Cluster SQL Statements SHOW ENGINE NDBCLUSTER STATUS, Quick Reference: MySQL Cluster SQL Statements SHOW ENGINES, SHOW Syntax , SHOW ENGINES Syntax used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements SHOW ERRORS, SHOW Syntax , SHOW ERRORS Syntax and MySQL Cluster, MySQL 5.0 FAQ — MySQL Cluster SHOW extensions, Extensions to SHOW Statements SHOW FIELDS, SHOW Syntax SHOW FUNCTION CODE, SHOW Syntax , SHOW PROCEDURE CODE and SHOW FUNCTION
CODE Syntax SHOW FUNCTION STATUS, SHOW Syntax , SHOW PROCEDURE STATUS and SHOW FUNCTION
STATUS Syntax SHOW GRANTS, SHOW Syntax , SHOW GRANTS Syntax SHOW INDEX, SHOW Syntax , SHOW INDEX Syntax SHOW INNODB STATUS, SHOW Syntax SHOW KEYS, SHOW Syntax , SHOW INDEX Syntax SHOW MASTER LOGS, SHOW Syntax , SHOW BINARY LOGS Syntax SHOW MASTER STATUS, SHOW Syntax , SHOW MASTER STATUS Syntax SHOW MUTEX STATUS, SHOW Syntax SHOW OPEN TABLES, SHOW Syntax , SHOW OPEN TABLES Syntax SHOW PRIVILEGES, SHOW Syntax , SHOW PRIVILEGES Syntax SHOW PROCEDURE CODE, SHOW Syntax , SHOW PROCEDURE CODE and SHOW FUNCTION
CODE Syntax SHOW PROCEDURE STATUS, SHOW Syntax , SHOW PROCEDURE STATUS and SHOW FUNCTION
STATUS Syntax SHOW PROCESSLIST, SHOW Syntax , SHOW PROCESSLIST Syntax SHOW PROFILE, SHOW Syntax , SHOW PROFILES and SHOW PROFILE
Syntax SHOW PROFILES, SHOW Syntax , SHOW PROFILES and SHOW PROFILE
Syntax SHOW SCHEMAS, SHOW Syntax , SHOW DATABASES Syntax SHOW SLAVE HOSTS, SHOW Syntax , SHOW SLAVE HOSTS Syntax SHOW SLAVE STATUS, SHOW Syntax , SHOW SLAVE STATUS Syntax SHOW STATUS, SHOW Syntax used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements SHOW STORAGE ENGINES, SHOW ENGINES Syntax SHOW TABLE STATUS, SHOW Syntax SHOW TABLE TYPES, SHOW Syntax , SHOW ENGINES Syntax SHOW TABLES, SHOW Syntax , SHOW TABLES Syntax SHOW TRIGGERS, SHOW Syntax , SHOW TRIGGERS Syntax SHOW VARIABLES, SHOW Syntax used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements SHOW WARNINGS, SHOW Syntax , SHOW WARNINGS Syntax and MySQL Cluster, MySQL 5.0 FAQ — MySQL Cluster SHOW with WHERE, The INFORMATION_SCHEMA Database , Extensions to SHOW Statements show-slave-auth-info option mysqld, Replication Startup Options show-table-type option mysqlshow, mysqlshow — Display Database, Table, and Column Information show-warnings option mysql, mysql Options SHUTDOWN command (MySQL Cluster), Commands in the MySQL Cluster Management Client shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server shutting down the server, Unix Post-Installation Procedures sigint-ignore option mysql, mysql Options SIGN(), Mathematical Functions silent column changes, Silent Column Specification Changes silent option myisamchk, myisamchk General Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqlimport, mysqlimport — A Data Import Program perror, perror — Explain Error Codes resolveip, resolveip — Resolve Hostname to IP Address or Vice
Versa SIN(), Mathematical Functions single quote (\'), Strings single user mode (MySQL Cluster), Commands in the MySQL Cluster Management Client , Single User Mode and ndb_restore, ndb_restore — Restore a Cluster Backup single-transaction option mysqldump, mysqldump — A Database Backup Program size of tables, The table is full sizes display, Data Types skip-bdb option mysqld, Command Options , BDB Startup Options skip-column-names option mysql, mysql Options skip-comments option mysqldump, mysqldump — A Database Backup Program skip-concurrent-insert option mysqld, Command Options skip-external-locking option mysqld, Command Options skip-grant-tables option mysqld, Command Options , Security-Related mysqld Options skip-host-cache option mysqld, Command Options skip-innodb option mysqld, Command Options skip-line-numbers option mysql, mysql Options skip-merge option mysqld, Command Options skip-name-resolve option mysqld, Command Options , Security-Related mysqld Options skip-ndbcluster option mysqld, Command Options skip-networking option mysqld, Command Options , Security-Related mysqld Options skip-opt option mysqldump, mysqldump — A Database Backup Program skip-safemalloc option mysqld, Command Options skip-show-database option mysqld, Command Options , Security-Related mysqld Options skip-slave-start option mysqld, Replication Startup Options skip-stack-trace option mysqld, Command Options skip-symbolic-links option mysqld, Command Options skip-thread-priority option mysqld, Command Options skip-use-db option mysql_find_rows, mysql_find_rows — Extract Queries from Update Log slave-load-tmpdir option mysqld, Replication Startup Options slave-net-timeout option mysqld, Replication Startup Options slave-skip-errors option mysqld, Replication Startup Options slave_compressed_protocol option mysqld, Replication Startup Options sleep option mysqladmin, mysqladmin — Client for Administering a MySQL Server SLEEP(), Miscellaneous Functions slow queries, mysqladmin — Client for Administering a MySQL Server slow query log, The Slow Query Log SMALLINT data type, Overview of Numeric Types socket location changing, Typical configure Options socket option mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlmanager, MySQL Instance Manager Command Options mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_tableinfo, mysql_tableinfo — Generate Database Metadata Solaris installation, Installing MySQL on Solaris Solaris installation problems, Solaris Notes Solaris troubleshooting, Dealing with Problems Compiling MySQL Solaris x86_64 issues, InnoDB Performance Tuning Tips SOME, Subqueries with ANY, IN, and
SOME sort-index option myisamchk, Other myisamchk Options sort-records option myisamchk, Other myisamchk Options sort-recover option myisamchk, myisamchk Repair Options sorting character sets, The Character Set Used for Data and Sorting data, Sorting Rows grant tables, Access Control, Stage 1: Connection Verification , Access Control, Stage 2: Request Verification table rows, Sorting Rows sort_buffer_size myisamchk
variable, myisamchk General Options sort_key_blocks myisamchk variable, myisamchk General Options SOUNDEX(), String Functions SOUNDS LIKE, String Functions source (mysql client command), Using mysql in Batch Mode , Executing SQL Statements from a Text File source distribution installing, MySQL Installation Using a Source Distribution source distributions on Linux, Linux Source Distribution Notes SPACE(), String Functions spassword option mysqlaccess, mysqlaccess — Client for Checking Access Privileges Spatial Extensions in MySQL, Introduction to MySQL Spatial Support speed compiling, How Compiling and Linking Affects the Speed of MySQL increasing with replication, Replication inserting, Speed of INSERT Statements linking, How Compiling and Linking Affects the Speed of MySQL of queries, Optimizing SELECT and Other Statements , Speed of SELECT Queries sporadic-binlog-dump-fail option mysqld, Command Options SQL defined, What is MySQL? SQL mode ONLY_FULL_GROUP_BY, GROUP BY and HAVING with Hidden
Fields SQL node (MySQL Cluster) defined, Basic MySQL Cluster Concepts SQL nodes (MySQL Cluster), MySQL Server Process Usage for MySQL Cluster SQL statements replication masters, SQL Statements for Controlling Master Servers replication slaves, SQL Statements for Controlling Slave Servers SQL statements relating to MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements SQL-92 extensions to, MySQL Standards Compliance sql-mode option mysqld, Command Options SQL_BIG_RESULT, SELECT Syntax SQL_BUFFER_RESULT, SELECT Syntax SQL_CACHE, Query Cache SELECT Options , SELECT Syntax SQL_CALC_FOUND_ROWS, SELECT Syntax SQL_NO_CACHE, Query Cache SELECT Options , SELECT Syntax SQL_SMALL_RESULT, SELECT Syntax sql_yacc.cc problems, Dealing with Problems Compiling MySQL SQRT(), Mathematical Functions square brackets, Data Types SRID(), General Geometry Functions SSH, Connecting to MySQL Remotely from Windows with SSH SSL, Using SSL Connections SSL and X509 Basics, Using Secure Connections SSL command options, SSL Command Options ssl option, SSL Command Options SSL options mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options , Making MySQL Secure Against Attackers mysqldump, mysqldump — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information SSL related options, GRANT Syntax ssl-ca option, SSL Command Options ssl-capath option, SSL Command Options ssl-cert option, SSL Command Options ssl-cipher option, SSL Command Options ssl-key option, SSL Command Options ssl-verify-server-cert option, SSL Command Options standalone option mysqld, Command Options mysqlmanager, MySQL Instance Manager Command Options Standard SQL differences from, MySQL Differences from Standard SQL , GRANT Syntax extensions to, MySQL Standards Compliance , MySQL Extensions to Standard SQL standards compatibility, MySQL Standards Compliance START XA transactions, XA Transaction SQL Syntax START BACKUP command (MySQL Cluster), Using The Management Client to Create a Backup START command (MySQL Cluster), Commands in the MySQL Cluster Management Client START SLAVE, START SLAVE Syntax START TRANSACTION, START TRANSACTION, COMMIT, and
ROLLBACK Syntax start-datetime option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files start-position option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files StartFailureTimeout (MySQL Cluster configuration
parameter), Defining Data Nodes starting comments, '--' as the Start of a Comment mysqld, How to Run MySQL as a Normal User the server, Unix Post-Installation Procedures the server automatically, Starting and Stopping MySQL Automatically Starting many servers, Running Multiple MySQL Servers on the Same Machine StartPartialTimeout, Defining Data Nodes StartPartitionedTimeout (MySQL Cluster configuration
parameter), Defining Data Nodes StartPoint(), LineString Functions STARTUP Events (MySQL Cluster), Log Events startup options default, Using Option Files startup parameters, Tuning Server Parameters mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server tuning, System Factors and Startup Parameter Tuning start_row option mysql_find_rows, mysql_find_rows — Extract Queries from Update Log statefile option comp_err, comp_err — Compile MySQL Error Message File statements GRANT, Adding New User Accounts to MySQL INSERT, Adding New User Accounts to MySQL replication masters, SQL Statements for Controlling Master Servers replication slaves, SQL Statements for Controlling Slave Servers statically compiling, Typical configure Options STATISTICS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA STATISTICS Table STATISTICS Events (MySQL Cluster), Log Events stats option myisam_ftdump, myisam_ftdump — Display Full-Text Index information stats_method myisamchk variable, myisamchk General Options status tables, SHOW TABLE STATUS Syntax status command results, mysqladmin — Client for Administering a MySQL Server STATUS command (MySQL Cluster), Commands in the MySQL Cluster Management Client status option mysqlshow, mysqlshow — Display Database, Table, and Column Information status variables, Status Variables , SHOW STATUS Syntax STD(), GROUP BY (Aggregate) Functions STDDEV(), GROUP BY (Aggregate) Functions STDDEV_POP(), GROUP BY (Aggregate) Functions STDDEV_SAMP(), GROUP BY (Aggregate) Functions STOP command (MySQL Cluster), Commands in the MySQL Cluster Management Client STOP SLAVE, STOP SLAVE Syntax stop-datetime option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files stop-position option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files StopOnError, Defining Data Nodes stopping the server, Starting and Stopping MySQL Automatically stopword list user-defined, Fine-Tuning MySQL Full-Text Search storage engine ARCHIVE, The ARCHIVE Storage Engine storage engines choosing, Storage Engines storage of data, Design Choices storage requirements data type, Data Type Storage Requirements storage space minimizing, Make Your Data as Small as Possible stored procedures, Stored Procedures and Functions stored procedures and triggers defined, Stored Routines and Triggers stored routine restrictions, Restrictions on Stored Routines and Triggers stored routines LAST_INSERT_ID(), Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID() STRAIGHT_JOIN, SELECT Syntax , JOIN Syntax STRCMP(), String Comparison Functions STRICT SQL mode, SQL Modes STRICT_ALL_TABLES SQL mode, SQL Modes STRICT_TRANS_TABLES SQL mode, SQL Modes string collating, String Collating Support string comparison functions, String Comparison Functions string comparisons case sensitivity, String Comparison Functions string functions, String Functions string literal introducer, Strings , Character String Literal Character Set and Collation string types, String Types StringMemory, Defining Data Nodes strings defined, Literal Values escaping characters, Literal Values non-delimited, The DATETIME, DATE, and
TIMESTAMP Types striping defined, Disk Issues STR_TO_DATE(), Date and Time Functions SUBDATE(), Date and Time Functions subqueries, Subquery Syntax correlated, Correlated Subqueries errors, Subquery Errors rewriting as joins, Rewriting Subqueries as Joins for Earlier MySQL Versions with ALL, Subqueries with ALL with ANY, IN, SOME, Subqueries with ANY, IN, and
SOME with EXISTS, EXISTS and NOT EXISTS with NOT EXISTS, EXISTS and NOT EXISTS with ROW, Row Subqueries subquery, Subquery Syntax subquery optimization, Optimizing IN/=ANY Subqueries subquery restrictions, Restrictions on Subqueries subselects, Subquery Syntax SUBSTR(), String Functions SUBSTRING(), String Functions SUBSTRING_INDEX(), String Functions SUBTIME(), Date and Time Functions subtraction (-), Arithmetic Operators suffix option mysqlhotcopy, mysqlhotcopy — A Database Backup Program SUM(), GROUP BY (Aggregate) Functions SUM(DISTINCT), GROUP BY (Aggregate) Functions superuser, Securing the Initial MySQL Accounts superuser option mysqlaccess, mysqlaccess — Client for Checking Access Privileges support for operating systems, Operating Systems Supported by MySQL Community Server suppression default values, Constraints on Invalid Data Sybase compatibility, USE Syntax symbolic links, Using Symbolic Links , Using Symbolic Links for Databases on Windows symbolic-links option mysqld, Command Options symbols-file option resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols SymDifference(), Spatial Operators sync-bdb-logs option mysqld, BDB Startup Options syntax regular expression, Regular Expressions SYSDATE(), Date and Time Functions sysdate-is-now option mysqld, Command Options system privilege, What the Privilege System Does security, General Security Issues system optimization, System Factors and Startup Parameter Tuning system table, Optimizing Queries with EXPLAIN system variables, System Variables , Using System Variables , SHOW VARIABLES Syntax SYSTEM_USER(), Information Functions T tab (\t), Strings tab option mysqldump, mysqldump — A Database Backup Program table changing, ALTER TABLE Syntax , Problems with ALTER TABLE deleting, DROP TABLE Syntax table aliases, SELECT Syntax table cache, How MySQL Opens and Closes Tables table is full, SET Syntax , The table is full Table is full error MySQL Cluster, MySQL 5.0 FAQ — MySQL Cluster table names case sensitivity, Identifier Case Sensitivity case-sensitivity, MySQL Extensions to Standard SQL table option mysql, mysql Options mysqlaccess, mysqlaccess — Client for Checking Access Privileges table scans avoiding, How to Avoid Table Scans table types choosing, Storage Engines table-level locking, Internal Locking Methods tables BDB, The BDB (BerkeleyDB) Storage
Engine Berkeley DB, The BDB (BerkeleyDB) Storage
Engine BLACKHOLE, The BLACKHOLE Storage Engine changing column order, How to Change the Order of Columns in a Table checking, myisamchk Check Options closing, How MySQL Opens and Closes Tables compressed format, Compressed Table Characteristics constant, Optimizing Queries with EXPLAIN , WHERE Clause Optimization copying, CREATE TABLE Syntax counting rows, Counting Rows creating, Creating a Table CSV, The CSV Storage Engine defragment, Dynamic Table Characteristics defragmenting, Setting Up a Table Maintenance Schedule , OPTIMIZE TABLE Syntax deleting rows, Deleting Rows from Related Tables displaying status, SHOW TABLE STATUS Syntax dynamic, Dynamic Table Characteristics error checking, How to Check MyISAM Tables for Errors EXAMPLE, The EXAMPLE Storage Engine FEDERATED, The FEDERATED Storage Engine flush, mysqladmin — Client for Administering a MySQL Server fragmentation, OPTIMIZE TABLE Syntax grant, Access Control, Stage 2: Request Verification HEAP, The MEMORY (HEAP) Storage Engine host, Access Control, Stage 2: Request Verification improving performance, Make Your Data as Small as Possible information, Getting Information About a Table information about, Getting Information About Databases and Tables InnoDB, The InnoDB Storage Engine loading data, Loading Data into a Table maintenance schedule, Setting Up a Table Maintenance Schedule maximum size, The table is full MEMORY, The MEMORY (HEAP) Storage Engine MERGE, The MERGE Storage Engine merging, The MERGE Storage Engine multiple, Using More Than one Table MyISAM, The MyISAM Storage Engine names, Database, Table, Index, Column, and Alias Names open, How MySQL Opens and Closes Tables opening, How MySQL Opens and Closes Tables optimizing, Table Optimization partitioning, The MERGE Storage Engine repairing, How to Repair Tables retrieving data, Retrieving Information from a Table selecting columns, Selecting Particular Columns selecting rows, Selecting Particular Rows sorting rows, Sorting Rows symbolic links, Using Symbolic Links for Tables on Unix system, Optimizing Queries with EXPLAIN too many, Drawbacks to Creating Many Tables in the Same Database unique ID for last row, How to Get the Unique ID for the Last Inserted Row updating, Transactions and Atomic Operations TABLES INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLES Table tables option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program table_cache, How MySQL Opens and Closes Tables TABLE_PRIVILEGES INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_PRIVILEGES Table TAN(), Mathematical Functions tar problems on Solaris, Installing MySQL on Solaris , Solaris Notes tbl-status option mysql_tableinfo, mysql_tableinfo — Generate Database Metadata tc-heuristic-recover option mysqld, Command Options Tcl API, MySQL Tcl API tcp-ip option mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers TCP/IP, Selecting a MySQL Server Type , Testing The MySQL Installation tee option mysql, mysql Options temp-pool option mysqld, Command Options temporary file write access, Problems Running mysql_install_db temporary tables internal, How MySQL Uses Internal Temporary Tables problems, TEMPORARY TABLE Problems terminal monitor defined, Tutorial test option myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables testing connection to the server, Access Control, Stage 1: Connection Verification installation, Unix Post-Installation Procedures of MySQL releases, Choosing Which Version of MySQL to Install post-installation, Post-Installation Setup and Testing testing mysqld mysqltest, MySQL Test Suite TEXT size, Data Type Storage Requirements TEXT columns default values, The BLOB and TEXT Types indexing, Column Indexes , CREATE TABLE Syntax TEXT data type, Overview of String Types , The BLOB and TEXT Types text files importing, Executing SQL Statements from a Text File thread support, Operating Systems Supported by MySQL Community Server non-native, MIT-pthreads Notes threaded clients, How to Make a Threaded Client threads, mysqladmin — Client for Administering a MySQL Server , SHOW PROCESSLIST Syntax , MySQL Internals display, SHOW PROCESSLIST Syntax TIME data type, Overview of Date and Time Types , The TIME Type time types, Data Type Storage Requirements time zone problems, Time Zone Problems TIME(), Date and Time Functions TimeBetweenGlobalCheckpoints (MySQL Cluster
configuration parameter), Defining Data Nodes TimeBetweenInactiveTransactionAbortCheck (MySQL
Cluster configuration parameter), Defining Data Nodes TimeBetweenLocalCheckpoints (MySQL Cluster
configuration parameter), Defining Data Nodes TimeBetweenWatchDogCheck, Defining Data Nodes TIMEDIFF(), Date and Time Functions timeout, System Variables , Miscellaneous Functions , INSERT DELAYED Syntax connect_timeout variable, mysql Options , mysqladmin — Client for Administering a MySQL Server shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server timeout option ndb_waiter, ndb_waiter — Wait for Cluster to Reach a Given Status TIMESTAMP and NULL values, Problems with NULL Values TIMESTAMP data type, Overview of Date and Time Types , The DATETIME, DATE, and
TIMESTAMP Types TIMESTAMP(), Date and Time Functions TIMESTAMPADD(), Date and Time Functions TIMESTAMPDIFF(), Date and Time Functions timezone option mysqld_safe, mysqld_safe — MySQL Server Startup Script TIME_FORMAT(), Date and Time Functions TIME_TO_SEC(), Date and Time Functions TINYBLOB data type, Overview of String Types TINYINT data type, Overview of Numeric Types TINYTEXT data type, Overview of String Types tips optimization, Other Optimization Tips TMPDIR environment variable, Problems Running mysql_install_db , Environment Variables tmpdir option myisamchk, myisamchk Repair Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysqld, Command Options mysqlhotcopy, mysqlhotcopy — A Database Backup Program to-last-log option mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files TODO symlinks, Using Symbolic Links for Tables on Unix tools list of, Tools that were used to create MySQL Touches(), Functions That Test Spatial Relationships Between Geometries TO_DAYS(), Date and Time Functions trace files (MySQL Cluster), ndbd — The Storage Engine Node Process TRADITIONAL SQL mode, SQL Modes transaction-isolation option mysqld, Command Options transaction-safe tables, Transactions and Atomic Operations , InnoDB Overview transactional option ndb_delete_all, ndb_delete_all — Delete All Rows from NDB Table TransactionBufferMemory, Defining Data Nodes TransactionDeadlockDetectionTimeout (MySQL Cluster
configuration parameter), Defining Data Nodes TransactionInactiveTimeout (MySQL Cluster
configuration parameter), Defining Data Nodes transactions support, Transactions and Atomic Operations , InnoDB Overview Translators list of, Documenters and translators trigger restrictions, Restrictions on Stored Routines and Triggers trigger, creating, CREATE TRIGGER Syntax trigger, dropping, DROP TRIGGER Syntax triggers, Stored Routines and Triggers , SHOW TRIGGERS Syntax , Triggers LAST_INSERT_ID(), Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID() TRIGGERS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TRIGGERS Table triggers option mysqldump, mysqldump — A Database Backup Program TRIM(), String Functions troubleshooting FreeBSD, Dealing with Problems Compiling MySQL Solaris, Dealing with Problems Compiling MySQL TRUE, Numbers , Boolean Values testing for, Comparison Functions and Operators TRUNCATE, TRUNCATE Syntax and MySQL Cluster, Limits and Differences from Standard MySQL Limits TRUNCATE(), Mathematical Functions tupscan option ndb_select_all, ndb_select_all — Print Rows from NDB Table tutorial, Tutorial Twin Studies queries, Queries from the Twin Project type conversions, Type Conversion in Expression Evaluation , Comparison Functions and Operators type option ndb_config, ndb_config — Extract NDB Configuration Information ndb_show_tables, ndb_show_tables — Display List of NDB Tables types column, Data Types columns, Choosing the Right Type for a Column data, Data Types date, Data Type Storage Requirements Date and Time, Date and Time Types numeric, Data Type Storage Requirements of tables, Storage Engines portability, Using Data Types from Other Database Engines strings, String Types time, Data Type Storage Requirements typographical conventions, Conventions Used in This Manual TZ environment variable, Environment Variables , Time Zone Problems tz-utc option mysqldump, mysqldump — A Database Backup Program U UCASE(), String Functions UCS-2, Character Set Support UDFs, CREATE FUNCTION Syntax , DROP FUNCTION Syntax compiling, Compiling and Installing User-Defined Functions defined, Adding New Functions to MySQL return values, UDF Return Values and Error Handling ulimit, 'File' Not Found and
Similar Errors UMASK environment variable, Environment Variables , Problems with File Permissions UMASK_DIR environment variable, Environment Variables , Problems with File Permissions unary minus (-), Arithmetic Operators unbuffered option mysql, mysql Options UNCOMPRESS(), Encryption and Compression Functions UNCOMPRESSED_LENGTH(), Encryption and Compression Functions UndoDataBuffer, Defining Data Nodes UndoIndexBuffer, Defining Data Nodes UNHEX(), String Functions Unicode, Character Set Support Unicode Collation Algorithm, Unicode Character Sets UNION, Searching on Two Keys , UNION Syntax Union(), Spatial Operators UNIQUE, ALTER TABLE Syntax constraint, PRIMARY KEY and UNIQUE Index
Constraints unique ID, How to Get the Unique ID for the Last Inserted Row Unix, MySQL Connector/ODBC , MySQL Connector/NET UNIX_TIMESTAMP(), Date and Time Functions UNKNOWN testing for, Comparison Functions and Operators unloading tables, Retrieving Information from a Table UNLOCK TABLES, LOCK TABLES and UNLOCK TABLES
Syntax unnamed views, Subqueries in the FROM clause unpack option myisamchk, myisamchk Repair Options unqualified option ndb_show_tables, ndb_show_tables — Display List of NDB Tables UNTIL, REPEAT Statement UPDATE, UPDATE Syntax update-state option myisamchk, myisamchk Check Options updating releases of MySQL, How and When Updates Are Released tables, Transactions and Atomic Operations upgrades MySQL Cluster, Upgrading and Downgrading MySQL Cluster , Performing a Rolling Restart of the Cluster , Cluster Upgrade and Downgrade Compatibility upgrades and downgrades (MySQL Cluster) compatibility between versions, Cluster Upgrade and Downgrade Compatibility upgrading, Upgrading MySQL different architecture, Copying MySQL Databases to Another Machine to 5.0, Upgrading from MySQL 4.1 to 5.0 upgrading tables ISAM, Upgrading from MySQL 4.1 to 5.0 UPPER(), String Functions uptime, mysqladmin — Client for Administering a MySQL Server URLs for downloading MySQL, How to Get MySQL usage option ndb_config, ndb_config — Extract NDB Configuration Information USE, USE Syntax USE INDEX, Index Hint Syntax USE KEY, Index Hint Syntax use-frm option mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program use-manager option mysql.server, mysql.server — MySQL Server Startup Script use-mysqld_safe option mysql.server, mysql.server — MySQL Server Startup Script useHexFormat option ndb_select_all, ndb_select_all — Print Rows from NDB Table user accounts creating, CREATE USER Syntax renaming, RENAME USER Syntax USER environment variable, Environment Variables , Connecting to the MySQL Server user option mysql, mysql Options mysql.server, mysql.server — MySQL Server Startup Script mysqlaccess, mysqlaccess — Client for Checking Access Privileges mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqld_safe, mysqld_safe — MySQL Server Startup Script mysqlhotcopy, mysqlhotcopy — A Database Backup Program mysqlimport, mysqlimport — A Data Import Program mysqlmanager, MySQL Instance Manager Command Options mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant
Tables mysql_tableinfo, mysql_tableinfo — Generate Database Metadata mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade user privileges adding, Adding New User Accounts to MySQL deleting, Removing User Accounts from MySQL , DROP USER Syntax dropping, Removing User Accounts from MySQL , DROP USER Syntax user table sorting, Access Control, Stage 1: Connection Verification user variables, User-Defined Variables USER(), Information Functions user-defined functions adding, Adding New Functions to MySQL , Adding a New User-Defined Function User-defined functions, CREATE FUNCTION Syntax , DROP FUNCTION Syntax usernames and passwords, MySQL Usernames and Passwords users adding, Installing MySQL from tar.gz Packages on Other
Unix-Like Systems , Source Installation Overview deleting, Removing User Accounts from MySQL , DROP USER Syntax root, Securing the Initial MySQL Accounts USER_PRIVILEGES INFORMATION_SCHEMA table, The INFORMATION_SCHEMA USER_PRIVILEGES Table uses of MySQL, What We Have Used MySQL For using multiple disks to start data, Using Symbolic Links for Databases on Windows UTC_DATE(), Date and Time Functions UTC_TIME(), Date and Time Functions UTC_TIMESTAMP(), Date and Time Functions UTF-8, Character Set Support utility programs, Overview of Client and Utility Programs UUID(), Miscellaneous Functions V valid numbers examples, Numbers VALUES(), Miscellaneous Functions VARBINARY data type, Overview of String Types , The BINARY and VARBINARY Types VARCHAR size, Data Type Storage Requirements VARCHAR data type, Overview of String Types , String Types VARCHARACTER data type, Overview of String Types variables mysqld, Tuning Server Parameters server, System Variables , SHOW VARIABLES Syntax status, Status Variables , SHOW STATUS Syntax system, System Variables , Using System Variables , SHOW VARIABLES Syntax user, User-Defined Variables VARIANCE(), GROUP BY (Aggregate) Functions VAR_POP(), GROUP BY (Aggregate) Functions VAR_SAMP(), GROUP BY (Aggregate) Functions verbose option myisamchk, myisamchk General Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables myisam_ftdump, myisam_ftdump — Display Full-Text Index information mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqldump, mysqldump — A Database Backup Program mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqlimport, mysqlimport — A Data Import Program mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination my_print_defaults, my_print_defaults — Display Options from Option Files perror, perror — Explain Error Codes version choosing, Choosing Which MySQL Distribution to Install latest, How to Get MySQL version option comp_err, comp_err — Compile MySQL Error Message File myisamchk, myisamchk General Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysql, mysql Options mysqlaccess, mysqlaccess — Client for Checking Access Privileges mysqladmin, mysqladmin — Client for Administering a MySQL Server mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program mysqld, Command Options mysqldump, mysqldump — A Database Backup Program mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers mysqlimport, mysqlimport — A Data Import Program mysqlmanager, MySQL Instance Manager Command Options mysqlshow, mysqlshow — Display Database, Table, and Column Information mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination my_print_defaults, my_print_defaults — Display Options from Option Files ndb_config, ndb_config — Extract NDB Configuration Information perror, perror — Explain Error Codes resolveip, resolveip — Resolve Hostname to IP Address or Vice
Versa resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols VERSION(), Information Functions vertical option mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server Vietnamese, MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets view restrictions, Restrictions on Views views, Views , Views , CREATE VIEW Syntax updatable, Views , CREATE VIEW Syntax VIEWS INFORMATION_SCHEMA table, The INFORMATION_SCHEMA VIEWS Table Views limitations, Restrictions on Views privileges, Restrictions on Views problems, Restrictions on Views virtual memory problems while compiling, Dealing with Problems Compiling MySQL Vision, Using Connector/ODBC with SunSystems Vision Visual Objects, Visual Objects Visual Studio, Building MySQL from Source Using CMake and Visual Studio Visual Studio Plugin, Connectors W wait option myisamchk, myisamchk General Options myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables mysql, mysql Options mysqladmin, mysqladmin — Client for Administering a MySQL Server wait-timeout option mysqlmanager, MySQL Instance Manager Command Options WEEK(), Date and Time Functions WEEKDAY(), Date and Time Functions WEEKOFYEAR(), Date and Time Functions Well-Known Binary format, Well-Known Binary (WKB) Format Well-Known Text format, Well-Known Text (WKT) Format WHERE, WHERE Clause Optimization with SHOW, The INFORMATION_SCHEMA Database , Extensions to SHOW Statements where option mysqldump, mysqldump — A Database Backup Program WHILE, WHILE Statement widths display, Data Types Wildcard character (%), Strings Wildcard character (_), Strings wildcards and LIKE, How MySQL Uses Indexes in mysql.columns_priv table, Access Control, Stage 2: Request Verification in mysql.db table, Access Control, Stage 2: Request Verification in mysql.host table, Access Control, Stage 2: Request Verification in mysql.procs_priv table, Access Control, Stage 2: Request Verification in mysql.tables_priv table, Access Control, Stage 2: Request Verification in mysql.user table, Access Control, Stage 1: Connection Verification Windows, MySQL Connector/ODBC , MySQL Connector/NET compiling on, Compiling MySQL Clients on Windows open issues, MySQL on Windows Compared to MySQL on Unix upgrading, Upgrading MySQL on Windows versus Unix, MySQL on Windows Compared to MySQL on Unix with-big-tables option, Typical configure Options configure, Typical configure Options with-debug option configure, Typical configure Options with-embedded-server option configure, Typical configure Options with-extra-charsets option configure, Typical configure Options with-unix-socket-path option configure, Typical configure Options Within(), Functions That Test Spatial Relationships Between Geometries without-server option, Typical configure Options configure, Typical configure Options WKB format, Well-Known Binary (WKB) Format WKT format, Well-Known Text (WKT) Format wrappers Eiffel, MySQL Eiffel Wrapper write access tmp, Problems Running mysql_install_db write_buffer_size myisamchk
variable, myisamchk General Options X X(), Point Functions X509/Certificate, Basic SSL Concepts XA BEGIN, XA Transaction SQL Syntax XA COMMIT, XA Transaction SQL Syntax XA PREPARE, XA Transaction SQL Syntax XA RECOVER, XA Transaction SQL Syntax XA ROLLBACK, XA Transaction SQL Syntax XA START, XA Transaction SQL Syntax XA transactions, XA Transactions transaction identifiers, XA Transaction SQL Syntax xid XA transaction identifier, XA Transaction SQL Syntax xml option mysql, mysql Options mysqldump, mysqldump — A Database Backup Program XOR bitwise, Bit Functions logical, Logical Operators Y Y(), Point Functions yaSSL, Using Secure Connections , Using SSL Connections Year 2000 compliance, Year 2000 Issues and Date Types Year 2000 issues, Year 2000 Issues and Date Types YEAR data type, Overview of Date and Time Types , The YEAR Type YEAR(), Date and Time Functions YEARWEEK(), Date and Time Functions Yen sign (Japanese), MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets Secure FTP (sFTP) Hosting
Alden Hosting offers Secure FTP (sFTP) on our
WEB 5 PLAN and our
WEB 6 PLAN .
At Alden Hosting we eat and breathe Secure FTP (sFTP)!
