| |
Symbols
- ! (logical NOT), Logical Operators
- != (not equal), Comparison Functions and Operators
- ", Database, Table, Index, Column, and Alias Names
- % (modulo), Mathematical Functions
- % (wildcard character), Strings
- & (bitwise AND), Bit Functions
- && (logical AND), Logical Operators
- () (parentheses), Operator Precedence
- (Control-Z) \Z, Strings
- * (multiplication), Arithmetic Operators
- + (addition), Arithmetic Operators
- - (subtraction), Arithmetic Operators
- - (unary minus), Arithmetic Operators
- --password option, Keeping Your Password Secure
- -p option, Keeping Your Password Secure
- .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
- < (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
- = (equal), Comparison Functions and Operators
- > (greater than), Comparison Functions and Operators
- >= (greater than or equal), Comparison Functions and Operators
- >> (right shift), Bit Functions
- \" (double quote), Strings
- \' (single quote), Strings
- \0 (ASCII 0), Strings
- \b (backspace), Strings
- \n (linefeed), Strings
- \n (newline), Strings
- \r (carriage return), Strings
- \t (tab), Strings
- \Z (Control-Z) ASCII 26, Strings
- \\ (escape), Strings
- ^ (bitwise XOR), Bit Functions
- _ (wildcard character), Strings
- _rowid, CREATE TABLE Syntax
- `, Database, Table, Index, Column, and Alias Names
- | (bitwise OR), Bit Functions
- || (logical OR), Logical Operators
- ~, Bit Functions
A
- 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
- Access program, Programs Known to Work With MyODBC
- 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
- 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 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
- ADO program, Programs Known to Work With MyODBC
- AES_DECRYPT(), Encryption and Compression Functions
- AES_ENCRYPT(), Encryption and Compression Functions
- age
- calculating, Date Calculations
- alias, Problems with Column Aliases
- alias names
- case sensitivity, Identifier Case Sensitivity
- aliases
- for expressions, GROUP BY with Hidden Fields
- for tables, SELECT Syntax
- in GROUP BY clauses, GROUP BY with Hidden Fields
- names, Database, Table, Index, Column, and Alias Names
- on expressions, SELECT Syntax
- ALL, SELECT Syntax
- 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
- all-tablespaces option
- mysqldump, mysqldump — A Database Backup Program
- allow-keywords option
- mysqldump, mysqldump — A Database Backup Program
- allow-suspicious-udfs option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- allowold option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- ALLOW_INVALID_DATES SQL mode, The Server SQL Mode
- ALTER COLUMN, ALTER TABLE Syntax
- ALTER DATABASE, ALTER DATABASE Syntax
- ALTER FUNCTION, ALTER PROCEDURE and ALTER FUNCTION Syntax
- ALTER PROCEDURE, ALTER PROCEDURE and ALTER FUNCTION Syntax
- ALTER SCHEMA, ALTER DATABASE Syntax
- ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE
- ALTER VIEW, ALTER VIEW Syntax
- altering
- database, ALTER DATABASE Syntax
- schema, ALTER DATABASE Syntax
- analyze option
- myisamchk, Other myisamchk Options
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- ANALYZE TABLE, ANALYZE TABLE Syntax
- AND
- bitwise, Bit Functions
- logical, Logical Operators
- 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, mysqld Command Options
- ANSI SQL mode, The Server SQL Mode
- ANSI_QUOTES SQL mode, The Server SQL Mode
- answering questions
- etiquette, Guidelines for Using the Mailing Lists
- Apache, Using MySQL with Apache
- API's
- list of, Packages that support MySQL
- APIs, APIs and Libraries
- Perl, MySQL Perl API
- approximate-value literals, Precision Math
- ARCHIVE storage engine, Storage Engines and Table Types, The ARCHIVE Storage Engine
- ARCHIVE table type, Storage Engines and Table Types, The ARCHIVE Storage Engine
- Area(), Polygon Functions, MultiPolygon Functions
- argument processing, UDF Argument Processing
- arithmetic expressions, Arithmetic Operators
- arithmetic functions, Bit Functions
- AS, SELECT Syntax, JOIN Syntax
- AsBinary(), Geometry Format Conversion Functions
- ASCII(), String Functions
- ASIN(), Mathematical Functions
- AsText(), Geometry Format Conversion Functions
- ATAN(), Mathematical Functions
- ATAN2(), Mathematical Functions
- attackers
- security against, Making MySQL Secure Against Attackers
- auto-generate-sql option
- mysqlslap, mysqlslap — Load Emulation Client
- AUTO-INCREMENT
- ODBC, How to Get the Value of an AUTO_INCREMENT Column in ODBC
- auto-rehash option
- mysql, mysql Options
- auto-repair option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- autoclose option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- AUTO_INCREMENT, Using AUTO_INCREMENT
- and NULL values, Problems with NULL Values
- AVG(), GROUP BY (Aggregate) Functions
- AVG(DISTINCT), GROUP BY (Aggregate) Functions
B
- backslash
- escape character, Literal Values
- backspace (\b), Strings
- backup option
- myisamchk, myisamchk Repair Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- BACKUP TABLE, BACKUP TABLE Syntax
- backups, Database Backups
- database, BACKUP TABLE Syntax
- base64-output option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- basedir option
- mysqld, 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
- BDB storage engine, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine
- BDB table type, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine
- BDB tables, Transactions and Atomic Operations
- bdb-data-direct option
- mysqld, BDB Startup Options
- bdb-home option
- mysqld, BDB Startup Options
- bdb-lock-detect option
- mysqld, BDB Startup Options
- bdb-log-direct 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 and Table Types, The BDB (BerkeleyDB) Storage Engine
- BerkeleyDB table type, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine
- BETWEEN ... AND, Comparison Functions and Operators
- 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 on Other Unix-Like Systems
- on Linux, Linux Binary Distribution Notes
- binary log, The Binary Log
- bind-address option
- mysqld, mysqld Command Options
- binlog-do-db option
- mysqld, The Binary Log
- binlog-format option
- mysqld, mysqld Command Options
- binlog-ignore-db option
- mysqld, The Binary Log
- binlog-row-event-max-size option
- mysqld, mysqld Command Options
- 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 and Table Types, The BLACKHOLE Storage Engine
- BLACKHOLE table type, Storage Engines and Table Types, 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, mysqld Command Options
- Borland Builder 4 program, Programs Known to Work With MyODBC
- Borland C++ compiler, Borland C++
- Boundary(), General Geometry Functions
- brackets
- square, Data Types
- brief option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- buffer sizes
- client, APIs and Libraries
- mysqld server, Tuning Server Parameters
- Buffer(), Spatial Operators
- bug reports
- criteria for, How to Report Bugs or Problems
- bugs
- known, Known Issues in MySQL
- reporting, How to Report Bugs or Problems
- bugs database, How to Report Bugs or Problems
- bugs.mysql.com, How to Report Bugs or Problems
- building
- client programs, Building Client Programs
C
- C API
- data types, MySQL C API
- functions, C API Function Overview
- linking problems, Problems Linking with the C API
- C Prepared statement API
- functions, C API Prepared Statement Function Overview
- C++ APIs, MySQL C++ API
- C++ Builder, Programs Known to Work With MyODBC
- C++ compiler
- gcc, Typical configure Options
- C++ compiler cannot create executables, Dealing with Problems Compiling MySQL
- C:\my.cnf file, Using Client Programs in a Multiple-Server Environment
- CACHE INDEX, CACHE INDEX Syntax
- caches
- clearing, FLUSH Syntax
- calculating
- dates, Date Calculations
- calendar, What Calendar Is Used By MySQL?
- CALL, CALL Statement Syntax
- calling sequences for aggregate functions
- UDF, UDF Calling Sequences for Aggregate Functions
- calling sequences for simple functions
- UDF, UDF Calling Sequences for Simple Functions
- can't create/write to file, Can't create/write to file
- carriage return (\r), Strings
- CASE, Control Flow Functions, CASE Statement
- case sensitivity
- in access checking, How the Privilege System Works
- in identifiers, Identifier Case Sensitivity
- in names, Identifier Case Sensitivity
- in searches, Case Sensitivity in Searches
- in string comparisons, String Comparison Functions
- case-sensitivity
- of database names, MySQL Extensions to Standard SQL
- of table names, MySQL Extensions to Standard SQL
- CAST, Cast Functions and Operators
- cast functions, Cast Functions and Operators
- cast operators, Cast Functions and Operators
- casts, Type Conversion in Expression Evaluation, Comparison Functions and Operators, Cast Functions and Operators
- CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- cc1plus problems, Dealing with Problems Compiling MySQL
- CEILING(), Mathematical Functions
- Centroid(), MultiPolygon Functions
- CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CHANGE MASTER TO, CHANGE MASTER TO Syntax
- ChangeLog, MySQL Change History
- changes
- log, MySQL Change History
- MySQL 5.1, Changes in release 5.1.x (Development)
- changes to privileges, Access Control, Stage 2: Request Verification
- changing
- column, ALTER TABLE Syntax
- column order, How to Change the Order of Columns in a Table
- field, ALTER TABLE Syntax
- table, ALTER TABLE Syntax, Problems with ALTER TABLE
- changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Unix Socket File
- CHAR data type, Overview of String Types, String Types
- CHAR VARYING data type, Overview of String Types
- CHAR(), String Functions
- CHARACTER data type, Overview of String Types
- character sets, Typical configure Options, The Character Set Used for Data and Sorting
- adding, Adding a New Character Set
- Character sets, Character Set Support
- CHARACTER VARYING data type, Overview of String Types
- character-set-client-handshake option
- mysqld, mysqld Command Options
- character-set-filesystem option
- mysqld, mysqld Command Options
- character-set-server option
- mysqld, 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, 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(), Information Functions
- CHAR_LENGTH(), String Functions
- check option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- check options
- myisamchk, myisamchk Check Options
- CHECK TABLE, CHECK TABLE Syntax
- check-only-changed option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- check-upgrade option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- checking
- tables for errors, How to Check MyISAM Tables for Errors
- checkpoint option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- checksum errors, Solaris Notes
- CHECKSUM TABLE, CHECKSUM TABLE Syntax
- Chinese, Case Sensitivity in Searches
- choosing
- a MySQL version, Choosing Which MySQL Distribution to Install
- choosing types, Choosing the Right Type for a Column
- chroot option
- mysqld, mysqld Command Options
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- clearing
- caches, FLUSH Syntax
- client programs, Overview of Client and Utility 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
- closing
- tables, How MySQL Opens and Closes Tables
- COALESCE(), Comparison Functions and Operators
- COERCIBILITY(), Information Functions
- ColdFusion program, Programs Known to Work With MyODBC
- collating
- strings, String Collating Support
- COLLATION(), Information Functions
- collation-server option
- mysqld, mysqld Command Options
- COLLATIONS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table
- COLLATION_CHARACTER_SET_APPLICABILITY
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- column
- changing, ALTER TABLE Syntax
- types, Data Types
- column comments, CREATE TABLE Syntax
- column names
- case sensitivity, Identifier Case Sensitivity
- column-names option
- mysql, mysql Options
- columns
- changing, How to Change the Order of Columns in a Table
- indexes, Column Indexes
- names, Database, Table, Index, Column, and Alias Names
- other types, Using Data Types from Other Database Engines
- selecting, Selecting Particular Columns
- storage requirements, Data Type Storage Requirements
- COLUMNS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table
- columns option
- mysqlimport, mysqlimport — A Data Import Program
- COLUMN_PRIVILEGES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- comma-separate values data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
- command options
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqld, mysqld Command Options
- command syntax, Conventions Used in This Manual
- command-line history
- mysql, mysql Options
- commands
- for binary distribution, Installing MySQL on Other Unix-Like Systems
- commands out of sync, Commands out of sync
- Comment syntax, Comment Syntax
- comments
- adding, Comment Syntax
- starting, '--' as the Start of a Comment
- comments option
- mysqldump, mysqldump — A Database Backup Program
- COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
- XA transactions, XA Transaction SQL Syntax
- commit option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- compact option
- mysqldump, mysqldump — A Database Backup Program
- comparison operators, Comparison Functions and Operators
- compatibility
- between MySQL versions, Upgrading from MySQL 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 Compliance
- composite subpartitioning, Subpartitioning
- 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
- mysqlslap, mysqlslap — Load Emulation Client
- COMPRESS(), Encryption and Compression Functions
- compressed tables, Compressed Table Characteristics
- CONCAT(), String Functions
- CONCAT_WS(), String Functions
- concurrency option
- mysqlslap, mysqlslap — Load Emulation Client
- concurrent inserts, Locking Methods, Concurrent Inserts
- Conditions, DECLARE Conditions
- config-file option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- config.cache, Dealing with Problems Compiling MySQL
- config.cache file, Dealing with Problems Compiling MySQL
- configuration files, Causes of Access denied Errors
- configuration options, Typical configure Options
- configure
- running after prior invocation, Dealing with Problems Compiling MySQL
- configure option
- --with-charset, Typical configure Options
- --with-collation, Typical configure Options
- --with-extra-charsets, Typical configure Options
- --with-low-memory, Dealing with Problems Compiling MySQL
- configure script, Typical configure Options
- connecting
- remotely with SSH, Connecting to MySQL Remotely from Windows with SSH
- to the server, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
- verification, Access Control, Stage 1: Connection Verification
- connection
- aborted, Communication Errors and Aborted Connections
- CONNECTION_ID(), Information Functions
- Connector/JDBC, Connectors
- Connector/ODBC, Connectors, MySQL Connector/ODBC
- reporting problems, How to Report MyODBC Problems or Bugs
- Connectors
- MySQL, Connectors
- connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
- console option
- mysqld, mysqld Command Options
- constant table, Optimizing Queries with EXPLAIN, WHERE Clause Optimization
- constraints, How MySQL Deals with Constraints
- CONSTRAINTS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- Contains(), Functions That Test Spatial Relationships Between Geometries
- contributing companies
- list of, Supporters of MySQL
- contributors
- list of, Contributors to MySQL
- control access, Access Control, Stage 1: Connection Verification
- control flow functions, Control Flow Functions
- CONV(), String Functions
- conventions
- typographical, Conventions Used in This Manual
- CONVERT, Cast Functions and Operators
- CONVERT TO, ALTER TABLE Syntax
- CONVERT_TZ(), Date and Time Functions
- ConvexHull(), Spatial Operators
- copy option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- copying databases, Copying MySQL Databases to Another Machine
- copying tables, CREATE TABLE Syntax
- core-file option
- mysqld, mysqld Command Options
- core-file-size option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- correct-checksum option
- myisamchk, myisamchk Repair Options
- COS(), Mathematical Functions
- COT(), Mathematical Functions
- count option
- 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 FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax, CREATE FUNCTION Syntax
- CREATE INDEX, CREATE INDEX Syntax
- create option
- mysqlslap, mysqlslap — Load Emulation Client
- 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
- create-schema option
- mysqlslap, mysqlslap — Load Emulation Client
- creating
- bug reports, How to Report Bugs or Problems
- database, CREATE DATABASE Syntax
- databases, Creating and Using a Database
- default startup options, Using Option Files
- function, CREATE FUNCTION Syntax
- schema, CREATE DATABASE Syntax
- tables, Creating a Table
- creating user accounts, CREATE USER Syntax
- CROSS JOIN, JOIN Syntax
- Crosses(), Functions That Test Spatial Relationships Between Geometries
- CR_SERVER_GONE_ERROR, MySQL server has gone away
- CR_SERVER_LOST_ERROR, MySQL server has gone away
- CSV data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
- csv option
- mysqlslap, mysqlslap — Load Emulation Client
- CSV storage engine, Storage Engines and Table Types, The CSV Storage Engine
- CSV table type, Storage Engines and Table Types, The CSV Storage Engine
- CURDATE(), Date and Time Functions
- CURRENT_DATE, Date and Time Functions
- CURRENT_TIME, Date and Time Functions
- CURRENT_TIMESTAMP, Date and Time Functions
- CURRENT_USER(), Information Functions
- Cursors, Cursors
- CURTIME(), Date and Time Functions
- customers
- of MySQL, What We Have Used MySQL For
- CXX environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CXXFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
D
- data
- character sets, The Character Set Used for Data and Sorting
- loading into tables, Loading Data into a Table
- retrieving, Retrieving Information from a Table
- size, Make Your Data as Small as Possible
- data type
- BIGINT, Overview of Numeric Types
- BINARY, Overview of String Types, The BINARY and VARBINARY Types
- BIT, Overview of Numeric Types
- BLOB, Overview of String Types, The BLOB and TEXT Types
- BOOL, Overview of Numeric Types, Using Data Types from Other Database Engines
- BOOLEAN, Overview of Numeric Types, Using Data Types from Other Database Engines
- CHAR, Overview of String Types, String Types
- CHAR VARYING, Overview of String Types
- CHARACTER, Overview of String Types
- CHARACTER VARYING, Overview of String Types
- DATE, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- DATETIME, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- DEC, Overview of Numeric Types
- DECIMAL, Overview of Numeric Types, Precision Math
- DOUBLE, Overview of Numeric Types
- DOUBLE PRECISION, Overview of Numeric Types
- ENUM, Overview of String Types, The ENUM Type
- FIXED, Overview of Numeric Types
- FLOAT, Overview of Numeric Types
- GEOMETRY, MySQL Spatial Data Types
- GEOMETRYCOLLECTION, MySQL Spatial Data Types
- INT, Overview of Numeric Types
- INTEGER, Overview of Numeric Types
- LINESTRING, MySQL Spatial Data Types
- LONG, The BLOB and TEXT Types
- LONGBLOB, Overview of String Types
- LONGTEXT, Overview of String Types
- MEDIUMBLOB, Overview of String Types
- MEDIUMINT, Overview of Numeric Types
- MEDIUMTEXT, Overview of String Types
- MULTILINESTRING, MySQL Spatial Data Types
- MULTIPOINT, MySQL Spatial Data Types
- MULTIPOLYGON, MySQL Spatial Data Types
- NATIONAL CHAR, Overview of String Types
- NCHAR, Overview of String Types
- NUMERIC, Overview of Numeric Types
- POINT, MySQL Spatial Data Types
- POLYGON, MySQL Spatial Data Types
- REAL, Overview of Numeric Types
- SET, Overview of String Types, The SET Type
- SMALLINT, Overview of Numeric Types
- TEXT, Overview of String Types, The BLOB and TEXT Types
- TIME, Overview of Date and Time Types, The TIME Type
- TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- TINYBLOB, Overview of String Types
- TINYINT, Overview of Numeric Types
- TINYTEXT, Overview of String Types
- VARBINARY, Overview of String Types, The BINARY and VARBINARY Types
- VARCHAR, Overview of String Types, String Types
- VARCHARACTER, Overview of String Types
- YEAR, Overview of Date and Time Types, The YEAR Type
- data types, Data Types
- C API, MySQL C API
- overview, Data Type Overview
- data-file-length option
- myisamchk, myisamchk Repair Options
- database
- altering, ALTER DATABASE Syntax
- creating, CREATE DATABASE Syntax
- deleting, DROP DATABASE Syntax
- database design, Design Choices
- Database information
- obtaining, SHOW Syntax
- database metadata, The INFORMATION_SCHEMA Database
- database names
- case sensitivity, Identifier Case Sensitivity
- case-sensitivity, MySQL Extensions to Standard SQL
- database option
- mysql, mysql Options
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- DATABASE(), Information Functions
- databases
- backups, Database Backups
- copying, Copying MySQL Databases to Another Machine
- creating, Creating and Using a Database
- defined, Overview of the MySQL Database Management System
- information about, Getting Information About Databases and Tables
- names, Database, Table, Index, Column, and Alias Names
- replicating, Replication
- selecting, Creating and Selecting a Database
- symbolic links, Using Symbolic Links for Databases on Unix
- using, Creating and Using a Database
- databases option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- mysqldump, mysqldump — A Database Backup Program
- datadir option
- mysqld, mysqld Command Options
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- DataJunction, Programs Known to Work With MyODBC
- 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 Compliance
- date types, Data Type Storage Requirements
- Y2K issues, Y2K 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, The Server SQL Mode
- DBI interface, MySQL Perl API
- DBI->quote, Strings
- DBI->trace, Debugging mysqld under gdb
- DBI/DBD interface, MySQL Perl API
- DBI_TRACE environment variable, Debugging mysqld under gdb, Environment Variables
- DBI_USER environment variable, Environment Variables
- DBUG package, The DBUG Package
- DEALLOCATE PREPARE, SQL Syntax for Prepared Statements
- debug option
- 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, 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
- mysqlslap, mysqlslap — Load Emulation Client
- debug-info option
- mysql, mysql Options
- 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, 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, mysqld Command Options
- default-storage-engine option
- mysqld, mysqld Command Options
- default-table-type option
- mysqld, mysqld Command Options
- default-time-zone option
- mysqld, mysqld Command Options
- defaults
- embedded, Options with the Embedded Server
- defaults-extra-file option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- defaults-file option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- DEGREES(), Mathematical Functions
- delay-key-write option
- mysqld, mysqld Command Options, MyISAM Startup Options
- DELAYED, INSERT DELAYED Syntax
- delayed-insert option
- mysqldump, mysqldump — A Database Backup Program
- delayed_insert_limit, INSERT DELAYED Syntax
- DELETE, DELETE Syntax
- delete option
- mysqlimport, mysqlimport — A Data Import Program
- delete-master-logs option
- mysqldump, mysqldump — A Database Backup Program
- deleting
- database, DROP DATABASE Syntax
- foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
- function, DROP FUNCTION Syntax
- index, ALTER TABLE Syntax, DROP INDEX Syntax
- primary key, ALTER TABLE Syntax
- rows, Deleting Rows from Related Tables
- schema, DROP DATABASE Syntax
- table, DROP TABLE Syntax
- user, Removing User Accounts from MySQL, DROP USER Syntax
- users, Removing User Accounts from MySQL, DROP USER Syntax
- deletion
- mysql.sock, How to Protect or Change the MySQL Unix Socket File
- delimiter option
- mysql, mysql Options
- mysqlslap, mysqlslap — Load Emulation Client
- Delphi program, Programs Known to Work With MyODBC
- derived tables, Subqueries in the FROM clause
- des-key-file option
- mysqld, mysqld Command Options
- DESC, DESCRIBE Syntax
- 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-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
- 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
- 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, GROUP BY (Aggregate) Functions, SELECT Syntax
- 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
- Documenters
- list of, Documenters and translators
- DOUBLE data type, Overview of Numeric Types
- DOUBLE PRECISION data type, Overview of Numeric Types
- double quote (\"), Strings
- downgrading, Downgrading MySQL
- downloading, How to Get MySQL
- DROP DATABASE, DROP DATABASE Syntax
- DROP FOREIGN KEY, ALTER TABLE Syntax, FOREIGN KEY Constraints
- DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION Syntax, DROP FUNCTION Syntax
- DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax
- DROP PREPARE, SQL Syntax for Prepared Statements
- DROP PRIMARY KEY, ALTER TABLE Syntax
- DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax
- DROP SCHEMA, DROP DATABASE Syntax
- DROP TABLE, DROP TABLE Syntax
- 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
- DUMPFILE, SELECT Syntax
- dynamic table characteristics, Dynamic Table Characteristics
E
- Eiffel Wrapper, MySQL Eiffel Wrapper
- ELT(), String Functions
- email lists, MySQL Mailing Lists
- embedded MySQL server library, libmysqld, the Embedded MySQL Server Library
- enable-named-pipe option
- mysqld, mysqld Command Options
- ENCODE(), Encryption and Compression Functions
- ENCRYPT(), Encryption and Compression Functions
- encryption, Basic SSL Concepts
- encryption functions, Encryption and Compression Functions
- END, BEGIN ... END Compound Statement Syntax
- EndPoint(), LineString Functions
- engine option
- mysqlslap, mysqlslap — Load Emulation Client
- ENGINES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ENGINES Table
- entering
- queries, Entering Queries
- ENUM
- size, Data Type Storage Requirements
- ENUM data type, Overview of String Types, The ENUM Type
- Envelope(), General Geometry Functions
- environment variable
- CC, Typical configure Options, Dealing with Problems Compiling MySQL
- CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL
- CXX, Typical configure Options, Dealing with Problems Compiling MySQL
- CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL
- HOME, mysql Options
- LD_RUN_PATH, Linux Source Distribution Notes, Solaris Notes
- MYSQL_DEBUG, Overview of Client and Utility Programs
- MYSQL_HISTFILE, mysql Options
- MYSQL_HOST, Connecting to the MySQL Server
- MYSQL_PWD, Connecting to the MySQL Server, Overview of Client and Utility Programs
- MYSQL_TCP_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs
- MYSQL_UNIX_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs
- PATH, Installing MySQL 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, Debugging mysqld under gdb, Environment Variables
- DBI_USER, Environment Variables
- HOME, Environment Variables
- LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
- LD_RUN_PATH, Problems Using the Perl DBI/DBD Interface, Environment Variables
- MYSQL_DEBUG, Debugging a MySQL Client, 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, Time Zone Problems, Environment Variables
- UMASK, Problems with File Permissions, Environment Variables
- UMASK_DIR, Problems with File Permissions, Environment Variables
- USER, Environment Variables
- Environment variables
- CXX, Dealing with Problems Compiling MySQL
- environment variables, Using Environment Variables to Specify Options, Causes of Access denied Errors, Overview of Client and Utility Programs
- list of, Environment Variables
- equal (=), Comparison Functions and Operators
- Equals(), Functions That Test Spatial Relationships Between Geometries
- error 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
- known, Known Issues in MySQL
- linking, Problems Linking to the MySQL Client Library
- list of, Common Errors When Using MySQL Programs
- reporting, General Information, How to Report Bugs or Problems
- ERROR_FOR_DIVISION_BY_ZERO SQL mode, The Server SQL Mode
- escape (\\), Strings
- escape characters, Literal Values
- estimating
- query performance, Estimating Query Performance
- event-scheduler option
- mysqld, mysqld Command Options
- EVENTS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA EVENTS Table
- exact-value literals, Precision Math
- example option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- EXAMPLE storage engine, Storage Engines and Table Types, The EXAMPLE Storage Engine
- EXAMPLE table type, Storage Engines and Table Types, 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
- Excel, Programs Known to Work With MyODBC
- EXECUTE, SQL Syntax for Prepared Statements
- execute option
- mysql, mysql Options
- EXECUTE statement, SQL Syntax for Prepared Statements
- exit-info option
- mysqld, mysqld Command Options
- EXP(), Mathematical Functions
- EXPLAIN, Optimizing Queries with EXPLAIN
- EXPLAIN PARTITIONS, Obtaining Information About Partitions
- EXPLAIN used with partitioned tables, Obtaining Information About Partitions
- explicit default values, Data Type Default Values
- EXPORT_SET(), String Functions
- expression aliases, GROUP BY 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, mysqld Command Options, Server System Variables, Using myisamchk for Crash Recovery, SHOW PROCESSLIST Syntax
- external-locking option
- mysqld, mysqld Command Options
- EXTRACT(), Date and Time Functions
- extracting
- dates, Date Calculations
- ExtractValue(), XML Functions
F
- FALSE, Numbers, Boolean Values
- testing for, Comparison Functions and Operators
- fast option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- fatal signal 11, Dealing with Problems Compiling MySQL
- features of MySQL, The Main Features of MySQL
- FEDERATED storage engine, Storage Engines and Table Types, The FEDERATED Storage Engine
- FEDERATED table type, Storage Engines and Table Types, The FEDERATED Storage Engine
- FETCH, Cursor FETCH Statement
- field
- changing, ALTER TABLE Syntax
- FIELD(), String Functions
- FILE, String Functions
- files
- binary log, The Binary Log
- config.cache, Dealing with Problems Compiling MySQL
- error messages, Setting the Error Message Language
- general query log, The General Query Log
- log, Typical configure Options, Server Log Maintenance
- my.cnf, Replication Features and Known Problems
- not found message, Problems with File Permissions
- permissions, Problems with File Permissions
- repairing, myisamchk Repair Options
- script, Using mysql in Batch Mode
- size limits, How Large MySQL Tables Can Be
- slow query log, The Slow Query Log
- tmp, Problems Running mysql_install_db
- update log (obsolete), The Binary Log
- FILES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA FILES Table
- filesort optimization, ORDER BY Optimization
- FIND_IN_SET(), String Functions
- first-slave option
- mysqldump, mysqldump — A Database Backup Program
- fix-db-names option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- fix-table-names option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair 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, mysqld Command Options
- flush tables, mysqladmin — Client for Administering a MySQL Server
- flush-logs option
- mysqldump, mysqldump — A Database Backup Program
- flushlog option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- FOR UPDATE, SELECT Syntax
- FORCE INDEX, SELECT Syntax, JOIN Syntax, Optimizer-Related Issues
- FORCE KEY, SELECT Syntax, JOIN 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
- FROM, SELECT Syntax
- FROM_DAYS(), Date and Time Functions
- FROM_UNIXTIME(), Date and Time Functions
- ft_max_word_len myisamchk variable, myisamchk General Options
- ft_min_word_len myisamchk variable, myisamchk General Options
- ft_stopword_file myisamchk
variable, myisamchk General Options
- full disk, How MySQL Handles a Full Disk
- full-text search, Full-Text Search Functions
- FULLTEXT, Full-Text Search Functions
- fulltext
- stopword list, Fine-Tuning MySQL Full-Text Search
- function
- creating, CREATE FUNCTION Syntax
- deleting, DROP FUNCTION Syntax
- 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
- gcc, Typical configure Options
- gdb
- using, Debugging mysqld under gdb
- general information, General Information
- General Public License, Overview of the MySQL Database Management System
- 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, Overview of the MySQL Database Management System
- GPL
- General Public License, GNU General Public License
- GNU General Public License, GNU General Public License
- MySQL FLOSS License Exception, MySQL FLOSS License Exception
- 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 with Hidden Fields
- extensions to standard SQL, GROUP BY with Hidden Fields, SELECT Syntax
- GROUP BY functions, GROUP BY (Aggregate) Functions
- grouping
- expressions, Operator Precedence
- GROUP_CONCAT(), GROUP BY (Aggregate) Functions
H
- HANDLER, HANDLER Syntax
- Handlers, DECLARE Handlers
- handling
- errors, UDF Return Values and Error Handling
- hash partitioning, HASH Partitioning
- hash partitions, managing, Management of HASH and KEY Partitions
- hash partitions, splitting and merging, Management of HASH and KEY Partitions
- HAVING, SELECT Syntax
- HEAP storage engine, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine
- HEAP table type, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine
- help option
- 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, 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
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- perror, perror — Explain Error Codes
- HEX(), String Functions
- hex-blob option
- mysqldump, mysqldump — A Database Backup Program
- hexadecimal values, Hexadecimal Values
- hexdump option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- HIGH_NOT_PRECEDENCE SQL mode, The Server SQL Mode
- HIGH_PRIORITY, SELECT Syntax
- hints, MySQL Extensions to Standard SQL, SELECT Syntax, JOIN Syntax
- index, SELECT Syntax, JOIN Syntax
- history of MySQL, History of MySQL
- HOME environment variable, mysql Options, Environment Variables
- 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
- mysqlslap, mysqlslap — Load Emulation Client
- host table, Access Control, Stage 2: Request Verification
- sorting, Access Control, Stage 2: Request Verification
- host.frm
- problems finding, Unix Post-Installation Procedures
- hostname
- default, Connecting to the MySQL Server
- hostname caching, How MySQL Uses DNS
- HOUR(), Date and Time Functions
- howto option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- html option
- mysql, mysql Options
I
- i-am-a-dummy option
- mysql, mysql Options
- ID
- unique, How to Get the Unique ID for the Last Inserted Row
- identifiers, Database, Table, Index, Column, and Alias Names
- case sensitivity, Identifier Case Sensitivity
- quoting, Database, Table, Index, Column, and Alias Names
- IF, IF Statement
- IF(), Control Flow Functions
- IFNULL(), Control Flow Functions
- IGNORE INDEX, SELECT Syntax, JOIN Syntax
- IGNORE KEY, SELECT Syntax, JOIN 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, The Server SQL Mode
- implicit default values, Data Type Default Values
- IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
- IN, Comparison Functions and Operators
- increasing
- performance, Replication FAQ
- increasing with replication
- speed, Replication
- index
- deleting, ALTER TABLE Syntax, DROP INDEX Syntax
- index hints, SELECT Syntax, JOIN 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, Server System Variables
- columns, Column Indexes
- leftmost prefix of, How MySQL Uses Indexes
- multi-column, Multiple-Column Indexes
- multiple-part, CREATE INDEX Syntax
- names, Database, Table, Index, Column, and Alias Names
- use of, How MySQL Uses Indexes
- INET_ATON(), Miscellaneous Functions
- INET_NTOA(), Miscellaneous Functions
- information about partitions, obtaining, Obtaining Information About Partitions
- information functions, Information Functions
- information option
- myisamchk, myisamchk Check Options
- INFORMATION_SCHEMA, The INFORMATION_SCHEMA Database
- init-file option
- mysqld, mysqld Command Options
- INNER JOIN, JOIN Syntax
- InnoDB, InnoDB Overview
- Solaris 10 x86_64 issues, Solaris Notes
- innodb option
- mysqld, InnoDB Startup Options and System Variables
- InnoDB storage engine, Storage Engines and Table Types, The InnoDB Storage Engine
- InnoDB table type, Storage Engines and Table Types, The InnoDB Storage Engine
- InnoDB tables, Transactions and Atomic Operations
- innodb_status_file option
- mysqld, InnoDB Startup Options and System Variables
- INSERT, Speed of INSERT Statements, INSERT Syntax
- INSERT ... SELECT, INSERT ... SELECT Syntax
- INSERT DELAYED, INSERT DELAYED Syntax
- INSERT statement
- grant privileges, Adding New User Accounts to MySQL
- INSERT(), String Functions
- insert-ignore option
- mysqldump, mysqldump — A Database Backup Program
- inserting
- speed of, Speed of INSERT Statements
- inserts
- concurrent, Locking Methods, Concurrent Inserts
- INSTALL PLUGIN, INSTALL PLUGIN Syntax
- installation layouts, Installation Layouts
- installation overview, MySQL Installation Using a Source Distribution
- installing
- binary distribution, Installing MySQL on Other Unix-Like Systems
- Linux RPM packages, Installing MySQL on Linux
- Mac OS X PKG packages, Installing MySQL on Mac OS X
- overview, Installing and Upgrading MySQL
- Perl, Perl Installation Notes
- Perl on Windows, Installing ActiveState Perl on Windows
- source distribution, MySQL Installation Using a Source Distribution
- user-defined functions, Compiling and Installing User-Defined Functions
- installing plugins, INSTALL PLUGIN Syntax
- 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, Locking Methods
- internals, MySQL Internals
- Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC)
- Intersection(), Spatial Operators
- Intersects(), Functions That Test Spatial Relationships Between Geometries
- INTERVAL(), Comparison Functions and Operators
- introducer
- string literal, Strings, Character String Literal Character Set and Collation
- invalid data
- constraint, Constraints on Invalid Data
- 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
- 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
- iterations option
- mysqlslap, mysqlslap — Load Emulation Client
K
- keepold option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- Key cache
- MyISAM, The MyISAM Key Cache
- key cache
- assigning indexes to, CACHE INDEX Syntax
- key partitioning, KEY Partitioning
- key partitions, managing, Management of HASH and KEY Partitions
- key partitions, splitting and merging, Management of HASH and KEY Partitions
- 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, Treatment of Reserved Words in MySQL
- key_buffer_size myisamchk variable, myisamchk General Options
- KEY_COLUMN_USAGE
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- KILL, KILL Syntax
- known errors, Known Issues in MySQL
L
- language option
- mysqld, mysqld Command Options
- language support
- error messages, Setting the Error Message Language
- large-pages option
- mysqld, 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([expr]), Information Functions
- layout of installation, Installation Layouts
- LCASE(), String Functions
- LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD Interface
- LD_RUN_PATH environment variable, Linux Source Distribution Notes, Solaris Notes, Problems Using the Perl DBI/DBD Interface, Environment Variables
- LEAST(), Comparison Functions and Operators
- LEAVE, LEAVE Statement
- ledir option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization, JOIN Syntax
- LEFT OUTER JOIN, JOIN Syntax
- LEFT(), String Functions
- leftmost prefix of indexes, How MySQL Uses Indexes
- legal names, Database, Table, Index, Column, and Alias Names
- LENGTH(), String Functions
- less than (<), Comparison Functions and Operators
- less than or equal (<=), Comparison Functions and Operators
- libmysqld, libmysqld, the Embedded MySQL Server Library
- options, Options with the Embedded Server
- libraries
- list of, Libraries used by and included with MySQL
- library
- mysqlclient, APIs and Libraries
- mysqld, APIs and Libraries
- License, MySQL FLOSS License Exception
- LIKE, String Comparison Functions
- and indexes, How MySQL Uses Indexes
- and wildcards, How MySQL Uses Indexes
- LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax
- limitations
- design, MySQL Design Limitations and Tradeoffs
- MySQL Limitations, Limits in MySQL
- replication, Replication Features and Known Problems
- limits
- file-size, How Large MySQL Tables Can Be
- MySQL Limits, limits in MySQL, Limits in MySQL
- line-numbers option
- mysql, mysql Options
- linear hash partitioning, LINEAR HASH Partitioning
- linear key partitioning, KEY Partitioning
- linefeed (\n), Strings
- LineFromText(), Creating Geometry Values Using WKT Functions
- LineFromWKB(), Creating Geometry Values Using WKB Functions
- 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
- list partitioning, LIST Partitioning
- list partitions, adding and dropping, Management of RANGE and LIST Partitions
- list partitions, managing, Management of RANGE and LIST Partitions
- 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 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
- LOCALTIME, Date and Time Functions
- LOCALTIMESTAMP, Date and Time Functions
- LOCATE(), String Functions
- LOCK IN SHARE MODE, SELECT Syntax
- LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax
- lock-all-tables option
- mysqldump, mysqldump — A Database Backup Program
- lock-directory option
- mysqlslap, mysqlslap — Load Emulation Client
- lock-tables option
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- locking, System Factors and Startup Parameter Tuning
- external, mysqld Command Options, Server System Variables, Using myisamchk for Crash Recovery, SHOW PROCESSLIST Syntax
- page-level, Locking Methods
- row-level, Transactions and Atomic Operations, Locking Methods
- table-level, Locking Methods
- locking methods, Locking Methods
- log
- changes, MySQL Change History
- log files, Typical configure Options, MySQL Server Logs
- maintaining, Server Log Maintenance
- names, Database Backups
- log option
- mysqld, mysqld Command Options
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- LOG(), Mathematical Functions
- log-bin option
- mysqld, mysqld Command Options
- log-bin-index option
- mysqld, mysqld Command Options
- log-bin-trust-function-creators option
- mysqld, mysqld Command Options
- log-error option
- mysqld, mysqld Command Options
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- log-isam option
- mysqld, mysqld Command Options
- log-long-format option
- mysqld, mysqld Command Options
- log-output option
- mysqld, mysqld Command Options
- log-queries-not-using-indexes option
- mysqld, mysqld Command Options
- log-short-format option
- mysqld, mysqld Command Options
- log-slave-updates option
- mysqld, Replication Startup Options
- log-slow-admin-statements option
- mysqld, mysqld Command Options
- log-slow-queries option
- mysqld, mysqld Command Options
- log-warnings option
- mysqld, mysqld Command Options, Replication Startup Options
- LOG10(), Mathematical Functions
- LOG2(), Mathematical Functions
- logical operators, Logical Operators
- LONG data type, The BLOB and TEXT Types
- LONGBLOB data type, Overview of String Types
- LONGTEXT data type, Overview of String Types
- LOOP, LOOP Statement
- low-priority option
- mysqlimport, mysqlimport — A Data Import Program
- low-priority-updates option
- mysqld, mysqld Command Options
- LOWER(), String Functions
- LPAD(), String Functions
- LTRIM(), String Functions
M
- Mac OS X
- installation, Installing MySQL on Mac OS X
- mailing list address, General Information
- mailing lists, MySQL Mailing Lists
- archive location, MySQL Mailing Lists
- guidelines, Guidelines for Using the Mailing Lists
- main features of MySQL, The Main Features of MySQL
- maintaining
- log files, Server Log Maintenance
- tables, Setting Up a Table Maintenance Schedule
- MAKEDATE(), Date and Time Functions
- MAKETIME(), Date and Time Functions
- make_binary_distribution, Overview of Server-Side Programs
- MAKE_SET(), String Functions
- manual
- available formats, About This Manual
- online location, About This Manual
- typographical conventions, Conventions Used in This Manual
- master-connect-retry option
- mysqld, Replication Startup Options
- master-data option
- mysqldump, mysqldump — A Database Backup Program
- master-host option
- mysqld, Replication Startup Options
- master-info-file option
- mysqld, Replication Startup Options
- master-password option
- mysqld, Replication Startup Options
- master-port option
- mysqld, Replication Startup Options
- master-retry-count option
- mysqld, Replication Startup Options
- master-ssl option
- mysqld, Replication Startup Options
- master-ssl-ca option
- mysqld, Replication Startup Options
- master-ssl-capath option
- mysqld, Replication Startup Options
- master-ssl-cert option
- mysqld, Replication Startup Options
- master-ssl-cipher option
- mysqld, Replication Startup Options
- master-ssl-key option
- mysqld, Replication Startup Options
- master-user option
- mysqld, Replication Startup Options
- master/slave setup, Replication Implementation Overview
- MASTER_POS_WAIT(), Miscellaneous Functions, MASTER_POS_WAIT() Syntax
- MATCH ... AGAINST(), Full-Text Search Functions
- matching
- patterns, Pattern Matching
- math, Precision Math
- mathematical functions, Mathematical Functions
- MAX(), GROUP BY (Aggregate) Functions
- MAX(DISTINCT), GROUP BY (Aggregate) Functions
- max-record-length option
- myisamchk, myisamchk Repair Options
- max-relay-log-size option
- mysqld, Replication Startup Options
- MAXDB SQL mode, The Server SQL Mode
- maximum memory used, mysqladmin — Client for Administering a MySQL Server
- maximums
- maximum tables per join, Limits of Joins
- 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, mysqld Command Options
- MEMORY storage engine, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine
- MEMORY table type, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine
- memory usage
- myisamchk, myisamchk Memory Usage
- memory use, How MySQL Uses Memory, mysqladmin — Client for Administering a MySQL Server
- MERGE storage engine, Storage Engines and Table Types, The MERGE Storage Engine
- MERGE table type, Storage Engines and Table Types, The MERGE Storage Engine
- MERGE tables
- defined, The MERGE Storage Engine
- metadata
- database, The INFORMATION_SCHEMA Database
- method option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- methods
- locking, Locking Methods
- MICROSECOND(), Date and Time Functions
- 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
- modules
- list of, MySQL Stability
- modulo (%), Mathematical Functions
- modulo (MOD), Mathematical Functions
- monitor
- terminal, Tutorial
- 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, The Server SQL Mode
- 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 file, Replication Features and Known Problems
- MyISAM
- compressed tables, Compressed Table Characteristics
- size, Data Type Storage Requirements
- MyISAM key cache, The MyISAM Key Cache
- MyISAM storage engine, Storage Engines and Table Types, The MyISAM Storage Engine
- MyISAM table type, Storage Engines and Table Types, The MyISAM Storage Engine
- myisam-recover option
- mysqld, mysqld Command Options, MyISAM Startup Options
- myisamchk, Typical configure Options, Overview of Client and Utility Programs
- analyze option, Other myisamchk Options
- backup option, myisamchk Repair Options
- block-search option, Other myisamchk Options
- character-sets-dir option, myisamchk Repair Options
- check option, myisamchk Check Options
- check-only-changed option, myisamchk Check Options
- correct-checksum option, myisamchk Repair Options
- data-file-length option, myisamchk Repair Options
- debug option, myisamchk General Options
- description option, Other myisamchk Options
- example output, Getting Information About a Table
- extend-check option, myisamchk Check Options, myisamchk Repair Options
- fast option, myisamchk Check Options
- force option, myisamchk Check Options, myisamchk Repair Options
- help option, myisamchk General Options
- information option, myisamchk Check Options
- keys-used option, myisamchk Repair Options
- max-record-length option, myisamchk Repair Options
- medium-check option, myisamchk Check Options
- 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-collation option, myisamchk Repair Options
- silent option, myisamchk General Options
- sort-index option, Other myisamchk Options
- sort-records option, Other myisamchk Options
- sort-recover option, myisamchk Repair Options
- tmpdir option, myisamchk Repair Options
- unpack option, myisamchk Repair Options
- update-state option, myisamchk Check Options
- verbose option, myisamchk General Options
- version option, myisamchk General Options
- wait option, myisamchk General Options
- myisamlog, Overview of Client and Utility Programs
- myisampack, Overview of Client and Utility Programs, 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
- packlength 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
- MyODBC, MySQL Connector/ODBC
- reporting problems, How to Report MyODBC Problems or Bugs
- MySQL
- defined, Overview of the MySQL Database Management System
- introduction, Overview of the MySQL Database Management System
- pronunciation, Overview of the MySQL Database Management System
- mysql, Overview of Client and Utility Programs
- auto-rehash option, mysql Options
- batch option, mysql Options
- character-sets-dir option, mysql Options
- column-names option, mysql Options
- compress option, mysql Options
- database option, mysql Options
- debug option, mysql Options
- debug-info option, mysql Options
- default-character-set option, mysql Options
- delimiter option, mysql Options
- execute option, mysql Options
- force option, mysql Options
- help option, mysql Options
- host option, mysql Options
- html option, mysql Options
- i-am-a-dummy option, mysql Options
- ignore-spaces option, mysql Options
- line-numbers option, mysql Options
- local-infile option, mysql Options
- named-commands option, mysql Options
- no-auto-rehash option, mysql Options
- no-beep option, mysql Options
- no-named-commands option, mysql Options
- no-pager option, mysql Options
- no-tee option, mysql Options
- one-database option, mysql Options
- pager option, mysql Options
- password option, mysql Options
- port option, mysql Options
- prompt option, mysql Options
- protocol option, mysql Options
- quick option, mysql Options
- raw option, mysql Options
- reconnect option, mysql Options
- safe-updates option, mysql Options
- secure-auth option, mysql Options
- show-warnings option, mysql Options
- sigint-ignore option, mysql Options
- silent option, mysql Options
- skip-column-names option, mysql Options
- skip-line-numbers option, mysql Options
- socket option, mysql Options
- 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 in MySQL 5.0 and 5.1, MySQL Cluster Development Roadmap
- mysql command options, mysql Options
- mysql commands
- list of, mysql Commands
- MySQL Dolphin name, History of MySQL
- MySQL history, History of MySQL
- mysql history file, mysql Options
- MySQL mailing lists, MySQL Mailing Lists
- MySQL name, History of MySQL
- mysql prompt command, mysql Commands
- MySQL source distribution, Choosing Which MySQL Distribution to Install
- mysql status command, mysql Commands
- MySQL storage engines, Storage Engines and Table Types
- MySQL table types, Storage Engines and Table Types
- MySQL version, How to Get MySQL
- MySQL++, MySQL C++ API
- mysql.server, Overview of Server-Side Programs
- mysql.sock
- changing location of, Typical configure Options
- protection, How to Protect or Change the MySQL Unix Socket File
- MYSQL323 SQL mode, The Server SQL Mode
- MYSQL40 SQL mode, The Server SQL Mode
- mysqlaccess, Overview of Client and Utility Programs
- brief option, mysqlaccess — Client for Checking Access Privileges
- commit option, mysqlaccess — Client for Checking Access Privileges
- copy option, mysqlaccess — Client for Checking Access Privileges
- db option, mysqlaccess — Client for Checking Access Privileges
- debug option, mysqlaccess — Client for Checking Access Privileges
- help option, mysqlaccess — Client for Checking Access Privileges
- host option, mysqlaccess — Client for Checking Access Privileges
- howto option, mysqlaccess — Client for Checking Access Privileges
- old_server option, mysqlaccess — Client for Checking Access Privileges
- password option, mysqlaccess — Client for Checking Access Privileges
- plan option, mysqlaccess — Client for Checking Access Privileges
- preview option, mysqlaccess — Client for Checking Access Privileges
- relnotes option, mysqlaccess — Client for Checking Access Privileges
- rhost option, mysqlaccess — Client for Checking Access Privileges
- rollback option, mysqlaccess — Client for Checking Access Privileges
- spassword option, mysqlaccess — Client for Checking Access Privileges
- superuser option, mysqlaccess — Client for Checking Access Privileges
- table option, mysqlaccess — Client for Checking Access Privileges
- user option, mysqlaccess — Client for Checking Access Privileges
- version option, mysqlaccess — Client for Checking Access Privileges
- mysqladmin, Overview of Client and Utility Programs, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax
- character-sets-dir option, mysqladmin — Client for Administering a MySQL Server
- compress option, mysqladmin — Client for Administering a MySQL Server
- count option, mysqladmin — Client for Administering a MySQL Server
- debug option, mysqladmin — Client for Administering a MySQL Server
- default-character-set option, mysqladmin — Client for Administering a MySQL Server
- force option, mysqladmin — Client for Administering a MySQL Server
- help option, mysqladmin — Client for Administering a MySQL Server
- host option, mysqladmin — Client for Administering a MySQL Server
- password option, mysqladmin — Client for Administering a MySQL Server
- port option, mysqladmin — Client for Administering a MySQL Server
- protocol option, mysqladmin — Client for Administering a MySQL Server
- relative option, mysqladmin — Client for Administering a MySQL Server
- silent option, mysqladmin — Client for Administering a MySQL Server
- sleep option, mysqladmin — Client for Administering a MySQL Server
- socket option, mysqladmin — Client for Administering a MySQL Server
- user option, mysqladmin — Client for Administering a MySQL Server
- verbose option, mysqladmin — Client for Administering a MySQL Server
- version option, mysqladmin — Client for Administering a MySQL Server
- vertical option, mysqladmin — Client for Administering a MySQL Server
- wait option, mysqladmin — Client for Administering a MySQL Server
- mysqladmin command options, mysqladmin — Client for Administering a MySQL Server
- mysqladmin option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqlbinlog, Overview of Client and Utility Programs
- base64-output option, mysqlbinlog — Utility for Processing Binary Log Files
- 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
- server-id option, mysqlbinlog — Utility for Processing Binary Log Files
- short-form option, mysqlbinlog — Utility for Processing Binary Log Files
- socket option, mysqlbinlog — Utility for Processing Binary Log Files
- start-datetime option, mysqlbinlog — Utility for Processing Binary Log Files
- start-position option, mysqlbinlog — Utility for Processing Binary Log Files
- stop-datetime option, mysqlbinlog — Utility for Processing Binary Log Files
- stop-position option, mysqlbinlog — Utility for Processing Binary Log Files
- to-last-log option, mysqlbinlog — Utility for Processing Binary Log Files
- user option, mysqlbinlog — Utility for Processing Binary Log Files
- version option, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlbug script, How to Report Bugs or Problems
- mysqlcheck, Overview of Client and Utility Programs
- all-databases option, mysqlcheck — A Table Maintenance and Repair Program
- all-in-1 option, mysqlcheck — A Table Maintenance and Repair Program
- analyze option, mysqlcheck — A Table Maintenance and Repair Program
- auto-repair option, mysqlcheck — A Table Maintenance and Repair Program
- character-sets-dir option, mysqlcheck — A Table Maintenance and Repair Program
- check option, mysqlcheck — A Table Maintenance and Repair Program
- check-only-changed option, mysqlcheck — A Table Maintenance and Repair Program
- check-upgrade option, mysqlcheck — A Table Maintenance and Repair Program
- compress option, mysqlcheck — A Table Maintenance and Repair Program
- databases option, mysqlcheck — A Table Maintenance and Repair Program
- debug option, mysqlcheck — A Table Maintenance and Repair Program
- default-character-set option, mysqlcheck — A Table Maintenance and Repair Program
- extended option, mysqlcheck — A Table Maintenance and Repair Program
- fast option, mysqlcheck — A Table Maintenance and Repair Program
- fix-db-names option, mysqlcheck — A Table Maintenance and Repair Program
- fix-table-names 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
- tables option, mysqlcheck — A Table Maintenance and Repair Program
- use-frm option, mysqlcheck — A Table Maintenance and Repair Program
- user option, mysqlcheck — A Table Maintenance and Repair Program
- verbose option, mysqlcheck — A Table Maintenance and Repair Program
- version option, mysqlcheck — A Table Maintenance and Repair Program
- mysqlclient library, APIs and Libraries
- mysqld, Overview of Server-Side Programs
- allow-suspicious-udfs option, mysqld Command Options, Security-Related mysqld Options
- ansi option, mysqld Command Options
- basedir option, mysqld Command Options
- bdb-data-direct option, BDB Startup Options
- bdb-home option, BDB Startup Options
- bdb-lock-detect option, BDB Startup Options
- bdb-log-direct option, BDB Startup Options
- bdb-logdir option, BDB Startup Options
- bdb-no-recover option, BDB Startup Options
- bdb-no-sync option, BDB Startup Options
- bdb-shared-data option, BDB Startup Options
- bdb-tmpdir option, BDB Startup Options
- bind-address option, mysqld Command Options
- binlog-do-db option, The Binary Log
- binlog-format option, mysqld Command Options
- binlog-ignore-db option, The Binary Log
- binlog-row-event-max-size option, mysqld Command Options
- bootstrap option, mysqld Command Options
- 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, mysqld Command Options
- chroot option, mysqld Command Options
- collation-server option, mysqld Command Options
- command options, mysqld Command Options
- console option, mysqld Command Options
- core-file option, mysqld Command Options
- datadir option, mysqld Command Options
- debug option, mysqld Command Options
- default-character-set option, mysqld Command Options
- default-collation option, mysqld Command Options
- default-storage-engine option, mysqld Command Options
- default-table-type option, mysqld Command Options
- default-time-zone option, mysqld Command Options
- delay-key-write option, mysqld Command Options, MyISAM Startup Options
- des-key-file option, mysqld Command Options
- enable-named-pipe option, mysqld Command Options
- event-scheduler option, mysqld Command Options
- exit-info option, mysqld Command Options
- external-locking option, mysqld Command Options
- flush option, mysqld Command Options
- help option, mysqld Command Options
- init-file option, mysqld Command Options
- innodb option, InnoDB Startup Options and System Variables
- innodb_status_file option, InnoDB Startup Options and System Variables
- language option, mysqld Command Options
- large-pages option, mysqld Command Options
- local-infile option, Security-Related mysqld Options
- log option, mysqld Command Options
- log-bin option, mysqld Command Options
- log-bin-index option, mysqld Command Options
- log-bin-trust-function-creators option, mysqld Command Options
- log-error option, mysqld Command Options
- log-isam option, mysqld Command Options
- log-long-format option, mysqld Command Options
- log-output option, mysqld Command Options
- log-queries-not-using-indexes option, mysqld Command Options
- log-short-format option, mysqld Command Options
- log-slave-updates option, Replication Startup Options
- log-slow-admin-statements option, mysqld Command Options
- log-slow-queries option, mysqld Command Options
- log-warnings option, mysqld Command Options, Replication Startup Options
- low-priority-updates option, mysqld Command Options
- master-connect-retry option, Replication Startup Options
- master-host option, Replication Startup Options
- master-info-file option, Replication Startup Options
- master-password option, Replication Startup Options
- master-port option, Replication Startup Options
- master-retry-count option, Replication Startup Options
- master-ssl option, Replication Startup Options
- master-ssl-ca option, Replication Startup Options
- master-ssl-capath option, Replication Startup Options
- master-ssl-cert option, Replication Startup Options
- master-ssl-cipher option, Replication Startup Options
- master-ssl-key option, Replication Startup Options
- master-user option, Replication Startup Options
- max-relay-log-size option, Replication Startup Options
- memlock option, mysqld Command Options
- myisam-recover option, mysqld Command Options, MyISAM Startup Options
- ndb-connectstring option, mysqld Command Options
- ndbcluster option, mysqld Command Options
- old-passwords option, mysqld Command Options, Security-Related mysqld Options
- one-thread option, mysqld Command Options
- open-files-limit option, mysqld Command Options
- pid-file option, mysqld Command Options
- port option, mysqld Command Options
- port-open-timeout option, mysqld Command Options
- read-only option, Replication Startup Options
- relay-log option, Replication Startup Options
- relay-log-index option, Replication Startup Options
- relay-log-info-file option, Replication Startup Options
- relay-log-purge option, Replication Startup Options
- relay-log-space-limit option, Replication Startup Options
- replicate-do-db option, Replication Startup Options
- replicate-do-table option, Replication Startup Options
- replicate-ignore-db option, Replication Startup Options
- replicate-ignore-table option, Replication Startup Options
- replicate-rewrite-db option, Replication Startup Options
- replicate-same-server-id option, Replication Startup Options
- replicate-wild-do-table option, Replication Startup Options
- replicate-wild-ignore-table option, Replication Startup Options
- report-host option, Replication Startup Options
- report-port option, Replication Startup Options
- safe-mode option, mysqld Command Options
- safe-show-database option, mysqld Command Options, Security-Related mysqld Options
- safe-user-create option, mysqld Command Options, Security-Related mysqld Options
- secure-auth option, mysqld Command Options, Security-Related mysqld Options
- shared-memory option, mysqld Command Options
- shared-memory-base-name option, mysqld Command Options
- skip-bdb option, mysqld Command Options, BDB Startup Options
- 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-name-resolve option, mysqld Command Options, Security-Related mysqld Options
- skip-ndbcluster option, mysqld Command Options
- skip-networking option, mysqld Command Options, Security-Related mysqld Options
- skip-safemalloc option, mysqld Command Options
- skip-show-database option, mysqld Command Options, Security-Related mysqld Options
- skip-slave-start option, Replication Startup Options
- skip-stack-trace option, mysqld Command Options
- skip-symbolic-links option, mysqld Command Options
- skip-thread-priority option, mysqld Command Options
- slave-load-tmpdir option, Replication Startup Options
- slave-net-timeout option, Replication Startup Options
- slave-skip-errors option, Replication Startup Options
- slave_compressed_protocol option, Replication Startup Options
- socket option, mysqld Command Options
- sql-mode option, mysqld Command Options
- ssl option, SSL Command Options
- 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
- standalone option, mysqld Command Options
- starting, How to Run MySQL as a Normal User
- symbolic-links option, mysqld Command Options
- sync-bdb-logs option, BDB Startup Options
- temp-pool option, mysqld Command Options
- tmpdir option, mysqld Command Options
- transaction-isolation option, mysqld Command Options
- user option, mysqld Command Options
- version option, mysqld Command Options
- mysqld library, APIs and Libraries
- mysqld option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysqld options, Tuning Server Parameters
- mysqld server
- buffer sizes, Tuning Server Parameters
- mysqld-version option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysqldump, Copying MySQL Databases to Another Machine, Overview of Client and Utility Programs
- add-drop-database option, mysqldump — A Database Backup Program
- add-drop-table option, mysqldump — A Database Backup Program
- add-locks option, mysqldump — A Database Backup Program
- all-databases option, mysqldump — A Database Backup Program
- all-tablespaces option, mysqldump — A Database Backup Program
- allow-keywords option, mysqldump — A Database Backup Program
- character-sets-dir option, mysqldump — A Database Backup Program
- comments option, mysqldump — A Database Backup Program
- compact option, mysqldump — A Database Backup Program
- compatible option, mysqldump — A Database Backup Program
- complete-insert option, mysqldump — A Database Backup Program
- compress option, mysqldump — A Database Backup Program
- create-options option, mysqldump — A Database Backup Program
- databases option, mysqldump — A Database Backup Program
- debug option, mysqldump — A Database Backup Program
- default-character-set option, mysqldump — A Database Backup Program
- delayed-insert option, mysqldump — A Database Backup Program
- delete-master-logs option, mysqldump — A Database Backup Program
- disable-keys option, mysqldump — A Database Backup Program
- extended-insert option, mysqldump — A Database Backup Program
- first-slave option, mysqldump — A Database Backup Program
- flush-logs 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
- lock-all-tables option, mysqldump — A Database Backup Program
- lock-tables option, mysqldump — A Database Backup Program
- master-data option, mysqldump — A Database Backup Program
- no-autocommit option, mysqldump — A Database Backup Program
- no-create-db option, mysqldump — A Database Backup Program
- no-create-info option, mysqldump — A Database Backup Program
- no-data option, mysqldump — A Database Backup Program
- opt option, mysqldump — A Database Backup Program
- order-by-primary option, mysqldump — A Database Backup Program
- password option, mysqldump — A Database Backup Program
- port option, mysqldump — A Database Backup Program
- protocol option, mysqldump — A Database Backup Program
- quick option, mysqldump — A Database Backup Program
- quote-names option, mysqldump — A Database Backup Program
- replace 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
- socket option, 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
- where option, mysqldump — A Database Backup Program
- xml option, mysqldump — A Database Backup Program
- mysqld_multi, Overview of Server-Side Programs
- config-file option, mysqld_multi — Manage Multiple MySQL Servers
- example option, mysqld_multi — Manage Multiple MySQL Servers
- help option, mysqld_multi — Manage Multiple MySQL Servers
- log option, mysqld_multi — Manage Multiple MySQL Servers
- mysqladmin option, mysqld_multi — Manage Multiple MySQL Servers
- mysqld option, mysqld_multi — Manage Multiple MySQL Servers
- no-log option, mysqld_multi — Manage Multiple MySQL Servers
- password option, mysqld_multi — Manage Multiple MySQL Servers
- silent option, mysqld_multi — Manage Multiple MySQL Servers
- tcp-ip option, mysqld_multi — Manage Multiple MySQL Servers
- user option, mysqld_multi — Manage Multiple MySQL Servers
- verbose option, mysqld_multi — Manage Multiple MySQL Servers
- version option, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, Overview of Server-Side Programs
- autoclose option, mysqld_safe — MySQL Server Startup Script
- basedir option, mysqld_safe — MySQL Server Startup Script
- core-file-size option, mysqld_safe — MySQL Server Startup Script
- datadir option, mysqld_safe — MySQL Server Startup Script
- defaults-extra-file option, mysqld_safe — MySQL Server Startup Script
- defaults-file option, mysqld_safe — MySQL Server Startup Script
- help option, mysqld_safe — MySQL Server Startup Script
- ledir option, mysqld_safe — MySQL Server Startup Script
- log-error option, mysqld_safe — MySQL Server Startup Script
- mysqld option, mysqld_safe — MySQL Server Startup Script
- mysqld-version option, mysqld_safe — MySQL Server Startup Script
- nice option, mysqld_safe — MySQL Server Startup Script
- no-defaults option, mysqld_safe — MySQL Server Startup Script
- open-files-limit option, mysqld_safe — MySQL Server Startup Script
- pid-file option, mysqld_safe — MySQL Server Startup Script
- port option, mysqld_safe — MySQL Server Startup Script
- socket option, mysqld_safe — MySQL Server Startup Script
- timezone option, mysqld_safe — MySQL Server Startup Script
- user option, mysqld_safe — MySQL Server Startup Script
- mysqlhotcopy, Overview of Client and Utility Programs
- addtodest option, mysqlhotcopy — A Database Backup Program
- allowold option, mysqlhotcopy — A Database Backup Program
- checkpoint option, mysqlhotcopy — A Database Backup Program
- chroot option, mysqlhotcopy — A Database Backup Program
- debug option, mysqlhotcopy — A Database Backup Program
- dryrun option, mysqlhotcopy — A Database Backup Program
- flushlog option, mysqlhotcopy — A Database Backup Program
- help option, mysqlhotcopy — A Database Backup Program
- host option, mysqlhotcopy — A Database Backup Program
- keepold option, mysqlhotcopy — A Database Backup Program
- method option, mysqlhotcopy — A Database Backup Program
- noindices option, mysqlhotcopy — A Database Backup Program
- password option, mysqlhotcopy — A Database Backup Program
- port option, mysqlhotcopy — A Database Backup Program
- quiet option, mysqlhotcopy — A Database Backup Program
- record_log_pos option, mysqlhotcopy — A Database Backup Program
- regexp option, mysqlhotcopy — A Database Backup Program
- resetmaster option, mysqlhotcopy — A Database Backup Program
- resetslave option, mysqlhotcopy — A Database Backup Program
- socket option, mysqlhotcopy — A Database Backup Program
- suffix option, mysqlhotcopy — A Database Backup Program
- tmpdir option, mysqlhotcopy — A Database Backup Program
- user option, mysqlhotcopy — A Database Backup Program
- mysqlimport, Copying MySQL Databases to Another Machine, Overview of Client and Utility Programs, LOAD DATA INFILE Syntax
- character-sets-dir option, mysqlimport — A Data Import Program
- columns option, mysqlimport — A Data Import Program
- compress option, mysqlimport — A Data Import Program
- debug option, mysqlimport — A Data Import Program
- default-character-set option, mysqlimport — A Data Import Program
- delete option, mysqlimport — A Data Import Program
- force option, mysqlimport — A Data Import Program
- help option, mysqlimport — A Data Import Program
- host option, mysqlimport — A Data Import Program
- ignore option, mysqlimport — A Data Import Program
- ignore-lines option, mysqlimport — A Data Import Program
- local option, mysqlimport — A Data Import Program
- lock-tables option, mysqlimport — A Data Import Program
- low-priority option, mysqlimport — A Data Import Program
- password option, mysqlimport — A Data Import Program
- port option, mysqlimport — A Data Import Program
- protocol option, mysqlimport — A Data Import Program
- replace option, mysqlimport — A Data Import Program
- silent option, mysqlimport — A Data Import Program
- socket option, mysqlimport — A Data Import Program
- user option, mysqlimport — A Data Import Program
- verbose option, mysqlimport — A Data Import Program
- version option, mysqlimport — A Data Import Program
- mysqlmanager, Overview of Server-Side Programs
- mysqlshow, Overview of Client and Utility Programs
- character-sets-dir option, mysqlshow — Display Database, Table, and Column Information
- compress option, mysqlshow — Display Database, Table, and Column Information
- count option, mysqlshow — Display Database, Table, and Column Information
- debug option, mysqlshow — Display Database, Table, and Column Information
- default-character-set option, mysqlshow — Display Database, Table, and Column Information
- help option, mysqlshow — Display Database, Table, and Column Information
- host option, mysqlshow — Display Database, Table, and Column Information
- keys option, mysqlshow — Display Database, Table, and Column Information
- password option, mysqlshow — Display Database, Table, and Column Information
- port option, mysqlshow — Display Database, Table, and Column Information
- protocol option, mysqlshow — Display Database, Table, and Column Information
- show-table-type option, mysqlshow — Display Database, Table, and Column Information
- socket option, mysqlshow — Display Database, Table, and Column Information
- 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
- mysqlslap, Overview of Client and Utility Programs
- auto-generate-sql option, mysqlslap — Load Emulation Client
- compress option, mysqlslap — Load Emulation Client
- concurrency option, mysqlslap — Load Emulation Client
- create option, mysqlslap — Load Emulation Client
- create-schema option, mysqlslap — Load Emulation Client
- csv option, mysqlslap — Load Emulation Client
- debug option, mysqlslap — Load Emulation Client
- delimiter option, mysqlslap — Load Emulation Client
- engine option, mysqlslap — Load Emulation Client
- help option, mysqlslap — Load Emulation Client
- host option, mysqlslap — Load Emulation Client
- iterations option, mysqlslap — Load Emulation Client
- lock-directory option, mysqlslap — Load Emulation Client
- number-char-cols option, mysqlslap — Load Emulation Client
- number-int-cols option, mysqlslap — Load Emulation Client
- number-of-queries option, mysqlslap — Load Emulation Client
- only-print option, mysqlslap — Load Emulation Client
- password option, mysqlslap — Load Emulation Client
- port option, mysqlslap — Load Emulation Client
- preserve-schema option, mysqlslap — Load Emulation Client
- protocol option, mysqlslap — Load Emulation Client
- query option, mysqlslap — Load Emulation Client
- silent option, mysqlslap — Load Emulation Client
- skip-query option, mysqlslap — Load Emulation Client
- slave option, mysqlslap — Load Emulation Client
- socket option, mysqlslap — Load Emulation Client
- use-threads option, mysqlslap — Load Emulation Client
- user option, mysqlslap — Load Emulation Client
- verbose option, mysqlslap — Load Emulation Client
- version option, mysqlslap — Load Emulation Client
- 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_create_db(), mysql_create_db()
- mysql_data_seek(), mysql_data_seek()
- MYSQL_DEBUG environment variable, Overview of Client and Utility Programs, Debugging a MySQL Client, Environment Variables
- mysql_debug(), mysql_debug()
- mysql_drop_db(), mysql_drop_db()
- mysql_dump_debug_info(), mysql_dump_debug_info()
- mysql_eof(), mysql_eof()
- mysql_errno(), mysql_errno()
- mysql_error(), mysql_error()
- mysql_escape_string(), mysql_escape_string()
- mysql_fetch_field(), mysql_fetch_field()
- mysql_fetch_fields(), mysql_fetch_fields()
- mysql_fetch_field_direct(), mysql_fetch_field_direct()
- mysql_fetch_lengths(), mysql_fetch_lengths()
- mysql_fetch_row(), mysql_fetch_row()
- MYSQL_FIELD C type, C API 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_fix_privilege_tables, Overview of Server-Side Programs
- mysql_free_result(), mysql_free_result()
- mysql_get_character_set_info(), mysql_get_character_set_info()
- mysql_get_client_info(), mysql_get_client_info()
- mysql_get_client_version(), mysql_get_client_version()
- mysql_get_host_info(), mysql_get_host_info()
- mysql_get_proto_info(), mysql_get_proto_info()
- mysql_get_server_info(), mysql_get_server_info()
- mysql_get_server_version(), mysql_get_server_version()
- mysql_hex_string(), mysql_hex_string()
- MYSQL_HISTFILE environment variable, mysql Options, Environment Variables
- MYSQL_HOME environment variable, Environment Variables
- MYSQL_HOST environment variable, Connecting to the MySQL Server, Environment Variables
- mysql_info(), ALTER TABLE Syntax, INSERT Syntax, LOAD DATA INFILE Syntax, UPDATE Syntax, mysql_info()
- mysql_init(), mysql_init()
- mysql_insert_id(), Transactions and Atomic Operations, INSERT Syntax, mysql_insert_id()
- mysql_install_db, Overview of Server-Side Programs
- mysql_install_db script, Problems Running mysql_install_db
- mysql_kill(), mysql_kill()
- mysql_library_end(), mysql_library_end()
- mysql_library_init(), mysql_library_init()
- mysql_list_dbs(), mysql_list_dbs()
- mysql_list_fields(), mysql_list_fields()
- mysql_list_processes(), mysql_list_processes()
- mysql_list_tables(), mysql_list_tables()
- mysql_more_results()., mysql_more_results()
- mysql_next_result()., mysql_next_result()
- mysql_num_fields(), mysql_num_fields()
- mysql_num_rows(), mysql_num_rows()
- mysql_options(), mysql_options()
- mysql_ping(), mysql_ping()
- MYSQL_PS1 environment variable, Environment Variables
- MYSQL_PWD environment variable, Connecting to the MySQL Server, Overview of Client and Utility Programs, Environment Variables
- 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_select_db(), mysql_select_db()
- mysql_server_end(), mysql_server_end()
- mysql_server_init(), mysql_server_init()
- mysql_set_character_set(), mysql_set_character_set()
- mysql_set_server_option(), mysql_set_server_option()
- mysql_shutdown(), mysql_shutdown()
- mysql_sqlstate(), mysql_sqlstate()
- mysql_ssl_set(), mysql_ssl_set()
- mysql_stat(), mysql_stat()
- MYSQL_STMT C type, C API 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_TCP_PORT environment variable, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs, Environment Variables
- 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_UNIX_PORT environment variable, Problems Running mysql_install_db, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs, Environment Variables
- mysql_upgrade, Overview of Server-Side Programs, Causes of Access denied Errors
- basedir option, mysql_upgrade — Check Tables for MySQL Upgrade
- datadir option, mysql_upgrade — Check Tables for MySQL Upgrade
- force option, mysql_upgrade — Check Tables for MySQL Upgrade
- 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_warning_count()., mysql_warning_count()
- mysql_zap, Overview of Client and Utility Programs
- my_init(), my_init()
- my_ulonglong C type, C API Data types
- my_ulonglong values
- printing, C API Data types
N
- named pipes, Selecting a MySQL Server type, Testing The MySQL Installation
- named-commands option
- mysql, mysql Options
- names, Database, Table, Index, Column, and Alias Names
- case sensitivity, Identifier Case Sensitivity
- variables, User-Defined Variables
- NAME_CONST(), Miscellaneous Functions
- naming
- releases of MySQL, Choosing Which Version of MySQL to Install
- NATIONAL CHAR data type, Overview of String Types
- native functions
- adding, Adding a New Native Function
- native thread support, Operating Systems Supported by MySQL
- 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 option
- perror, perror — Explain Error Codes
- ndb-connectstring option
- mysqld, mysqld Command Options
- ndbcluster option
- mysqld, mysqld Command Options
- negative values, Numbers
- nested queries, Subquery Syntax
- net etiquette, Guidelines for Using the Mailing Lists
- netmask notation
- in mysql.user table, Access Control, Stage 1: Connection Verification
- NetWare, Installing MySQL on NetWare
- net_buffer_length variable, mysql Options
- New features in MySQL Cluster, MySQL Cluster Development Roadmap
- new procedures
- adding, Adding New Procedures to MySQL
- new users
- adding, Installing MySQL on Other Unix-Like Systems, Source Installation Overview
- newline (\n), Strings
- 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-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-defaults option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- 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-tee option
- mysql, mysql Options
- 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
- NOT
- logical, Logical Operators
- NOT BETWEEN, Comparison Functions and Operators
- not equal (!=), Comparison Functions and Operators
- not equal (<>), Comparison Functions and Operators
- NOT IN, Comparison Functions and Operators
- NOT LIKE, String Comparison Functions
- NOT NULL
- constraint, Constraints on Invalid Data
- NOT REGEXP, String Comparison Functions
- Novell NetWare, Installing MySQL on NetWare
- NOW(), Date and Time Functions
- NO_AUTO_CREATE_USER SQL mode, The Server SQL Mode
- NO_AUTO_VALUE_ON_ZERO SQL mode, The Server SQL Mode
- NO_BACKSLASH_ESCAPES SQL mode, The Server SQL Mode
- NO_DIR_IN_CREATE SQL mode, The Server SQL Mode
- NO_FIELD_OPTIONS SQL mode, The Server SQL Mode
- NO_KEY_OPTIONS SQL mode, The Server SQL Mode
- NO_TABLE_OPTIONS SQL mode, The Server SQL Mode
- NO_UNSIGNED_SUBTRACTION SQL mode, The Server SQL Mode
- NO_ZERO_DATE SQL mode, The Server SQL Mode
- NO_ZERO_IN_DATE SQL mode, The Server SQL Mode
- NUL, Strings
- NULL, Working with NULL Values, Problems with NULL Values
- ORDER BY, ORDER BY Optimization, SELECT Syntax
- testing for null, Comparison Functions and Operators, Control Flow Functions
- NULL value, Working with NULL Values, NULL Values
- NULL values
- and AUTO_INCREMENT columns, Problems with NULL Values
- and indexes, CREATE TABLE Syntax
- and TIMESTAMP columns, Problems with NULL Values
- vs. empty values, Problems with NULL Values
- NULLIF(), Control Flow Functions
- number-char-cols option
- mysqlslap, mysqlslap — Load Emulation Client
- number-int-cols option
- mysqlslap, mysqlslap — Load Emulation Client
- number-of-queries option
- mysqlslap, mysqlslap — Load Emulation Client
- numbers, Numbers
- NUMERIC data type, Overview of Numeric Types
- numeric types, Data Type Storage Requirements
- NumGeometries(), GeometryCollection Functions
- NumInteriorRings(), Polygon Functions
- NumPoints(), LineString Functions
O
- 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
- odbcadmin program, Programs Known to Work With MyODBC
- offset option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- OLAP, GROUP BY Modifiers
- old-passwords option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- OLD_PASSWORD(), Encryption and Compression Functions
- old_server option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- ON DUPLICATE KEY, INSERT Syntax
- one-database option
- mysql, mysql Options
- one-thread option
- mysqld, mysqld Command Options
- online location of manual, About This Manual
- only-print option
- mysqlslap, mysqlslap — Load Emulation Client
- ONLY_FULL_GROUP_BY
- SQL mode, GROUP BY with Hidden Fields
- ONLY_FULL_GROUP_BY SQL mode, The Server SQL Mode
- OPEN, Cursor OPEN Statement
- Open Source
- defined, Overview of the MySQL Database Management System
- open tables, How MySQL Opens and Closes Tables, mysqladmin — Client for Administering a MySQL Server
- open-files-limit option
- mysqld, mysqld Command Options
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- OpenGIS, Introduction to MySQL Spatial Support
- opening
- tables, How MySQL Opens and Closes Tables
- opens, mysqladmin — Client for Administering a MySQL Server
- OpenSSL, Using Secure Connections
- open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files
- operating systems
- file-size limits, How Large MySQL Tables Can Be
- supported, Operating Systems Supported by MySQL
- Windows versus Unix, MySQL on Windows Compared to MySQL on Unix
- operations
- arithmetic, Arithmetic Operators
- operators, Functions and Operators
- cast, Arithmetic Operators, Cast Functions and Operators
- logical, Logical Operators
- precedence, Operator Precedence
- opt option
- mysqldump, mysqldump — A Database Backup Program
- optimization
- tips, Other Optimization Tips
- optimizations, WHERE Clause Optimization, Index Merge Optimization
- optimize option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- OPTIMIZE TABLE, OPTIMIZE TABLE Syntax
- optimizer
- controlling, Controlling Query Optimizer Performance
- optimizing
- DISTINCT, DISTINCT Optimization
- filesort, ORDER BY Optimization
- GROUP BY, GROUP BY Optimization
- LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization
- LIMIT, LIMIT Optimization
- tables, Table Optimization
- option files, Using Option Files, Causes of Access denied Errors
- options
- command-line
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- configure, Typical configure Options
- embedded server, Options with the Embedded Server
- libmysqld, Options with the Embedded Server
- myisamchk, myisamchk General Options
- provided by MySQL, Tutorial
- replication, Replication Features and Known Problems
- OR, Searching on Two Keys, Index Merge Optimization
- bitwise, Bit Functions
- logical, Logical Operators
- OR Index Merge optimization, Index Merge Optimization
- Oracle compatibility, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax
- ORACLE SQL mode, The Server SQL Mode
- ORD(), String Functions
- ORDER BY, Sorting Rows, ALTER TABLE Syntax, SELECT Syntax
- NULL, ORDER BY Optimization, SELECT Syntax
- order-by-primary option
- mysqldump, mysqldump — A Database Backup Program
- OUTFILE, SELECT Syntax
- Overlaps(), Functions That Test Spatial Relationships Between Geometries
- overview, General Information
P
- packages
- list of, Packages that support MySQL
- packlength option
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- page-level locking, Locking Methods
- pager option
- mysql, mysql Options
- parallel-recover option
- myisamchk, myisamchk Repair Options
- parameters
- server, Tuning Server Parameters
- parentheses ( and ), Operator Precedence
- PARTITION, Partitioning
- partition management, Partition Management
- partitioning, Partitioning
- partitioning by hash, HASH Partitioning
- partitioning by key, KEY Partitioning
- partitioning by linear hash, LINEAR HASH Partitioning
- partitioning by linear key, KEY Partitioning
- partitioning by list, LIST Partitioning
- partitioning by range, RANGE Partitioning
- partitioning concepts, Overview of Partitioning in MySQL
- partitioning information commands, Obtaining Information About Partitions
- partitioning support, Overview of Partitioning in MySQL
- partitioning types, Partition Types
- partitioning, advantages, Overview of Partitioning in MySQL
- partitioning, enabling, Overview of Partitioning in MySQL
- PARTITIONS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PARTITIONS Table
- partitions, adding and dropping, Partition Management
- partitions, analyzing, Maintenance of Partitions
- partitions, checking, Maintenance of Partitions
- partitions, managing, Partition Management
- partitions, modifying, Partition Management
- partitions, optimizing, Maintenance of Partitions
- partitions, repairing, Maintenance of Partitions
- partitions, splitting and merging, Partition Management
- 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
- mysqlslap, mysqlslap — Load Emulation Client
- PASSWORD(), Access Control, Stage 1: Connection Verification, Assigning Account Passwords, Encryption and Compression Functions, Ignoring user
- 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 on Other Unix-Like Systems, Invoking MySQL Programs, Environment Variables
- pattern matching, Pattern Matching, Regular Expressions
- performance
- benchmarks, Using Your Own Benchmarks
- disk issues, Disk Issues
- estimating, Estimating Query Performance
- improving, Replication FAQ, Make Your Data as Small as Possible
- PERIOD_ADD(), Date and Time Functions
- PERIOD_DIFF(), Date and Time Functions
- Perl
- installing, Perl Installation Notes
- installing on Windows, Installing ActiveState Perl on Windows
- Perl API, MySQL Perl API
- Perl DBI/DBD
- installation problems, Problems Using the Perl DBI/DBD Interface
- permission checks
- effect on speed, Optimizing SELECT and Other Statements
- perror, Overview of Client and Utility Programs
- 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
- mysqld, mysqld Command Options
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- PIPES_AS_CONCAT SQL mode, The Server SQL Mode
- plan option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- plugin API, The MySQL Plugin Interface
- PLUGINS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PLUGINS Table
- plugins
- adding, The MySQL Plugin Interface
- installing, INSTALL PLUGIN Syntax
- uninstalling, UNINSTALL PLUGIN Syntax
- 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, 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
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- port-open-timeout option
- mysqld, mysqld Command Options
- portability, Designing Applications for Portability
- types, Using Data Types from Other Database Engines
- porting
- to other systems, Porting to Other Systems
- 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, The Server SQL Mode
- POW(), Mathematical Functions
- POWER(), Mathematical Functions
- precedence
- operator, Operator Precedence
- precision
- arithmetic, Precision Math
- precision math, Precision Math
- PREPARE, SQL Syntax for Prepared Statements
- XA transactions, XA Transaction SQL Syntax
- preserve-schema option
- mysqlslap, mysqlslap — Load Emulation Client
- preview option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax
- constraint, PRIMARY KEY and UNIQUE Index Constraints
- primary key
- deleting, ALTER TABLE Syntax
- privilege
- changes, Access Control, Stage 2: Request Verification
- privilege information
- location, Privileges Provided by MySQL
- privilege system, What the Privilege System Does
- described, How the Privilege System Works
- privileges
- access, The MySQL Access Privilege System
- adding, Adding New User Accounts to MySQL
- default, Securing the Initial MySQL Accounts
- deleting, Removing User Accounts from MySQL, DROP USER Syntax
- display, SHOW GRANTS Syntax
- dropping, Removing User Accounts from MySQL, DROP USER Syntax
- granting, GRANT Syntax
- revoking, REVOKE Syntax
- problems
- access denied errors, Access denied
- common errors, Problems and Common Errors
- compiling, Dealing with Problems Compiling MySQL
- DATE columns, Problems Using DATE Columns
- date values, The DATETIME, DATE, and TIMESTAMP Types
- installing on IBM-AIX, IBM-AIX notes
- installing on Solaris, Solaris Notes
- installing Perl, Problems Using the Perl DBI/DBD Interface
- linking, Problems Linking to the MySQL Client Library
- ODBC, How to Report MyODBC Problems or Bugs
- 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 support, Operating Systems Supported by MySQL
- processes
- display, SHOW PROCESSLIST Syntax
- processing
- arguments, UDF Argument Processing
- PROCESSLIST, SHOW PROCESSLIST Syntax
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PROCESSLIST Table
- program variables
- setting, Using Options to Set Program Variables
- programs
- client, Overview of Client and Utility Programs, Building Client Programs
- crash-me, Designing Applications for Portability
- server side, Overview of Server-Side Programs
- utility, Overview of Client and Utility Programs
- prompt option
- mysql, mysql Options
- prompts
- meanings, Entering Queries
- pronunciation
- MySQL, Overview of the MySQL Database Management System
- 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
- mysqlslap, mysqlslap — Load Emulation Client
- PURGE MASTER LOGS, PURGE MASTER LOGS Syntax
- Python API, MySQL Python API
Q
- QUARTER(), Date and Time Functions
- queries
- entering, Entering Queries
- estimating performance, Estimating Query Performance
- examples, Examples of Common Queries
- speed of, Optimizing SELECT and Other Statements
- Twin Studies project, Queries from the Twin Project
- Query Cache, The MySQL Query Cache
- query option
- mysqlslap, mysqlslap — Load Emulation Client
- questions, mysqladmin — Client for Administering a MySQL Server
- answering, Guidelines for Using the Mailing Lists
- quick option
- myisamchk, myisamchk Repair Options
- mysql, mysql Options
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- mysqldump, mysqldump — A Database Backup Program
- quiet option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- QUOTE(), String Functions
- quote-names option
- mysqldump, mysqldump — A Database Backup Program
- quotes
- in strings, Strings
- quoting, Strings
- quoting binary data, Strings
- quoting of identifiers, Database, Table, Index, Column, and Alias Names
R
- RADIANS(), Mathematical Functions
- RAND(), Mathematical Functions
- range partitioning, RANGE Partitioning
- range partitions, adding and dropping, Management of RANGE and LIST Partitions
- range partitions, managing, Management of RANGE and LIST Partitions
- raw option
- mysql, mysql Options
- re-creating
- grant tables, Problems Running mysql_install_db
- read-from-remote-server option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- read-only option
- myisamchk, myisamchk Check Options
- mysqld, Replication Startup Options
- read_buffer_size myisamchk
variable, myisamchk General Options
- REAL data type, Overview of Numeric Types
- REAL_AS_FLOAT SQL mode, The Server SQL Mode
- reconfiguring, Dealing with Problems Compiling MySQL
- reconnect option
- mysql, mysql Options
- record_log_pos option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- RECOVER
- XA transactions, XA Transaction SQL Syntax
- recover option
- myisamchk, myisamchk Repair Options
- recovery
- from crash, Using myisamchk for Crash Recovery
- point in time, Point-in-Time Recovery
- reducing
- data size, Make Your Data as Small as Possible
- references, ALTER TABLE Syntax
- ref_or_null, IS NULL Optimization
- REGEXP, String Comparison Functions
- REGEXP operator, Regular Expressions
- regexp option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- regular expression syntax, Regular Expressions
- Related(), Functions That Test Spatial Relationships Between Geometries
- relational databases
- defined, Overview of the MySQL Database Management System
- relative option
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- relay-log option
- mysqld, Replication Startup Options
- relay-log-index option
- mysqld, Replication Startup Options
- relay-log-info-file option
- mysqld, Replication Startup Options
- relay-log-purge option
- mysqld, Replication Startup Options
- relay-log-space-limit option
- mysqld, Replication Startup Options
- release 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
- RENAME DATABASE, RENAME DATABASE Syntax
- RENAME TABLE, RENAME TABLE Syntax
- RENAME USER, RENAME USER Syntax
- renaming user accounts, RENAME USER Syntax
- reordering
- columns, How to Change the Order of Columns in a Table
- repair option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- repair options
- myisamchk, myisamchk Repair Options
- REPAIR TABLE, REPAIR TABLE Syntax
- repairing
- tables, How to Repair Tables
- REPEAT, REPEAT Statement
- REPEAT(), String Functions
- replace, Overview of Client and Utility Programs
- REPLACE, REPLACE Syntax
- replace option
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- REPLACE(), String Functions
- replicate-do-db option
- mysqld, Replication Startup Options
- replicate-do-table option
- mysqld, Replication Startup Options
- replicate-ignore-db option
- mysqld, Replication Startup Options
- replicate-ignore-table option
- mysqld, Replication Startup Options
- replicate-rewrite-db option
- mysqld, Replication Startup Options
- replicate-same-server-id option
- mysqld, Replication Startup Options
- replicate-wild-do-table option
- mysqld, Replication Startup Options
- replicate-wild-ignore-table option
- mysqld, Replication Startup Options
- replication, Replication
- replication limitations, Replication Features and Known Problems
- replication masters
- statements, SQL Statements for Controlling Master Servers
- replication options, Replication Features and Known Problems
- replication slaves
- statements, SQL Statements for Controlling Slave Servers
- report-host option
- mysqld, Replication Startup Options
- report-port option
- mysqld, Replication Startup Options
- reporting
- bugs, How to Report Bugs or Problems
- Connector/ODBC problems, How to Report MyODBC Problems or Bugs
- errors, General Information, How to Report Bugs or Problems
- MyODBC problems, How to Report MyODBC Problems or Bugs
- REQUIRE GRANT option, GRANT Syntax
- reserved words
- exceptions, Treatment of Reserved Words in MySQL
- RESET MASTER, RESET MASTER Syntax
- RESET SLAVE, RESET SLAVE Syntax
- resetmaster option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- resetslave option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- restarting
- the server, Unix Post-Installation Procedures
- RESTORE TABLE, RESTORE TABLE Syntax
- restrictions
- server-side cursors, Restrictions on Server-Side Cursors
- stored routines, Restrictions on Stored Routines and Triggers
- subqueries, Restrictions on Subqueries
- triggers, Restrictions on Stored Routines and Triggers
- views, Restrictions on Views
- result-file option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqldump, mysqldump — A Database Backup Program
- retrieving
- data from tables, Retrieving Information from a Table
- return (\r), Strings
- return values
- UDFs, UDF Return Values and Error Handling
- REVERSE(), String Functions
- REVOKE, REVOKE Syntax
- revoking
- privileges, REVOKE Syntax
- rhost option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- RIGHT JOIN, JOIN Syntax
- RIGHT OUTER JOIN, JOIN Syntax
- RIGHT(), String Functions
- RLIKE, String Comparison Functions
- ROLLBACK, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
- XA transactions, XA Transaction SQL Syntax
- rollback option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- ROLLBACK TO SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
- 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-level locking, Locking Methods
- 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
- ROW_COUNT(), Information Functions
- RPAD(), String Functions
- RPM file, Installing MySQL on Linux
- RPM Package Manager, Installing MySQL on Linux
- RTRIM(), String Functions
- RTS-threads, Comments about RTS Threads
- running
- ANSI mode, Running MySQL in ANSI Mode
- batch mode, Using mysql in Batch Mode
- multiple servers, Running Multiple MySQL Servers on the Same Machine
- queries, Entering Queries
- running configure after prior invocation, Dealing with Problems Compiling MySQL
S
- safe-mode option
- mysqld, mysqld Command Options
- safe-recover option
- myisamchk, myisamchk Repair Options
- safe-show-database option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- safe-updates option, Using the --safe-updates Option
- mysql, mysql Options
- safe-user-create option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- Sakila, History of MySQL
- SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
- scale
- arithmetic, Precision Math
- schema
- altering, ALTER DATABASE Syntax
- creating, CREATE DATABASE Syntax
- deleting, DROP DATABASE Syntax
- SCHEMA(), Information Functions
- SCHEMATA
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMATA Table
- SCHEMA_PRIVILEGES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- script files, Using mysql in Batch Mode
- scripts
- mysqlbug, How to Report Bugs or Problems
- mysql_install_db, Problems Running mysql_install_db
- searching
- and case sensitivity, Case Sensitivity in Searches
- full-text, Full-Text Search Functions
- MySQL Web pages, How to Report Bugs or Problems
- two keys, Searching on Two Keys
- SECOND(), Date and Time Functions
- secure-auth option
- mysql, mysql Options
- mysqld, mysqld Command Options, Security-Related mysqld Options
- security
- against attackers, Making MySQL Secure Against Attackers
- security system, The MySQL Access Privilege System
- SEC_TO_TIME(), Date and Time Functions
- SELECT
- LIMIT, SELECT Syntax
- optimizing, Optimizing Queries with EXPLAIN
- Query Cache, The MySQL Query Cache
- SELECT INTO, SELECT ... INTO Statement
- SELECT INTO TABLE, SELECT INTO TABLE
- SELECT speed, Speed of SELECT Queries
- selecting
- databases, Creating and Selecting a Database
- select_limit variable, mysql Options
- SEQUENCE, Using AUTO_INCREMENT
- sequence emulation, Information Functions
- sequences, Using AUTO_INCREMENT
- 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
- starting, Unix Post-Installation Procedures
- starting and stopping, Starting and Stopping MySQL Automatically
- starting problems, Starting and Troubleshooting the MySQL Server
- server variables, Server System Variables, SHOW VARIABLES Syntax
- server-id option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- server-side cursor restrictions, Restrictions on Server-Side Cursors
- server-side programs, Overview of Server-Side Programs
- servers
- multiple, Running Multiple MySQL Servers on the Same Machine
- 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
- size, Data Type Storage Requirements
- SQL_AUTO_IS_NULL, SET Syntax
- SQL_BIG_SELECTS, SET Syntax
- SQL_BUFFER_SELECT, SET Syntax
- SQL_LOG_BIN, SET Syntax
- SQL_LOG_OFF, SET Syntax
- SQL_LOG_UPDATE, SET Syntax
- SQL_NOTES, SET Syntax
- SQL_QUOTE_SHOW_CREATE, SET Syntax
- SQL_SAFE_UPDATES, SET Syntax
- SQL_SELECT_LIMIT, SET Syntax
- SQL_WARNINGS, SET Syntax
- TIMESTAMP, SET Syntax
- UNIQUE_CHECKS, SET Syntax
- SET data type, Overview of String Types, The SET Type
- SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax
- SET OPTION, SET Syntax
- SET PASSWORD, SET PASSWORD Syntax
- SET PASSWORD statement, Assigning Account Passwords
- SET SQL_LOG_BIN, SET SQL_LOG_BIN Syntax
- SET TRANSACTION, SET TRANSACTION Syntax
- set-auto-increment[ option
- myisamchk, Other myisamchk Options
- set-charset option
- mysqldump, mysqldump — A Database Backup Program
- set-collation option
- myisamchk, myisamchk Repair Options
- setting
- passwords, Assigning Account Passwords
- setting passwords, SET PASSWORD Syntax
- setting program variables, Using Options to Set Program Variables
- setup
- post-installation, Post-Installation Setup and Testing
- SHA(), Encryption and Compression Functions
- SHA1(), Encryption and Compression Functions
- shared-memory option
- mysqld, mysqld Command Options
- shared-memory-base-name option
- mysqld, mysqld Command Options
- shell syntax, Conventions Used in This Manual
- short-form option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- SHOW BINARY LOGS, SHOW MASTER LOGS Syntax
- SHOW BINLOG EVENTS, SHOW Syntax, SHOW BINLOG EVENTS Syntax
- SHOW CHARACTER SET, SHOW CHARACTER SET Syntax
- SHOW COLLATION, SHOW COLLATION Syntax
- SHOW COLUMNS, SHOW Syntax, SHOW COLUMNS Syntax
- SHOW CREATE DATABASE, SHOW Syntax, SHOW CREATE DATABASE Syntax
- SHOW CREATE EVENT, SHOW 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
- SHOW ENGINES, SHOW Syntax, SHOW ENGINES Syntax
- SHOW ERRORS, SHOW Syntax, SHOW ERRORS Syntax
- SHOW EVENTS, SHOW Syntax
- SHOW extensions, Extensions to SHOW Statements
- SHOW FIELDS, SHOW 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 MASTER LOGS Syntax
- SHOW MASTER STATUS, SHOW Syntax, SHOW MASTER STATUS Syntax
- SHOW OPEN TABLES, SHOW Syntax, SHOW OPEN TABLES Syntax
- SHOW PLUGIN, SHOW Syntax, SHOW PLUGIN Syntax
- SHOW PRIVILEGES, SHOW Syntax, SHOW PRIVILEGES Syntax
- SHOW PROCEDURE STATUS, SHOW Syntax, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- SHOW PROCESSLIST, SHOW Syntax, SHOW PROCESSLIST 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
- 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
- SHOW WARNINGS, SHOW Syntax, SHOW WARNINGS Syntax
- SHOW with WHERE, The INFORMATION_SCHEMA Database, Extensions to SHOW Statements
- show-table-type option
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- show-warnings option
- mysql, mysql Options
- shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
- shutting down
- the server, Unix Post-Installation Procedures
- sigint-ignore option
- mysql, mysql Options
- SIGN(), Mathematical Functions
- silent 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
- mysqlslap, mysqlslap — Load Emulation Client
- perror, perror — Explain Error Codes
- SIN(), Mathematical Functions
- single quote (\'), Strings
- single-transaction option
- mysqldump, mysqldump — A Database Backup Program
- size of tables, How Large MySQL Tables Can Be
- sizes
- display, Data Types
- skip-bdb option
- mysqld, 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, mysqld Command Options
- skip-external-locking option
- mysqld, mysqld Command Options
- skip-grant-tables option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- skip-host-cache option
- mysqld, mysqld Command Options
- skip-innodb option
- mysqld, mysqld Command Options
- skip-line-numbers option
- mysql, mysql Options
- skip-name-resolve option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- skip-ndbcluster option
- mysqld, mysqld Command Options
- skip-networking option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- skip-query option
- mysqlslap, mysqlslap — Load Emulation Client
- skip-safemalloc option
- mysqld, mysqld Command Options
- skip-show-database option
- mysqld, mysqld Command Options, Security-Related mysqld Options
- skip-slave-start option
- mysqld, Replication Startup Options
- skip-stack-trace option
- mysqld, mysqld Command Options
- skip-symbolic-links option
- mysqld, mysqld Command Options
- skip-thread-priority option
- mysqld, mysqld Command Options
- slave option
- mysqlslap, mysqlslap — Load Emulation Client
- slave-load-tmpdir option
- mysqld, Replication Startup Options
- slave-net-timeout option
- mysqld, Replication Startup Options
- slave-skip-errors option
- mysqld, Replication Startup Options
- slave_compressed_protocol option
- mysqld, Replication Startup Options
- sleep option
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- SLEEP(), Miscellaneous Functions
- slow queries, mysqladmin — Client for Administering a MySQL Server
- slow query log, The Slow Query Log
- SMALLINT data type, Overview of Numeric Types
- socket location
- changing, Typical configure Options
- socket option
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- mysqld, 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
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- Solaris installation problems, Solaris Notes
- Solaris troubleshooting, Dealing with Problems Compiling MySQL
- Solaris x86_64 issues, InnoDB Performance Tuning Tips
- sort-index option
- myisamchk, Other myisamchk Options
- sort-records option
- myisamchk, Other myisamchk Options
- sort-recover option
- myisamchk, myisamchk Repair Options
- sorting
- character sets, The Character Set Used for Data and Sorting
- data, Sorting Rows
- grant tables, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
- table rows, Sorting Rows
- sort_buffer_size myisamchk
variable, myisamchk General Options
- sort_key_blocks myisamchk variable, myisamchk General Options
- SOUNDEX(), String Functions
- SOUNDS LIKE, String Functions
- source 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
- SQL
- defined, Overview of the MySQL Database Management System
- SQL mode
- ONLY_FULL_GROUP_BY, GROUP BY with Hidden Fields
- SQL statements
- replication masters, SQL Statements for Controlling Master Servers
- replication slaves, SQL Statements for Controlling Slave Servers
- SQL-92
- extensions to, MySQL Standards Compliance
- sql-mode option
- mysqld, 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 with yaSSL
- SSL and X509 Basics, Using Secure Connections
- SSL command options, SSL Command Options
- ssl option
- mysqld, SSL Command Options
- SSL related options, GRANT Syntax
- ssl-ca option
- mysqld, SSL Command Options
- ssl-capath option
- mysqld, SSL Command Options
- ssl-cert option
- mysqld, SSL Command Options
- ssl-cipher option
- mysqld, SSL Command Options
- ssl-key option
- mysqld, SSL Command Options
- stability, MySQL Stability
- standalone option
- mysqld, mysqld 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 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
- 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
- StartPoint(), LineString Functions
- 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
- statements
- GRANT, Adding New User Accounts to MySQL
- INSERT, Adding New User Accounts to MySQL
- replication masters, SQL Statements for Controlling Master Servers
- replication slaves, SQL Statements for Controlling Slave Servers
- statically
- compiling, Typical configure Options
- STATISTICS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA STATISTICS Table
- stats_method myisamchk variable, myisamchk General Options
- status
- tables, SHOW TABLE STATUS Syntax
- status command
- results, mysqladmin — Client for Administering a MySQL Server
- status option
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- status variables, Server 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 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
- 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 and Table Types
- storage of data, Design Choices
- storage requirements
- data type, Data Type Storage Requirements
- storage space
- minimizing, Make Your Data as Small as Possible
- stored procedures, Stored Procedures and Functions
- stored procedures and triggers
- defined, Stored Routines and Triggers
- stored routine restrictions, Restrictions on Stored Routines and Triggers
- STRAIGHT_JOIN, SELECT Syntax, JOIN Syntax
- STRCMP(), String Comparison Functions
- STRICT SQL mode, The Server SQL Mode
- STRICT_ALL_TABLES SQL mode, The Server SQL Mode
- STRICT_TRANS_TABLES SQL mode, The Server SQL Mode
- 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
- 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
- subpartitioning, Subpartitioning
- subpartitions, Subpartitioning
- subqueries, Subquery Syntax
- subquery, Subquery Syntax
- 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
- 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, mysqld Command Options
- SymDifference(), Spatial Operators
- sync-bdb-logs option
- mysqld, BDB Startup Options
- syntax
- regular expression, Regular Expressions
- SYSDATE(), Date and Time Functions
- system
- privilege, What the Privilege System Does
- security, General Security Issues
- system optimization, System Factors and Startup Parameter Tuning
- system table, Optimizing Queries with EXPLAIN
- system variables, Server System Variables, Using System Variables, SHOW VARIABLES Syntax
- SYSTEM_USER(), Information Functions
T
- tab (\t), Strings
- tab option
- mysqldump, mysqldump — A Database Backup Program
- table
- changing, ALTER TABLE Syntax, Problems with ALTER TABLE
- deleting, DROP TABLE Syntax
- table aliases, SELECT Syntax
- table cache, How MySQL Opens and Closes Tables
- table is full, SET Syntax, The table is full
- table 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 and Table Types
- table-level locking, Locking Methods
- tables
- ARCHIVE, The ARCHIVE Storage Engine
- 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, How Large MySQL Tables Can Be
- MEMORY, The MEMORY (HEAP) Storage Engine
- MERGE, The MERGE Storage Engine
- merging, The MERGE Storage Engine
- multiple, Using More Than one Table
- MyISAM, The MyISAM Storage Engine
- names, Database, Table, Index, Column, and Alias Names
- open, How MySQL Opens and Closes Tables
- opening, How MySQL Opens and Closes Tables
- optimizing, Table Optimization
- partitioning, The MERGE Storage Engine
- repairing, How to Repair Tables
- retrieving data, Retrieving Information from a Table
- selecting columns, Selecting Particular Columns
- selecting rows, Selecting Particular Rows
- sorting rows, Sorting Rows
- symbolic links, Using Symbolic Links for Tables on Unix
- system, Optimizing Queries with EXPLAIN
- too many, Drawbacks to Creating Many Tables in the Same Database
- unique ID for last row, How to Get the Unique ID for the Last Inserted Row
- updating, Transactions and Atomic Operations
- TABLES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLES Table
- tables option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- mysqldump, mysqldump — A Database Backup Program
- table_open_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, Solaris Notes
- 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, mysqld Command Options
- temporary file
- write access, Problems Running mysql_install_db
- 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
- thread packages
- differences between, Differences Between Thread Packages
- thread support, Operating Systems Supported by MySQL
- 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 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
- TIMEDIFF(), Date and Time Functions
- timeout, Server 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
- 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, mysqld Command Options
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- to-last-log option
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- TODO
- embedded server, Things left to do in Embedded Server (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
- TRADITIONAL SQL mode, The Server SQL Mode
- transaction-isolation option
- mysqld, mysqld Command Options
- transaction-safe tables, Transactions and Atomic Operations, InnoDB Overview
- 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
- 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
- TRUNCATE(), Mathematical Functions
- tutorial, Tutorial
- Twin Studies
- queries, Queries from the Twin Project
- type conversions, Type Conversion in Expression Evaluation, Comparison Functions and Operators
- 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 and Table Types
- 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, Time Zone Problems, Environment Variables
- tz-utc option
- mysqldump, mysqldump — A Database Backup Program
U
- UCASE(), String Functions
- UCS-2, Character Set Support
- UDFs, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
- compiling, Compiling and Installing User-Defined Functions
- defined, Adding New Functions to MySQL
- return values, UDF Return Values and Error Handling
- ulimit, File Not Found
- UMASK environment variable, Problems with File Permissions, Environment Variables
- UMASK_DIR environment variable, Problems with File Permissions, Environment Variables
- unary minus (-), Arithmetic Operators
- unbuffered option
- mysql, mysql Options
- UNCOMPRESS(), Encryption and Compression Functions
- UNCOMPRESSED_LENGTH(), Encryption and Compression Functions
- UNHEX(), String Functions
- Unicode, Character Set Support
- Unicode Collation Algorithm, Unicode Character Sets
- UNINSTALL PLUGIN, UNINSTALL PLUGIN Syntax
- uninstalling plugins, UNINSTALL PLUGIN Syntax
- UNION, Searching on Two Keys, UNION Syntax
- Union(), Spatial Operators
- UNIQUE, ALTER TABLE Syntax
- constraint, PRIMARY KEY and UNIQUE Index Constraints
- unique ID, How to Get the Unique ID for the Last Inserted Row
- UNIX_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
- UNTIL, REPEAT Statement
- UPDATE, UPDATE Syntax
- update-state option
- myisamchk, myisamchk Check Options
- UpdateXML(), XML Functions
- updating
- releases of MySQL, How and When Updates Are Released
- tables, Transactions and Atomic Operations
- upgrading, Upgrading MySQL
- different architecture, Copying MySQL Databases to Another Machine
- to 5.1, Upgrading from MySQL 5.0
- UPPER(), String Functions
- uptime, mysqladmin — Client for Administering a MySQL Server
- URLs for downloading MySQL, How to Get MySQL
- USE, USE Syntax
- USE INDEX, SELECT Syntax, JOIN Syntax
- USE KEY, SELECT Syntax, JOIN Syntax
- use-frm option
- mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
- use-threads option
- mysqlslap, mysqlslap — Load Emulation Client
- user accounts
- creating, CREATE USER Syntax
- renaming, RENAME USER Syntax
- USER environment variable, Connecting to the MySQL Server, Environment Variables
- user 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
- mysqld, 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
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- 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 on Other Unix-Like Systems, Source Installation Overview
- deleting, Removing User Accounts from MySQL, DROP USER Syntax
- root, Securing the Initial MySQL Accounts
- USER_PRIVILEGES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA USER_PRIVILEGES Table
- uses
- of MySQL, What We Have Used MySQL For
- using multiple disks to start data, Using Symbolic Links for Databases on Windows
- UTC_DATE(), Date and Time Functions
- UTC_TIME(), Date and Time Functions
- UTC_TIMESTAMP(), Date and Time Functions
- UTF-8, Character Set Support
- utility programs, Overview of Client and Utility Programs
- UUID(), Miscellaneous Functions
V
- valid numbers
- examples, Numbers
- VALUES(), Miscellaneous Functions
- VARBINARY data type, Overview of String Types, The BINARY and VARBINARY Types
- VARCHAR
- size, Data Type Storage Requirements
- VARCHAR data type, Overview of String Types, String Types
- VARCHARACTER data type, Overview of String Types
- variables
- mysqld, Tuning Server Parameters
- server, Server System Variables, SHOW VARIABLES Syntax
- status, Server Status Variables, SHOW STATUS Syntax
- system, Server 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
- 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
- mysqlslap, mysqlslap — Load Emulation Client
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- perror, perror — Explain Error Codes
- version
- choosing, Choosing Which MySQL Distribution to Install
- latest, How to Get MySQL
- version option
- 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, mysqld Command Options
- 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
- mysqlslap, mysqlslap — Load Emulation Client
- perror, perror — Explain Error Codes
- VERSION(), Information Functions
- vertical option
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- 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
- virtual memory
- problems while compiling, Dealing with Problems Compiling MySQL
- Visual Basic, Programs Known to Work With MyODBC
W
- wait option
- myisamchk, myisamchk General Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- WEEK(), Date and Time Functions
- WEEKDAY(), Date and Time Functions
- WEEKOFYEAR(), Date and Time Functions
- Well-Known Binary format, Well-Known Binary (WKB) Format
- Well-Known Text format, Well-Known Text (WKT) Format
- WHERE, WHERE Clause Optimization
- with SHOW, The INFORMATION_SCHEMA Database, Extensions to SHOW Statements
- where option
- mysqldump, mysqldump — A Database Backup Program
- WHILE, WHILE Statement
- widths
- display, Data Types
- Wildcard character (%), Strings
- Wildcard character (_), Strings
- wildcards
- and LIKE, How MySQL Uses Indexes
- in mysql.columns_priv table, Access Control, Stage 2: Request Verification
- in mysql.db table, Access Control, Stage 2: Request Verification
- in mysql.host table, Access Control, Stage 2: Request Verification
- in mysql.procs_priv table, Access Control, Stage 2: Request Verification
- in mysql.tables_priv table, Access Control, Stage 2: Request Verification
- in mysql.user table, Access Control, Stage 1: Connection Verification
- Windows, MySQL Connector/ODBC
- 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
- Within(), Functions That Test Spatial Relationships Between Geometries
- without-server option, Typical configure Options
- WKB format, Well-Known Binary (WKB) Format
- WKT format, Well-Known Text (WKT) Format
- Word program, Programs Known to Work With MyODBC
- wrappers
- Eiffel, MySQL Eiffel Wrapper
- write access
- tmp, Problems Running mysql_install_db
- write_buffer_size myisamchk
variable, myisamchk General Options
X
- X(), Point Functions
- X509/Certificate, Basic SSL Concepts
- XA BEGIN, XA Transaction SQL Syntax
- XA COMMIT, XA Transaction SQL Syntax
- XA PREPARE, XA Transaction SQL Syntax
- XA RECOVER, XA Transaction SQL Syntax
- XA ROLLBACK, XA Transaction SQL Syntax
- XA START, XA Transaction SQL Syntax
- XA transactions, XA Transactions
- transaction identifiers, XA Transaction SQL Syntax
- xid
- XA transaction identifier, XA Transaction SQL Syntax
- xml option
- mysql, mysql Options
- mysqldump, mysqldump — A Database Backup Program
- XOR
- bitwise, Bit Functions
- logical, Logical Operators
|
|
