Symbols
| A
| B
| C
| D
| E
| F
| G
| H
| I
| J
| K
| L
| M
| N
| O
| P
| Q
| R
| S
| T
| U
| V
| W
| X
| Y
Symbols
[
index top]
- ! (logical NOT), Logical Operators
- != (not equal), Comparison Functions and Operators
- ", Schema Object Names
- %, Arithmetic Operators
- % (modulo), Mathematical Functions
- % (wildcard character), Strings
- & (bitwise AND), Bit Functions
- && (logical AND), Logical Operators
- () (parentheses), Operator Precedence
- (Control-Z) \Z, Strings, LOAD DATA INFILE Syntax
- * (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
- --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
- --print-full-config option (ndb_mgmd), Command Options for ndb_mgmd
- --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
- -P option (ndb_mgmd), Command Options for ndb_mgmd
- -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
- <errortext>Table is full</errortext> error
- MySQL Cluster, MySQL 5.0 FAQ — MySQL Cluster
- = (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 default] (MySQL Cluster), Data Node Configuration Parameters
- [ndbd] (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, LOAD DATA INFILE Syntax
- \b (backspace), Strings, LOAD DATA INFILE Syntax
- \n (linefeed), Strings, LOAD DATA INFILE Syntax
- \n (newline), Strings, LOAD DATA INFILE Syntax
- \N (NULL), LOAD DATA INFILE Syntax
- \r (carriage return), Strings, LOAD DATA INFILE Syntax
- \t (tab), Strings, LOAD DATA INFILE Syntax
- \Z (Control-Z) ASCII 26, Strings, LOAD DATA INFILE Syntax
- \\ (escape), Strings
- ^ (bitwise XOR), Bit Functions
- _ (wildcard character), Strings
- _rowid, CREATE TABLE Syntax
- `, Schema Object Names
- | (bitwise OR), Bit Functions
- || (logical OR), Logical Operators
- ~, Bit Functions
A
[
index top]
- 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
- administrative programs, Overview of MySQL Programs
- AES_DECRYPT(), Encryption and Compression Functions
- AES_ENCRYPT(), Encryption and Compression Functions
- After create
- thread state, General Thread States
- 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, Schema Object 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
- allocating local table
- thread state, Delayed-Insert Thread States
- 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
- Analyzing
- thread state, General Thread States
- 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, MySQL Cluster Core Concepts
- API nodes (see SQL nodes)
- 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, 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
- AS/400, Installing MySQL on i5/OS
- 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
[
index top]
- backslash
- escape character, Literal Values
- backspace (\b), Strings, LOAD DATA INFILE Syntax
- backup identifiers
- native backup and restore, Using The Management Client to Create a Backup
- 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, Backup and Recovery
- 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
- big-tables option
- mysqld, Command Options
- 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 Dump
- thread command, Thread Command Values
- 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
- 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
[
index top]
- 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, LOAD DATA INFILE Syntax
- 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
- CEIL(), Mathematical Functions
- 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
- Change user
- thread command, Thread Command Values
- 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 master
- thread state, Replication Slave Connection Thread States
- 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
- Checking master version
- thread state, Replication Slave I/O Thread States
- Checking table
- thread state, General Thread States
- 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
- cleaning up
- thread state, General Thread States
- clear option
- mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
- clear-only option
- mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
- clearing
- caches, FLUSH Syntax
- client connection threads, How MySQL Uses Threads for Client Connections
- client programs, Overview of MySQL Programs
- building, Building Client Programs
- client tools, APIs and Libraries
- clients
- debugging, Debugging a MySQL Client
- threaded, How to Make a Threaded Client
- CLOSE, Cursor CLOSE Statement
- Close stmt
- thread command, Thread Command Values
- closing
- tables, How MySQL Opens and Closes Tables
- closing tables
- thread state, General Thread States
- cluster logs, Event Reports Generated in MySQL Cluster, Logging Management Commands
- Clustering (see MySQL Cluster)
- CLUSTERLOG commands (MySQL Cluster), Logging Management Commands
- CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS
- CMake, Building MySQL from the Standard Source Distribution
- 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, Schema Object 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
- mysql, mysql Options
- 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
- Committing events to binlog
- thread state, MySQL Cluster Thread States
- 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 MySQL 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
- prefix 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), MySQL Cluster Core Concepts
- Connect
- thread command, Thread Command Values
- Connect Out
- thread command, Thread Command Values
- 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
- Connecting to master
- thread state, Replication Slave I/O Thread States
- 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 (see MySQL Cluster)
- 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(), Mathematical Functions
- conventions
- typographical, Conventions Used in This Manual
- CONVERT, Cast Functions and Operators
- CONVERT TO, ALTER TABLE Syntax
- converting HEAP to MyISAM
- thread state, General Thread States
- CONVERT_TZ(), Date and Time Functions
- ConvexHull(), Spatial Operators
- copy option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- copy to tmp table
- thread state, General Thread States
- copying databases, Copying MySQL Databases to Another Machine
- copying tables, CREATE TABLE Syntax
- Copying to group table
- thread state, General Thread States
- Copying to tmp table
- thread state, General Thread States
- Copying to tmp table on disk
- thread state, General Thread States
- 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, Debugging a MySQL Server
- 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 DB
- thread command, Thread Command Values
- 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 delayed handler
- thread state, Delayed-Insert Thread States
- Creating index
- thread state, General Thread States
- Creating sort index
- thread state, General Thread States
- creating table
- thread state, General Thread States
- Creating table from master dump
- thread state, Replication Slave Connection Thread States
- Creating tmp table
- thread state, General Thread States
- 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
[
index top]
- Daemon
- thread command, Thread Command Values
- 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, MySQL Cluster Core 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
- NATIONAL VARCHAR, Overview of String Types
- NCHAR, Overview of String Types
- NUMERIC, Overview of Numeric Types
- NVARCHAR, Overview of String 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, INFORMATION_SCHEMA Tables
- 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, Backup and Recovery
- 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, Schema Object 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->trace, Debugging mysqld under gdb
- DBI/DBD interface, MySQL Perl API
- DBI_TRACE environment variable, Environment Variables, Debugging mysqld under gdb
- DBI_USER environment variable, Environment Variables
- DBUG package, The DBUG Package
- DEALLOCATE PREPARE, SQL Syntax for Prepared Statements
- Debug
- thread command, Thread Command Values
- 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
- mysqldump, mysqldump — A Database Backup Program
- debugging
- client, Debugging a MySQL Client
- server, Debugging a MySQL Server
- 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, Command-Line Options that Affect Option-File Handling
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- my_print_defaults, my_print_defaults — Display Options from Option Files
- defaults-file option, Command-Line Options that Affect Option-File Handling
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- 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, Command-Line Options that Affect Option-File Handling
- 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
- when ignored, INSERT Syntax
- Delayed insert
- thread command, Thread Command Values
- delayed inserts
- thread states, Delayed-Insert Thread States
- 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
- deleting from main table
- thread state, General Thread States
- deleting from reference tables
- thread state, General Thread States
- 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
- discard_or_import_tablespace
- thread state, General Thread States
- 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)
- DRBD licence, Distributed Replicated Block Device (DRBD)
- DROP DATABASE, DROP DATABASE Syntax
- Drop DB
- thread command, Thread Command Values
- 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
- dump-date option
- mysqldump, mysqldump — A Database Backup Program
- DUMPFILE, SELECT Syntax
- dynamic table characteristics, Dynamic Table Characteristics
E
[
index top]
- 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
- thread state, General Thread States
- 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 MySQL Programs
- MYSQL_HISTFILE, mysql Options
- MYSQL_HOST, Connecting to the MySQL Server
- MYSQL_PWD, Overview of MySQL Programs, Connecting to the MySQL Server
- MYSQL_TCP_PORT, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
- MYSQL_UNIX_PORT, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
- 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, Debugging mysqld under gdb
- 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, Debugging a MySQL Client
- 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, Overview of MySQL Programs, Setting Environment Variables, Causes of Access denied Errors
- list of, Environment Variables
- equal (=), Comparison Functions and Operators
- Equals(), Functions That Test Spatial Relationships Between Geometries
- Error
- thread command, Thread Command Values
- 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
- lost connection, Lost connection to MySQL server
- 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
- thread command, Thread Command Values
- EXECUTE, SQL Syntax for Prepared Statements
- execute option
- mysql, mysql Options
- 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
- Execution of init_command
- thread state, General Thread States
- 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, EXPLAIN Syntax
- 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, General Thread States
- 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
[
index top]
- 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
- thread command, Thread Command Values
- FETCH, Cursor FETCH Statement
- field
- changing, ALTER TABLE Syntax
- Field List
- thread command, Thread Command Values
- 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 Issues
- 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
- Finished reading one binlog; switching to next binlog
- thread state, Replication Master Thread States
- firewalls (software)
- and MySQL Cluster, MySQL Cluster Security and Networking Issues
- 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
- Flushing tables
- thread state, General Thread States
- 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
- freeing items
- thread state, General Thread States
- 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
- FULLTEXT initialization
- thread state, General Thread States
- 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
[
index top]
- 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
- using, Debugging mysqld under gdb
- 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?
- got handler lock
- thread state, Delayed-Insert Thread States
- got old table
- thread state, Delayed-Insert Thread States
- 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
[
index top]
- HANDLER, HANDLER Syntax
- Handlers, DECLARE Handlers
- handling
- errors, UDF Return Values and Error Handling
- Has read all relay log; waiting for the slave I/O thread to update it
- thread state, Replication Slave SQL Thread States
- Has sent all binlog to slave; waiting for binlog to be updated
- thread state, Replication Master Thread States
- 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 SQL Statements from Files
- 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, Mathematical 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 (MySQL Cluster), MySQL Cluster Security and Networking Issues
- 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
[
index top]
- i-am-a-dummy option
- mysql, mysql Options
- i5/OS, Installing MySQL on i5/OS
- IBM i5/OS, Installing MySQL on i5/OS
- icc
- and MySQL Cluster support>, Debugging and Porting MySQL
- 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, Schema Object Names
- case sensitivity, Identifier Case Sensitivity
- quoting, Schema Object 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, Schema Object 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, INFORMATION_SCHEMA Tables
- and security issues, MySQL Cluster and MySQL Privileges
- init
- thread state, General Thread States
- Init DB
- thread command, Thread Command Values
- init-file option
- mysqld, Command Options
- INNER JOIN, JOIN Syntax
- innochecksum, Overview of MySQL 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
- thread state, Delayed-Insert Thread States
- 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
- internationalization, Internationalization and Localization
- 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
- isamlog, Overview of MySQL 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
[
index top]
- 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
[
index top]
- 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
- thread command, Thread Command Values
- KILL, KILL Syntax
- Killed
- thread state, General Thread States
- Killing slave
- thread state, Replication Slave Connection Thread States
- 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
[
index top]
- 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([<replaceable>expr</replaceable>]), 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, Schema Object 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 Issues
- 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, LOAD DATA INFILE Syntax
- 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
- localization, Internationalization and Localization
- 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
- Locked
- thread state, General Thread States
- locking, System Factors and Startup Parameter Tuning
- external, Command Options, System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
- 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
- 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
- mysqldump, mysqldump — A Database Backup Program
- 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 and Variables
- 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 and Variables
- LOG10(), Mathematical Functions
- LOG2(), Mathematical Functions
- LogDestination, Defining the Management Server
- logging commands (MySQL Cluster), Logging Management Commands
- logging slow query
- thread state, General Thread States
- logical operators, Logical Operators
- login
- thread state, General Thread States
- LogLevelCheckpoint (MySQL Cluster configuration parameter), Defining Data Nodes
- LogLevelCongestion, 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, Defining Data Nodes
- LogLevelStartup, Defining Data Nodes
- LogLevelStatistic (MySQL Cluster configuration parameter), Defining Data Nodes
- Long Data
- thread command, Thread Command Values
- 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
- lost connection errors, Lost connection to MySQL server
- 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
[
index top]
- 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 MySQL Programs
- MAKE_SET(), String Functions
- make_win_bin_dist, Overview of MySQL 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 BitKeeper Repository, Overview of MySQL Programs
- Making temp file
- thread state, Replication Slave SQL Thread States
- malicious SQL statements
- and MySQL Cluster, MySQL Cluster and MySQL Privileges
- management node (MySQL Cluster)
- defined, MySQL Cluster Core 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 and Variables
- master-data option
- mysqldump, mysqldump — A Database Backup Program
- master-host option
- mysqld, Replication Startup Options and Variables
- master-info-file option
- mysqld, Replication Startup Options and Variables
- master-password option
- mysqld, Replication Startup Options and Variables
- master-port option
- mysqld, Replication Startup Options and Variables
- master-retry-count option
- mysqld, Replication Startup Options and Variables
- master-ssl option
- mysqld, Replication Startup Options and Variables
- master-ssl-ca option
- mysqld, Replication Startup Options and Variables
- master-ssl-capath option
- mysqld, Replication Startup Options and Variables
- master-ssl-cert option
- mysqld, Replication Startup Options and Variables
- master-ssl-cipher option
- mysqld, Replication Startup Options and Variables
- master-ssl-key option
- mysqld, Replication Startup Options and Variables
- master-user option
- mysqld, Replication Startup Options and Variables
- 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 and Variables
- MAXDB SQL mode, SQL Modes
- maximum memory used, mysqladmin — Client for Administering a MySQL Server
- maximums
- maximum columns per table, The Maximum Number of Columns Per Table
- 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, mysqladmin — Client for Administering a MySQL Server, How MySQL Uses Memory
- 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, INFORMATION_SCHEMA Tables
- method option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- methods
- locking, Internal Locking Methods
- mgmd (MySQL Cluster)
- defined, MySQL Cluster Core Concepts
- (see also management node (MySQL Cluster))
- 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 Issues
- MyISAM
- compressed tables, Compressed Table Characteristics
- row 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 MySQL 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 MySQL Programs
- myisampack, Overview of MySQL 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 MySQL 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 MySQL Programs
- auto-rehash option, mysql Options
- batch option, mysql Options
- character-sets-dir option, mysql Options
- column-names option, mysql Options
- comments 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
- "quick" configuration, Quick Test Setup of MySQL Cluster
- <errortext>Table is full</errortext> error, MySQL 5.0 FAQ — MySQL Cluster
- <foreignphrase>vs</foreignphrase> replication, MySQL 5.0 FAQ — MySQL Cluster
- administration, MySQL Cluster-Related Command Options for mysqld, Command Options for MySQL Cluster Processes, 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 INFORMATION_SCHEMA, MySQL Cluster and MySQL Privileges
- and IP addressing, Simple Multi-Computer How-To
- and MySQL privileges, MySQL Cluster and MySQL Privileges
- and MySQL root user, MySQL Cluster and MySQL Privileges, MySQL Cluster and MySQL Security Procedures
- and networking, Hardware, Software, and Networking
- and transactions, MySQL 5.0 FAQ — MySQL Cluster
- API node, MySQL Cluster Core 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, MySQL Cluster-Related Command Options for mysqld, Command Options for MySQL Cluster Processes, 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
- compiling with icc, Debugging and Porting MySQL
- concepts, MySQL Cluster Core 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, MySQL Cluster Core 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
- HostName parameter
- and security, MySQL Cluster Security and Networking Issues
- 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
- insecurity of communication protocols, MySQL Cluster Security and Networking Issues
- 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, MySQL Cluster Core 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 Cluster-Related Command Options for mysqld, MySQL Server Process Usage for MySQL Cluster
- 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
- and security, MySQL Cluster Security and Networking Issues
- 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, MySQL Cluster Core 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
- 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 <foreignphrase>vs</foreignphrase> TCP/IP, Understanding the Impact of Cluster Interconnects
- security, MySQL Cluster Security Issues, MySQL 5.0 FAQ — MySQL Cluster
- and firewalls, MySQL Cluster Security and Networking Issues
- and HostName parameter, MySQL Cluster Security and Networking Issues
- and network configuration, MySQL Cluster Security and Networking Issues
- and network ports, MySQL Cluster Security and Networking Issues
- and remote administration, MySQL Cluster Security and Networking Issues
- networking, MySQL Cluster Security and Networking Issues
- security procedures, MySQL Cluster and MySQL Security Procedures
- 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, MySQL Cluster Core 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 command, Commands in the MySQL Cluster Management Client
- start phases (summary), Summary of MySQL Cluster Start Phases
- starting, Quick Test Setup of MySQL Cluster
- starting and stopping, MySQL 5.0 FAQ — MySQL Cluster
- starting nodes, Initial Startup
- starting or restarting, Summary of MySQL Cluster Start Phases
- 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
- terminology, MySQL Cluster Glossary
- thread states, MySQL Cluster Thread States
- 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
- 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.0
- 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.0
- 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 privileges
- and MySQL Cluster, MySQL Cluster and MySQL Privileges
- mysql prompt command, mysql Commands
- MySQL server
- mysqld, The MySQL Server
- 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 system tables
- and MySQL Cluster, MySQL Cluster and MySQL Privileges
- 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 MySQL 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 MySQL 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 MySQL 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 MySQL 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 MySQL 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 MySQL 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 Cluster-Related Command Options for mysqld, MySQL Server Process Usage for MySQL Cluster
- 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
- big-tables option, Command 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 and Variables
- 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 and Variables
- low-priority-updates option, Command Options
- master-connect-retry option, Replication Startup Options and Variables
- master-host option, Replication Startup Options and Variables
- master-info-file option, Replication Startup Options and Variables
- master-password option, Replication Startup Options and Variables
- master-port option, Replication Startup Options and Variables
- master-retry-count option, Replication Startup Options and Variables
- master-ssl option, Replication Startup Options and Variables
- master-ssl-ca option, Replication Startup Options and Variables
- master-ssl-capath option, Replication Startup Options and Variables
- master-ssl-cert option, Replication Startup Options and Variables
- master-ssl-cipher option, Replication Startup Options and Variables
- master-ssl-key option, Replication Startup Options and Variables
- master-user option, Replication Startup Options and Variables
- max-binlog-dump-events option, Command Options
- max-relay-log-size option, Replication Startup Options and Variables
- memlock option, Command Options
- myisam-recover option, Command Options, MyISAM Startup Options
- MySQL server, The MySQL Server
- ndb-connectstring option, MySQL Cluster-Related Command Options for mysqld
- ndbcluster option, MySQL Cluster-Related Command Options for mysqld
- old-passwords option, Command Options, Security-Related mysqld Options
- old-style-user-limits option, Command 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 and Variables
- relay-log option, Replication Startup Options and Variables
- relay-log-index option, Replication Startup Options and Variables
- relay-log-info-file option, Replication Startup Options and Variables
- relay-log-purge option, Replication Startup Options and Variables
- relay-log-space-limit option, Replication Startup Options and Variables
- replicate-do-db option, Replication Startup Options and Variables
- replicate-do-table option, Replication Startup Options and Variables
- replicate-ignore-db option, Replication Startup Options and Variables
- replicate-ignore-table option, Replication Startup Options and Variables
- replicate-rewrite-db option, Replication Startup Options and Variables
- replicate-same-server-id option, Replication Startup Options and Variables
- replicate-wild-do-table option, Replication Startup Options and Variables
- replicate-wild-ignore-table option, Replication Startup Options and Variables
- report-host option, Replication Startup Options and Variables
- report-password option, Replication Startup Options and Variables
- report-port option, Replication Startup Options and Variables
- report-user option, Replication Startup Options and Variables
- role in MySQL Cluster (see SQL Node (MySQL Cluster))
- 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 and Variables
- 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, MySQL Cluster-Related Command Options for mysqld
- 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 and Variables
- 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 and Variables
- slave-net-timeout option, Replication Startup Options and Variables
- slave-skip-errors option, Replication Startup Options and Variables
- slave_compressed_protocol option, Replication Startup Options and Variables
- 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 MySQL 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
- debug-info 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
- dump-date 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
- log-error 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 MySQL Programs
- config-file option, mysqld_multi — Manage Multiple MySQL Servers
- defaults-extra-file option, mysqld_multi — Manage Multiple MySQL Servers
- defaults-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-defaults 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 MySQL 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
- skip-kill-mysqld 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 MySQL 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 MySQL 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 MySQL 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 MySQL 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 MySQL Programs
- mysql_create_db(), mysql_create_db()
- mysql_data_seek(), mysql_data_seek()
- MYSQL_DEBUG environment variable, Environment Variables, Overview of MySQL Programs, Debugging a MySQL Client
- 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 MySQL 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 MySQL Programs
- help option, mysql_find_rows — Extract SQL Statements from Files
- regexp option, mysql_find_rows — Extract SQL Statements from Files
- rows option, mysql_find_rows — Extract SQL Statements from Files
- skip-use-db option, mysql_find_rows — Extract SQL Statements from Files
- start_row option, mysql_find_rows — Extract SQL Statements from Files
- mysql_fix_extensions, Overview of MySQL Programs
- mysql_fix_privilege_tables, Overview of MySQL 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 MySQL 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, Overview of MySQL Programs, Connecting to the MySQL Server
- 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 MySQL Programs
- mysql_select_db(), mysql_select_db()
- mysql_server_end(), mysql_server_end()
- mysql_server_init(), mysql_server_init()
- mysql_setpermission, Overview of MySQL 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 MySQL 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, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
- 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 MySQL Programs
- MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
- mysql_upgrade, Overview of MySQL 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 MySQL 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 MySQL 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 MySQL 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
[
index top]
- named pipes, Selecting a MySQL Server Type, Testing The MySQL Installation
- named-commands option
- mysql, mysql Options
- names, Schema Object 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
- NATIONAL VARCHAR data type, Overview of String Types
- native backup and restore
- and management client, Using The Management Client to Create a Backup
- backup identifiers, Using The Management Client to Create a Backup
- 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 (see MySQL Cluster)
- FAQ, MySQL 5.0 FAQ — MySQL Cluster
- NDB tables
- and MySQL root user, MySQL Cluster and MySQL Privileges
- NDB utilities
- security issues, MySQL Cluster and MySQL Security Procedures
- ndb-connectstring option
- mysqld, MySQL Cluster-Related Command Options for mysqld
- ndb_config, ndb_config — Extract NDB Configuration Information
- ndbcluster option
- mysqld, MySQL Cluster-Related Command Options for mysqld
- ndbd (MySQL Cluster)
- defined, MySQL Cluster Core Concepts
- (see also data node (MySQL Cluster))
- 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, MySQL Cluster Core Concepts
- (see also management node (MySQL Cluster))
- 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
- network ports
- and MySQL Cluster, MySQL Cluster Security and Networking Issues
- 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, LOAD DATA INFILE Syntax
- 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, Command-Line Options that Affect Option-File Handling
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- 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, Defining Data Nodes
- calculating, Configuring Parameters for Local Checkpoints
- NoOfDiskPagesToDiskAfterRestartTUP, Defining Data Nodes
- calculating, Configuring Parameters for Local Checkpoints
- NoOfDiskPagesToDiskDuringRestartACC, Defining Data Nodes
- NoOfDiskPagesToDiskDuringRestartTUP, 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
- NOWAIT (START BACKUP command), Using The Management Client to Create a Backup
- 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, LOAD DATA INFILE Syntax
- 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
- NVARCHAR data type, Overview of String Types
O
[
index top]
- 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-style-user-limits option
- mysqld, Command 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, mysqladmin — Client for Administering a MySQL Server, How MySQL Opens and Closes Tables
- 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
- Opening master dump table
- thread state, Replication Slave Connection Thread States
- Opening mysql.ndb_apply_status
- thread state, MySQL Cluster Thread States
- Opening table
- thread state, General Thread States
- Opening tables
- thread state, General Thread States
- 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
- option modifiers, Program Option Modifiers
- 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 Issues
- 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
[
index top]
- packages
- list of, Packages that support MySQL
- 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, Make Your Data as Small as Possible, Replication FAQ
- 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 MySQL 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
- Ping
- thread command, Thread Command Values
- 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
- porting
- to other systems, Debugging and Porting MySQL
- 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
- configure, Typical configure Options
- mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
- Prepare
- thread command, Thread Command Values
- PREPARE, SQL Syntax for Prepared Statements
- XA transactions, XA Transaction SQL Syntax
- preparing
- thread state, General Thread States
- preview option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- primary key
- constraint, PRIMARY KEY and UNIQUE Index
Constraints
- deleting, ALTER TABLE Syntax
- PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax
- print-defaults option, Command-Line Options that Affect Option-File Handling
- 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
- lost connection errors, Lost connection to MySQL server
- 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
- Processing events
- thread state, MySQL Cluster Thread States
- Processing events from schema table
- thread state, MySQL Cluster Thread States
- Processlist
- thread command, Thread Command Values
- PROCESSLIST, SHOW PROCESSLIST Syntax
- PROFILING
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PROFILING Table
- program variables
- setting, Using Options to Set Program Variables
- program-development utilities, Overview of MySQL Programs
- programs
- administrative, Overview of MySQL Programs
- client, Overview of MySQL Programs, Building Client Programs
- crash-me, Designing Applications for Portability
- utility, Overview of MySQL 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, Summary of MySQL Cluster Start Phases
- Purging old relay logs
- thread state, General Thread States
- Python API, MySQL Python API
Q
[
index top]
- 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
- thread command, Thread Command Values
- Query Cache, The MySQL Query Cache
- query end
- thread state, General Thread States
- 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
- Queueing master event to the relay log
- thread state, Replication Slave I/O Thread States
- 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
- thread command, Thread Command Values
- 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, Schema Object Names
R
[
index top]
- 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 and Variables
- Reading event from the relay log
- thread state, Replication Slave SQL Thread States
- Reading from net
- thread state, General Thread States
- Reading master dump table data
- thread state, Replication Slave Connection Thread States
- read_buffer_size myisamchk variable, myisamchk General Options
- REAL data type, Overview of Numeric Types
- REAL_AS_FLOAT SQL mode, SQL Modes
- Rebuilding the index on master dump table
- thread state, Replication Slave Connection Thread States
- ReceiveBufferMemory, Cluster TCP/IP Connections
- reconfiguring, Dealing with Problems Compiling MySQL
- reconnect option
- mysql, mysql Options
- Reconnecting after a failed binlog dump request
- thread state, Replication Slave I/O Thread States
- Reconnecting after a failed master event read
- thread state, Replication Slave I/O Thread States
- 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
- Refresh
- thread command, Thread Command Values
- 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 SQL Statements from Files
- Register Slave
- thread command, Thread Command Values
- Registering slave on master
- thread state, Replication Slave I/O Thread States
- 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 and Variables
- relay-log-index option
- mysqld, Replication Startup Options and Variables
- relay-log-info-file option
- mysqld, Replication Startup Options and Variables
- relay-log-purge option
- mysqld, Replication Startup Options and Variables
- relay-log-space-limit option
- mysqld, Replication Startup Options and Variables
- 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
- remote administration (MySQL Cluster)
- and security issues, MySQL Cluster Security and Networking Issues
- remove option
- mysqlmanager, MySQL Instance Manager Command Options
- Removing duplicates
- thread state, General Thread States
- removing tmp table
- thread state, General Thread States
- rename
- thread state, General Thread States
- rename result table
- thread state, General Thread States
- RENAME TABLE, RENAME TABLE Syntax
- RENAME USER, RENAME USER Syntax
- renaming user accounts, RENAME USER Syntax
- Reopen tables
- thread state, General Thread States
- reordering
- columns, How to Change the Order of Columns in a Table
- Repair by sorting
- thread state, General Thread States
- Repair done
- thread state, General Thread States
- repair option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- repair options
- myisamchk, myisamchk Repair Options
- REPAIR TABLE, REPAIR TABLE Syntax
- Repair with keycache
- thread state, General Thread States
- repairing
- tables, How to Repair Tables
- REPEAT, REPEAT Statement
- REPEAT(), String Functions
- replace, Overview of MySQL 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 and Variables
- replicate-do-table option
- mysqld, Replication Startup Options and Variables
- replicate-ignore-db option
- mysqld, Replication Startup Options and Variables
- replicate-ignore-table option
- mysqld, Replication Startup Options and Variables
- replicate-rewrite-db option
- mysqld, Replication Startup Options and Variables
- replicate-same-server-id option
- mysqld, Replication Startup Options and Variables
- replicate-wild-do-table option
- mysqld, Replication Startup Options and Variables
- replicate-wild-ignore-table option
- mysqld, Replication Startup Options and Variables
- replication, Replication
- replication limitations, Replication Features and Issues
- replication master
- thread states, Replication Master Thread States
- replication masters
- statements, SQL Statements for Controlling Master Servers
- replication options, Replication Features and Issues
- replication slave
- thread states, Replication Slave I/O Thread States, Replication Slave SQL Thread States, Replication Slave Connection Thread States
- replication slaves
- statements, SQL Statements for Controlling Slave Servers
- report-host option
- mysqld, Replication Startup Options and Variables
- report-password option
- mysqld, Replication Startup Options and Variables
- report-port option
- mysqld, Replication Startup Options and Variables
- report-user option
- mysqld, Replication Startup Options and Variables
- 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
- Requesting binlog dump
- thread state, Replication Slave I/O Thread States
- REQUIRE GRANT option, GRANT Syntax
- reschedule
- thread state, Delayed-Insert Thread States
- reserved words, Reserved Words
- RESET MASTER, RESET MASTER Syntax
- RESET SLAVE, RESET SLAVE Syntax
- Reset stmt
- thread command, Thread Command Values
- resetmaster option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- resetslave option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- resolveip, Overview of MySQL 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 MySQL 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, RETURN Statement Syntax
- return (\r), Strings, LOAD DATA INFILE Syntax
- 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 back
- thread state, General Thread States
- 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 SQL Statements from Files
- 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
- RTS-threads, Comments about RTS Threads
- 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
[
index top]
- 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
- Saving state
- thread state, General Thread States
- 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) (see MySQL Cluster)
- 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
- Searching rows for update
- thread state, General Thread States
- 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
- securing a MySQL Cluster, MySQL Cluster and MySQL Security Procedures
- security
- against attackers, Making MySQL Secure Against Attackers
- and malicious SQL statements, MySQL Cluster and MySQL Privileges
- and NDB utilities, MySQL Cluster and MySQL Security Procedures
- security system, The MySQL Access Privilege System
- SEC_TO_TIME(), Date and Time Functions
- SELECT
- LIMIT, SELECT Syntax
- optimizing, Optimizing Queries with EXPLAIN, EXPLAIN Syntax
- 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
- Sending binlog event to slave
- thread state, Replication Master Thread States
- 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
- debugging, Debugging a MySQL Server
- disconnecting, Connecting to and Disconnecting from the Server
- restart, Unix Post-Installation Procedures
- shutdown, Unix Post-Installation Procedures
- signal handling, Server Response to Signals
- 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
- 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
- thread command, Thread Command Values
- 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
- thread state, General Thread States
- SHA(), Encryption and Compression Functions
- SHA1(), Encryption and Compression Functions
- shared memory transporter (see MySQL Cluster)
- 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 Syntax, SHOW CHARACTER SET Syntax
- SHOW COLLATION, SHOW Syntax, 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, INFORMATION_SCHEMA Tables, Extensions to SHOW Statements
- show-slave-auth-info option
- mysqld, Replication Startup Options and Variables
- show-table-type option
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- show-warnings option
- mysql, mysql Options
- Shutdown
- thread command, Thread Command Values
- 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
- Shutting down
- thread state, MySQL Cluster Thread States
- sigint-ignore option
- mysql, mysql Options
- SIGN(), Mathematical Functions
- signals
- server response, Server Response to Signals
- 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-kill-mysqld option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- 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, MySQL Cluster-Related Command Options for mysqld
- 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 and Variables
- 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 SQL Statements from Files
- slave-load-tmpdir option
- mysqld, Replication Startup Options and Variables
- slave-net-timeout option
- mysqld, Replication Startup Options and Variables
- slave-skip-errors option
- mysqld, Replication Startup Options and Variables
- slave_compressed_protocol option
- mysqld, Replication Startup Options and Variables
- Sleep
- thread command, Thread Command Values
- 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
- Sorting for group
- thread state, General Thread States
- Sorting for order
- thread state, General Thread States
- Sorting index
- thread state, General Thread States
- Sorting result
- thread state, General Thread States
- 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, MySQL Cluster Core 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, Using The Management Client to Create a Backup
- NOWAIT, Using The Management Client to Create a Backup
- WAIT COMPLETED, Using The Management Client to Create a Backup
- WAIT STARTED, 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
- starting slave
- thread state, Replication Slave Connection Thread States
- 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 SQL Statements from Files
- 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
- thread command, Thread Command Values
- statistics
- thread state, General Thread States
- 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 functions
- and INSERT DELAYED, INSERT Syntax
- 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()
- storing row into queue
- thread state, Delayed-Insert Thread States
- 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
- 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
- Syncing ndb table schema operation and binlog
- thread state, MySQL Cluster Thread States
- 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 lock
- thread state, General Thread States
- 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
[
index top]
- tab (\t), Strings, LOAD DATA INFILE Syntax
- 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 Dump
- thread command, Thread Command Values
- table is full, SET Syntax, The table is full
- Table lock
- thread state, General Thread States
- 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, Schema Object 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 cache, How MySQL Uses Threads for Client Connections
- thread command
- Binlog Dump, Thread Command Values
- Change user, Thread Command Values
- Close stmt, Thread Command Values
- Connect, Thread Command Values
- Connect Out, Thread Command Values
- Create DB, Thread Command Values
- Daemon, Thread Command Values
- Debug, Thread Command Values
- Delayed insert, Thread Command Values
- Drop DB, Thread Command Values
- Error, Thread Command Values
- Execute, Thread Command Values
- Fetch, Thread Command Values
- Field List, Thread Command Values
- Init DB, Thread Command Values
- Kill, Thread Command Values
- Long Data, Thread Command Values
- Ping, Thread Command Values
- Prepare, Thread Command Values
- Processlist, Thread Command Values
- Query, Thread Command Values
- Quit, Thread Command Values
- Refresh, Thread Command Values
- Register Slave, Thread Command Values
- Reset stmt, Thread Command Values
- Set option, Thread Command Values
- Shutdown, Thread Command Values
- Sleep, Thread Command Values
- Statistics, Thread Command Values
- Table Dump, Thread Command Values
- Time, Thread Command Values
- thread commands, Thread Command Values
- thread packages
- differences between, Differences Between Thread Packages
- thread state
- After create, General Thread States
- allocating local table, Delayed-Insert Thread States
- Analyzing, General Thread States
- Changing master, Replication Slave Connection Thread States
- Checking master version, Replication Slave I/O Thread States
- Checking table, General Thread States
- cleaning up, General Thread States
- closing tables, General Thread States
- Committing events to binlog, MySQL Cluster Thread States
- Connecting to master, Replication Slave I/O Thread States
- converting HEAP to MyISAM, General Thread States
- copy to tmp table, General Thread States
- Copying to group table, General Thread States
- Copying to tmp table, General Thread States
- Copying to tmp table on disk, General Thread States
- Creating delayed handler, Delayed-Insert Thread States
- Creating index, General Thread States
- Creating sort index, General Thread States
- creating table, General Thread States
- Creating table from master dump, Replication Slave Connection Thread States
- Creating tmp table, General Thread States
- deleting from main table, General Thread States
- deleting from reference tables, General Thread States
- discard_or_import_tablespace, General Thread States
- end, General Thread States
- Execution of init_command, General Thread States
- Finished reading one binlog; switching to next binlog, Replication Master Thread States
- Flushing tables, General Thread States
- freeing items, General Thread States
- FULLTEXT initialization, General Thread States
- got handler lock, Delayed-Insert Thread States
- got old table, Delayed-Insert Thread States
- Has read all relay log; waiting for the slave I/O thread to update it, Replication Slave SQL Thread States
- Has sent all binlog to slave; waiting for binlog to be updated, Replication Master Thread States
- init, General Thread States
- insert, Delayed-Insert Thread States
- Killed, General Thread States
- Killing slave, Replication Slave Connection Thread States
- Locked, General Thread States
- logging slow query, General Thread States
- login, General Thread States
- Making temp file, Replication Slave SQL Thread States
- Opening master dump table, Replication Slave Connection Thread States
- Opening mysql.ndb_apply_status, MySQL Cluster Thread States
- Opening table, General Thread States
- Opening tables, General Thread States
- preparing, General Thread States
- Processing events, MySQL Cluster Thread States
- Processing events from schema table, MySQL Cluster Thread States
- Purging old relay logs, General Thread States
- query end, General Thread States
- Queueing master event to the relay log, Replication Slave I/O Thread States
- Reading event from the relay log, Replication Slave SQL Thread States
- Reading from net, General Thread States
- Reading master dump table data, Replication Slave Connection Thread States
- Rebuilding the index on master dump table, Replication Slave Connection Thread States
- Reconnecting after a failed binlog dump request, Replication Slave I/O Thread States
- Reconnecting after a failed master event read, Replication Slave I/O Thread States
- Registering slave on master, Replication Slave I/O Thread States
- Removing duplicates, General Thread States
- removing tmp table, General Thread States
- rename, General Thread States
- rename result table, General Thread States
- Reopen tables, General Thread States
- Repair by sorting, General Thread States
- Repair done, General Thread States
- Repair with keycache, General Thread States
- Requesting binlog dump, Replication Slave I/O Thread States
- reschedule, Delayed-Insert Thread States
- Rolling back, General Thread States
- Saving state, General Thread States
- Searching rows for update, General Thread States
- Sending binlog event to slave, Replication Master Thread States
- setup, General Thread States
- Shutting down, MySQL Cluster Thread States
- Sorting for group, General Thread States
- Sorting for order, General Thread States
- Sorting index, General Thread States
- Sorting result, General Thread States
- starting slave, Replication Slave Connection Thread States
- statistics, General Thread States
- storing row into queue, Delayed-Insert Thread States
- Syncing ndb table schema operation and binlog, MySQL Cluster Thread States
- System lock, General Thread States
- Table lock, General Thread States
- update, Delayed-Insert Thread States
- Updating, General Thread States
- updating main table, General Thread States
- updating reference tables, General Thread States
- upgrading lock, Delayed-Insert Thread States
- User lock, General Thread States
- waiting for delay_list, Delayed-Insert Thread States
- Waiting for event from ndbcluster, MySQL Cluster Thread States
- Waiting for first event from ndbcluster, MySQL Cluster Thread States
- waiting for handler insert, Delayed-Insert Thread States
- waiting for handler lock, Delayed-Insert Thread States
- waiting for handler open, Delayed-Insert Thread States
- Waiting for INSERT, Delayed-Insert Thread States
- Waiting for master to send event, Replication Slave I/O Thread States
- Waiting for master update, Replication Slave I/O Thread States
- Waiting for ndbcluster binlog update to reach current position, MySQL Cluster Thread States
- Waiting for ndbcluster to start, MySQL Cluster Thread States
- Waiting for schema epoch, MySQL Cluster Thread States
- Waiting for slave mutex on exit, Replication Slave I/O Thread States, Replication Slave SQL Thread States
- Waiting for table, General Thread States
- Waiting for tables, General Thread States
- Waiting for the next event in relay log, Replication Slave SQL Thread States
- Waiting for the slave SQL thread to free enough relay log space, Replication Slave I/O Thread States
- Waiting on cond, General Thread States
- Waiting to finalize termination, Replication Master Thread States
- Waiting to reconnect after a failed binlog dump request, Replication Slave I/O Thread States
- Waiting to reconnect after a failed master event read, Replication Slave I/O Thread States
- Writing to net, General Thread States
- thread states
- delayed inserts, Delayed-Insert Thread States
- general, General Thread States
- MySQL Cluster, MySQL Cluster Thread States
- replication master, Replication Master Thread States
- replication slave, Replication Slave I/O Thread States, Replication Slave SQL Thread States, Replication Slave Connection Thread States
- 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
- RTS, Comments about RTS Threads
- Time
- thread command, Thread Command Values
- 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 DBI method, Debugging mysqld under gdb
- 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
- and INSERT DELAYED, INSERT Syntax
- 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
[
index top]
- 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
- unique ID, How to Get the Unique ID for the Last Inserted Row
- unique key
- constraint, PRIMARY KEY and UNIQUE Index
Constraints
- 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
- thread state, Delayed-Insert Thread States
- 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
- Updating
- thread state, General Thread States
- updating main table
- thread state, General Thread States
- updating reference tables
- thread state, General Thread States
- 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 ¤t-series;, Upgrading from MySQL 4.1 to 5.0
- upgrading lock
- thread state, Delayed-Insert Thread States
- upgrading tables
- ISAM, Upgrading from MySQL 4.1 to 5.0
- RAID, 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 lock
- thread state, General Thread States
- 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
- utilities
- program-development, Overview of MySQL Programs
- utility programs, Overview of MySQL Programs
- UUID(), Miscellaneous Functions
V
[
index top]
- 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
- environment, Overview of MySQL Programs
- 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 the Standard Source Distribution
- Visual Studio Plugin, Connectors
W
[
index top]
- WAIT COMPLETED (START BACKUP command), Using The Management Client to Create a Backup
- 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 STARTED (START BACKUP command), Using The Management Client to Create a Backup
- wait-timeout option
- mysqlmanager, MySQL Instance Manager Command Options
- waiting for delay_list
- thread state, Delayed-Insert Thread States
- Waiting for event from ndbcluster
- thread state, MySQL Cluster Thread States
- Waiting for first event from ndbcluster
- thread state, MySQL Cluster Thread States
- waiting for handler insert
- thread state, Delayed-Insert Thread States
- waiting for handler lock
- thread state, Delayed-Insert Thread States
- waiting for handler open
- thread state, Delayed-Insert Thread States
- Waiting for INSERT
- thread state, Delayed-Insert Thread States
- Waiting for master to send event
- thread state, Replication Slave I/O Thread States
- Waiting for master update
- thread state, Replication Slave I/O Thread States
- Waiting for ndbcluster binlog update to reach current position
- thread state, MySQL Cluster Thread States
- Waiting for ndbcluster to start
- thread state, MySQL Cluster Thread States
- Waiting for schema epoch
- thread state, MySQL Cluster Thread States
- Waiting for slave mutex on exit
- thread state, Replication Slave I/O Thread States, Replication Slave SQL Thread States
- Waiting for table
- thread state, General Thread States
- Waiting for tables
- thread state, General Thread States
- Waiting for the next event in relay log
- thread state, Replication Slave SQL Thread States
- Waiting for the slave SQL thread to free enough relay log space
- thread state, Replication Slave I/O Thread States
- Waiting on cond
- thread state, General Thread States
- Waiting to finalize termination
- thread state, Replication Master Thread States
- Waiting to reconnect after a failed binlog dump request
- thread state, Replication Slave I/O Thread States
- Waiting to reconnect after a failed master event read
- thread state, Replication Slave I/O Thread States
- 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, INFORMATION_SCHEMA Tables, 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
- Writing to net
- thread state, General Thread States
X
[
index top]
- 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
[
index top]
- 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