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), Parentheses
- (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, 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
- `, 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
- 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
- ADO program, Programs Known to Work With MyODBC
- AES_DECRYPT(), Encryption Functions
- AES_ENCRYPT(), Encryption 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
- in ORDER BY clauses, GROUP BY with Hidden Fields
- names, Database, Table, Index, Column, and Alias Names
- on expressions, SELECT Syntax
- ALL, SELECT Syntax
- 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
- ALTER PROCEDURE, ALTER PROCEDURE and ALTER FUNCTION
- 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 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 SQL mode, The Server SQL Mode
- ANSI_QUOTES SQL mode, The Server SQL Mode
- answering questions
- etiquette, Guidelines for Answering Questions on the Mailing List
- 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-INCREMENT
- ODBC, How to Get the Value of an AUTO_INCREMENT Column in ODBC
- 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 TABLE, BACKUP TABLE Syntax
- backups, Database Backups
- database, BACKUP TABLE Syntax
- batch
- mysql option, Options
- batch mode, Using mysql in Batch Mode
- 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
- 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
- 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
- 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, Column 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
- BOOL data type, Overview of Numeric Types
- BOOLEAN data type, Overview of Numeric Types
- Borland Builder 4 program, Programs Known to Work With MyODBC
- Borland C++ compiler, Borland C++
- Boundary(), General Geometry Functions
- brackets
- square, Column Types
- 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
- 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 identifiers, Identifier Case Sensitivity
- in names, Identifier Case Sensitivity
- in searches, Case Sensitivity in Searches
- in string comparisons, String Comparison Functions
- case-sensitivity
- in access checking, How the Privilege System Works
- 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, Comparison Functions and Operators, Cast Functions and Operators
- CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- cc1plus problems, Dealing with Problems Compiling MySQL
- CEILING(), Mathematical Functions
- Centroid(), MultiPolygon Functions
- CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CHANGE MASTER TO, CHANGE MASTER TO Syntax
- ChangeLog, MySQL Change History
- changes
- Cluster, MySQL Cluster Change History
- log, MySQL Change History
- MySQL 5.0, Changes in release 5.0.x (Production)
- 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 Socket File /tmp/mysql.sock
- 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-sets-dir
- mysql option, Options
- 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 options
- myisamchk, Check Options for myisamchk
- CHECK TABLE, CHECK TABLE Syntax
- checking
- tables for errors, How to Check MyISAM Tables for Errors
- 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
- clearing
- caches, FLUSH Syntax
- client 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
- 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
- column comments, CREATE TABLE Syntax
- column names
- case sensitivity, Identifier Case Sensitivity
- 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 Column Types from Other Database Engines
- selecting, Selecting Particular Columns
- storage requirements, Column Type Storage Requirements
- types, Column Types
- COLUMNS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table
- COLUMN_PRIVILEGES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- command syntax, Conventions Used in This Manual
- command-line history
- mysql, Options
- command-line options, mysqld Command-Line Options
- mysql, Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- commands
- for binary distribution, Installing MySQL on Other Unix-Like Systems
- replication masters, SQL Statements for Controlling Master Servers
- replication slaves, SQL Statements for Controlling Slave Servers
- commands out of sync, Commands out of sync
- Comment syntax, Comment Syntax
- comments
- adding, Comment Syntax
- starting, '--' as the Start of a Comment
- COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
- XA transactions, XA Transaction SQL Syntax
- comparison operators, Comparison Functions and Operators
- compatibility
- between MySQL versions, Upgrading from Version 4.1 to 5.0
- with mSQL, String Comparison Functions
- with ODBC, Identifier Qualifiers, Overview of Numeric Types, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
- with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax (Get Information About Columns)
- with PostgreSQL, MySQL Extensions to Standard SQL
- with standard SQL, MySQL Standards Compliance
- with Sybase, USE Syntax
- 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
- compliance
- Y2K, Year 2000 Compliance
- compress
- mysql option, Options
- COMPRESS(), String Functions
- compressed tables, Compressed Table Characteristics
- CONCAT(), String Functions
- CONCAT_WS(), String Functions
- concurrent inserts, Locking Methods
- Conditions, DECLARE Conditions
- config-file
- mysqld_multi option, mysqld_multi — Program for Managing 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, Options, mysqladmin — Client for Administering a MySQL Server
- constant table, EXPLAIN Syntax (Get Information About a SELECT), How MySQL Optimizes WHERE Clauses
- 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
- copying databases, Copying MySQL Databases to Another Machine
- copying tables, CREATE TABLE Syntax
- COS(), Mathematical Functions
- COT(), Mathematical Functions
- 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, CREATE FUNCTION/DROP FUNCTION Syntax
- CREATE INDEX, CREATE INDEX Syntax
- CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION
- CREATE SCHEMA, CREATE DATABASE Syntax
- CREATE TABLE, CREATE TABLE Syntax
- CREATE USER, CREATE USER Syntax
- CREATE VIEW, CREATE VIEW Syntax
- 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
- 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 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
- customer support
- mailing address, How to Report Bugs or Problems
- 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 Column Types from Other Database Engines
- BOOLEAN, Overview of Numeric Types, Using Column 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, Column Types
- C API, MySQL C API
- overview, Column Type Overview
- database
- altering, ALTER DATABASE Syntax
- creating, CREATE DATABASE Syntax
- deleting, DROP DATABASE Syntax
- mysql option, Options
- database design, Design Choices
- Database information
- obtaining, SHOW Syntax
- database metadata, The INFORMATION_SCHEMA Information Database
- database names
- case sensitivity, Identifier Case Sensitivity
- case-sensitivity, MySQL Extensions to Standard SQL
- 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 in MySQL
- selecting, Creating and Selecting a Database
- symbolic links, Using Symbolic Links for Databases on Unix
- using, Creating and Using a Database
- 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, Column 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 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
- mysql option, Options
- debug-info
- mysql option, Options
- debugging
- client, Debugging a MySQL Client
- server, Debugging a MySQL Server
- DEC data type, Overview of Numeric Types
- decimal arithmetic, Precision Math
- DECIMAL data type, Overview of Numeric Types, Precision Math
- decimal point, Column Types
- DECLARE, DECLARE Statement
- DECODE(), Encryption Functions
- decode_bits myisamchk variable, General Options for myisamchk
- 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, CREATE TABLE Syntax
- default values, MySQL Design Limitations and Tradeoffs, CREATE TABLE Syntax, INSERT Syntax
- BLOB and TEXT columns, The BLOB and TEXT Types
- implicit, CREATE TABLE Syntax
- suppression, Constraints on Invalid Data
- DEFAULT(), Miscellaneous Functions
- default-character-set
- mysql option, Options
- defaults
- embedded, Options with the Embedded Server
- DEGREES(), Mathematical Functions
- DELAYED, INSERT DELAYED Syntax
- delayed_insert_limit, INSERT DELAYED Syntax
- DELETE, DELETE Syntax
- deleting
- database, DROP DATABASE Syntax
- foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
- function, CREATE 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 Socket File /tmp/mysql.sock
- Delphi program, Programs Known to Work With MyODBC
- derived tables, Subqueries in the FROM clause
- DESC, DESCRIBE Syntax (Get Information About Columns)
- DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax (Get Information About Columns)
- design
- choices, Design Choices
- issues, Known Issues in MySQL
- limitations, MySQL Design Limitations and Tradeoffs
- DES_DECRYPT(), Encryption Functions
- DES_ENCRYPT(), Encryption Functions
- developers
- list of, Credits
- development source tree, Installing from the Development Source Tree
- Difference(), Spatial Operators
- digits, Column Types
- Dimension(), General Geometry Functions
- directory structure
- default, Installation Layouts
- 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, Column Types
- display triggers, SHOW TRIGGERS Syntax
- display width, Column 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, How MySQL Optimizes DISTINCT, 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, CREATE FUNCTION/DROP FUNCTION Syntax
- DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax
- DROP PRIMARY KEY, ALTER TABLE Syntax
- DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION
- DROP SCHEMA, DROP DATABASE Syntax
- DROP TABLE, DROP TABLE Syntax
- DROP USER, DROP USER Syntax
- DROP VIEW, DROP VIEW Syntax
- dropping
- user, Removing User Accounts from MySQL, DROP USER Syntax
- DUAL, SELECT Syntax
- DUMPFILE, SELECT Syntax
- dynamic table characteristics, Dynamic Table Characteristics
E
- Eiffel Wrapper, MySQL Eiffel Wrapper
- ELT(), String Functions
- email lists, The MySQL Mailing Lists
- embedded MySQL server library, libmysqld, the Embedded MySQL Server Library
- ENCODE(), Encryption Functions
- ENCRYPT(), Encryption Functions
- encryption functions, Encryption Functions
- END, BEGIN ... END Compound Statement
- EndPoint(), LineString Functions
- entering
- queries, Entering Queries
- ENUM
- size, Column 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, Options
- LD_RUN_PATH, Linux Source Distribution Notes, Solaris Notes
- MYSQL_DEBUG, Overview of the Client-Side Scripts and Utilities
- MYSQL_HISTFILE, Options
- MYSQL_HOST, Connecting to the MySQL Server
- MYSQL_PWD, Connecting to the MySQL Server, Overview of the Client-Side Scripts and Utilities
- MYSQL_TCP_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of the Client-Side Scripts and Utilities
- MYSQL_UNIX_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of the Client-Side Scripts and Utilities
- 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_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 the Client-Side Scripts and Utilities
- 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, MySQL Mailing Lists, 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
- exact-value literals, Precision Math
- example
- mysqld_multi option, mysqld_multi — Program for Managing 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
- mysql option, Options
- EXECUTE, SQL Syntax for Prepared Statements
- EXP(), Mathematical Functions
- EXPLAIN, EXPLAIN Syntax (Get Information About a SELECT)
- EXPORT_SET(), String Functions
- expression aliases, GROUP BY with Hidden Fields, SELECT Syntax
- expressions
- extended, Pattern Matching
- extensions
- to standard SQL, MySQL Standards Compliance
- ExteriorRing(), Polygon Functions
- EXTRACT(), Date and Time Functions
- extracting
- dates, Date Calculations
F
- FALSE, Numbers
- testing for, Comparison Functions and Operators
- 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
- log, Typical configure Options, Log File Maintenance
- my.cnf, Replication Features and Known Problems
- not found message, Problems with File Permissions
- permissions, Problems with File Permissions
- query log, The General Query Log
- repairing, Repair Options for myisamchk
- script, Using mysql in Batch Mode
- size limits, How Big MySQL Tables Can Be
- slow query log, The Slow Query Log
- tmp, Problems Running mysql_install_db
- update log (obsolete), The Binary Log
- filesort optimization, How MySQL Optimizes ORDER BY
- FIND_IN_SET(), String Functions
- 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 tables, mysqladmin — Client for Administering a MySQL Server
- FOR UPDATE, SELECT Syntax
- force
- mysql option, Options
- FORCE INDEX, SELECT Syntax, JOIN Syntax, Optimizer-Related Issues
- FORCE KEY, SELECT Syntax, JOIN Syntax
- 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(), Miscellaneous 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, General Options for myisamchk
- ft_min_word_len myisamchk variable, General Options for myisamchk
- ft_stopword_file myisamchk
variable, General Options for myisamchk
- 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
- deleting, CREATE FUNCTION/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 Functions
- GROUP BY, GROUP BY (Aggregate) Functions
- grouping, Parentheses
- 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/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
- geographic feature, Introduction
- GeomCollFromText(), Creating Geometry Values Using WKT Functions
- GeomCollFromWKB(), Creating Geometry Values Using WKB Functions
- geometry, Introduction
- 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
- getting MySQL, How to Get MySQL
- GET_FORMAT(), Date and Time Functions
- GET_LOCK(), Miscellaneous Functions
- GIS, Spatial Extensions in MySQL, Introduction
- GLength(), LineString Functions, MultiLineString Functions
- global privileges, GRANT and 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 and REVOKE Syntax
- GRANT statement, Adding New User Accounts to MySQL, SSL GRANT Options
- grant tables, Access Control, Stage 2: Request Verification
- re-creating, Unix Post-Installation Procedures
- sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
- upgrading, Upgrading the Grant Tables
- granting
- privileges, GRANT and REVOKE 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, How MySQL Optimizes GROUP BY
- 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, Parentheses
- GROUP_CONCAT(), GROUP BY (Aggregate) Functions
H
- HANDLER, HANDLER Syntax
- Handlers, DECLARE Handlers
- handling
- errors, UDF Return Values and Error Handling
- 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
- mysql option, Options
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- HEX(), String Functions
- hexadecimal values, Hexadecimal Values
- 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, Options, Environment Variables
- host
- mysql option, Options
- 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
- html
- mysql option, Options
I
- 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-space
- mysql option, Options
- IGNORE_SPACE SQL mode, The Server SQL Mode
- implicit default values, CREATE TABLE Syntax
- IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
- IN, Comparison Functions and Operators
- increasing
- performance, Replication FAQ
- increasing with replication
- speed, Replication in MySQL
- 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 functions, Information Functions
- INFORMATION_SCHEMA, The INFORMATION_SCHEMA Information Database, INFORMATION_SCHEMA Tables
- INNER JOIN, JOIN Syntax
- InnoDB, InnoDB Overview
- Solaris 10 x86_64 issues, Solaris Notes
- 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
- INSERT, Speed of INSERT Statements, INSERT Syntax
- INSERT ... SELECT, INSERT Syntax
- INSERT DELAYED, INSERT DELAYED Syntax
- INSERT statement
- grant privileges, Adding New User Accounts to MySQL
- INSERT(), String Functions
- inserting
- speed of, Speed of INSERT Statements
- 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 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
- 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 IRC (Internet Relay Chat)
- 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 IRC (Internet Relay Chat)
- IS boolean_value, Comparison Functions and Operators
- IS NOT boolean_value, Comparison Functions and Operators
- IS NOT NULL, Comparison Functions and Operators
- IS NULL, How MySQL Optimizes IS NULL, Comparison Functions and Operators
- and indexes, How MySQL Uses Indexes
- ISAM storage engine, Storage Engines and Table Types
- ISAM table type, Storage Engines and Table Types
- 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
K
- Key cache
- MyISAM, The MyISAM Key Cache
- key cache
- assigning indexes to, CACHE INDEX Syntax
- key space
- MyISAM, Space Needed for Keys
- keys, Column Indexes
- foreign, Foreign Keys, Using Foreign Keys
- multi-column, Multiple-Column Indexes
- searching on two, Searching on Two Keys
- keywords, Treatment of Reserved Words in MySQL
- key_buffer_size myisamchk variable, General Options for myisamchk
- KEY_COLUMN_USAGE
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- KILL, KILL Syntax
- known errors, Known Issues in MySQL
L
- language support, Setting the Error Message Language
- 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
- LEFT JOIN, How MySQL Optimizes LEFT JOIN and RIGHT JOIN, 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, How MySQL Optimizes LIMIT, 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 Big MySQL Tables Can Be
- MySQL Limits, limits in MySQL, Limits in MySQL
- 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
- 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-infile
- mysql option, Options
- 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
- locking, System Factors and Startup Parameter Tuning
- 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
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- log files, Typical configure Options
- maintaining, Log File Maintenance
- names, Database Backups
- Log files, The MySQL Log Files
- LOG(), Mathematical Functions
- 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
- LOWER(), String Functions
- LPAD(), String Functions
- LTRIM(), String Functions
M
- Mac OS X
- installation, Installing MySQL on Mac OS X
- mailing address
- for customer support, How to Report Bugs or Problems
- mailing list address, General Information
- mailing lists, The MySQL Mailing Lists
- archive location, Asking Questions or Reporting Bugs
- guidelines, Guidelines for Answering Questions on the Mailing List
- main features of MySQL, The Main Features of MySQL
- maintaining
- log files, Log File Maintenance
- tables, Setting Up a Table Maintenance Schedule
- MAKEDATE(), Date and Time Functions
- MAKETIME(), Date and Time Functions
- make_binary_distribution, Overview of the Server-Side Scripts and Utilities
- MAKE_SET(), String Functions
- manual
- available formats, About This Manual
- online location, About This Manual
- typographical conventions, Conventions Used in This Manual
- 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
- 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, Options
- MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources
- max_join_size variable, 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 Functions
- MEDIUMBLOB data type, Overview of String Types
- MEDIUMINT data type, Overview of Numeric Types
- MEDIUMTEXT data type, Overview of String Types
- 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
- messages
- languages, Setting the Error Message Language
- metadata
- database, The INFORMATION_SCHEMA Information Database
- 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, Column 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
- myisamchk, Typical configure Options, Overview of the Server-Side Scripts and Utilities
- example output, Getting Information About a Table
- options, General Options for myisamchk
- myisampack, Overview of the Client-Side Scripts and Utilities, Silent Column Specification Changes, Compressed Table Characteristics
- myisam_block_size myisamchk
variable, General Options for myisamchk
- 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 the Client-Side Scripts and Utilities
- MySQL AB
- defined, Overview of MySQL AB
- MySQL binary distribution, Choosing Which MySQL Distribution to Install
- MYSQL C type, C API Data types
- MySQL C type, C API Prepared Statement Data types
- MySQL Cluster in MySQL 5.0 and 5.1, MySQL Cluster Development Roadmap
- mysql command-line options, Options
- mysql commands
- list of, mysql Commands
- MySQL Dolphin name, History of MySQL
- MySQL history, History of MySQL
- mysql history file, 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 the Server-Side Scripts and Utilities
- mysql.sock
- changing location of, Typical configure Options
- protection, How to Protect or Change the MySQL Socket File /tmp/mysql.sock
- MYSQL323 SQL mode, The Server SQL Mode
- MYSQL40 SQL mode, The Server SQL Mode
- mysqlaccess, Overview of the Client-Side Scripts and Utilities
- mysqladmin, Overview of the Client-Side Scripts and Utilities, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- mysqladmin command-line options, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, Overview of the Client-Side Scripts and Utilities
- mysqlbug, Overview of the Server-Side Scripts and Utilities
- mysqlbug script, How to Report Bugs or Problems
- location, General Information
- mysqlcheck, Overview of the Client-Side Scripts and Utilities
- mysqlclient library, APIs and Libraries
- mysqld, Overview of the Server-Side Scripts and Utilities
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- starting, How to Run MySQL as a Normal User
- mysqld library, APIs and Libraries
- mysqld options, mysqld Command-Line Options, Tuning Server Parameters
- mysqld server
- buffer sizes, Tuning Server Parameters
- mysqld-max, Overview of the Server-Side Scripts and Utilities, The mysqld-max Extended MySQL Server
- mysqldump, Copying MySQL Databases to Another Machine, Overview of the Client-Side Scripts and Utilities
- mysqld_multi, Overview of the Server-Side Scripts and Utilities
- mysqld_safe, Overview of the Server-Side Scripts and Utilities
- mysqlhotcopy, Overview of the Client-Side Scripts and Utilities
- mysqlimport, Copying MySQL Databases to Another Machine, Overview of the Client-Side Scripts and Utilities, LOAD DATA INFILE Syntax
- mysqlshow, Overview of the Client-Side Scripts and Utilities
- 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 the Client-Side Scripts and Utilities, 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 the Server-Side Scripts and Utilities, Causes of Access denied Errors
- 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, Options, 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 the Server-Side Scripts and Utilities
- 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 the Client-Side Scripts and Utilities, 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 the Client-Side Scripts and Utilities, 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_UNIX_PORT environment variable, Problems Running mysql_install_db, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of the Client-Side Scripts and Utilities, Environment Variables
- mysql_use_result(), mysql_use_result()
- mysql_warning_count()., mysql_warning_count()
- 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
- mysql option, Options
- names, Database, Table, Index, Column, and Alias Names
- case sensitivity, Identifier Case Sensitivity
- variables, User Variables
- 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
- negative values, Numbers
- nested queries, Subquery Syntax
- net etiquette, Asking Questions or Reporting Bugs, Guidelines for Answering Questions on the Mailing List
- netmask notation
- in mysql.user table, Access Control, Stage 1: Connection Verification
- NetWare, Installing MySQL on NetWare
- net_buffer_length variable, 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
- no matching rows, Solving Problems with No Matching Rows
- no-auto-rehash
- mysql option, Options
- no-beep
- mysql option, Options
- no-log
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- no-named-commands
- mysql option, Options
- no-pager
- mysql option, Options
- no-tee
- mysql option, Options
- 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
- testing for null, Comparison Functions and Operators, Control Flow Functions
- NULL value, Working with NULL Values, NULL Values
- NULL values
- and AUTO_INCREMENT columns, Problems with NULL Values
- and indexes, CREATE TABLE Syntax
- and TIMESTAMP columns, Problems with NULL Values
- vs. empty values, Problems with NULL Values
- NULLIF(), Control Flow Functions
- numbers, Numbers
- NUMERIC data type, Overview of Numeric Types
- numeric types, Column 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, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
- odbcadmin program, Programs Known to Work With MyODBC
- OLAP, GROUP BY Modifiers
- OLD_PASSWORD(), Encryption Functions
- ON DUPLICATE KEY, INSERT Syntax
- one-database
- mysql option, Options
- online location of manual, About This Manual
- 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 Counts Open Tables, mysqladmin — Client for Administering a MySQL Server
- OpenGIS, Introduction
- opening
- tables, How MySQL Opens and Closes Tables
- opens, mysqladmin — Client for Administering a MySQL Server
- OpenSSL, Using Secure Connections, Using yaSSL
- open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files
- operating systems
- file-size limits, How Big 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
- optimization
- tips, Other Optimization Tips
- optimizations, How MySQL Optimizes WHERE Clauses, Index Merge Optimization
- OPTIMIZE TABLE, OPTIMIZE TABLE Syntax
- optimizer
- controlling, Controlling Query Optimizer Performance
- optimizing
- DISTINCT, How MySQL Optimizes DISTINCT
- filesort, How MySQL Optimizes ORDER BY
- GROUP BY, How MySQL Optimizes GROUP BY
- LEFT JOIN, How MySQL Optimizes LEFT JOIN and RIGHT JOIN
- LIMIT, How MySQL Optimizes LIMIT
- tables, Table Optimization
- option files, Using Option Files, Causes of Access denied Errors
- options
- command-line, mysqld Command-Line Options
- 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, General Options for myisamchk
- 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 (Get Information About Columns)
- ORACLE SQL mode, The Server SQL Mode
- ORD(), String Functions
- ORDER BY, Sorting Rows, ALTER TABLE Syntax, SELECT Syntax
- aliases in, GROUP BY with Hidden Fields
- OUTFILE, SELECT Syntax
- Overlaps(), Functions That Test Spatial Relationships Between Geometries
- overview, General Information
P
- packages
- list of, Packages that support MySQL
- page-level locking, Locking Methods
- pager
- mysql option, Options
- parameters
- server, Tuning Server Parameters
- parentheses ( and ), Parentheses
- password
- mysql option, Options
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- root user, Securing the Initial MySQL Accounts
- password encryption
- reversibility of, Encryption Functions
- PASSWORD(), Access Control, Stage 1: Connection Verification, Assigning Account Passwords, Encryption 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 and REVOKE Syntax, SET PASSWORD Syntax
- PATH environment variable, Installing MySQL on Other Unix-Like Systems, Invoking MySQL Programs, Environment Variables
- pattern matching, Pattern Matching
- 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 Statements and Other Queries
- perror, Overview of the Client-Side Scripts and Utilities
- PHP API, MySQL PHP API
- PI(), Mathematical Functions
- PIPES_AS_CONCAT SQL mode, The Server SQL Mode
- 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
- mysql option, Options
- portability, Designing Applications for Portability
- types, Using Column Types from Other Database Engines
- porting
- to other systems, Porting to Other Systems
- 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
- precision
- arithmetic, Precision Math
- precision math, Precision Math
- PREPARE, SQL Syntax for Prepared Statements
- XA transactions, XA Transaction SQL Syntax
- 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 and REVOKE Syntax
- revoking, GRANT and 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 Procedures 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
- program variables
- setting, Using Options to Set Program Variables
- programs
- client, Building Client Programs
- crash-me, Designing Applications for Portability
- list of, Overview of the Server-Side Scripts and Utilities
- prompt
- mysql option, Options
- prompts
- meanings, Entering Queries
- pronunciation
- MySQL, Overview of the MySQL Database Management System
- protocol
- mysql option, Options
- 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 Statements and Other Queries
- Twin Studies project, Queries from the Twin Project
- Query Cache, The MySQL Query Cache
- query log, The General Query Log
- questions, mysqladmin — Client for Administering a MySQL Server
- answering, Guidelines for Answering Questions on the Mailing List
- quick
- mysql option, Options
- QUOTE(), String Functions
- quotes
- in strings, Strings
- quoting, Strings
- quoting binary data, Strings
- quoting of identifiers, Database, Table, Index, Column, and Alias Names
R
- RADIANS(), Mathematical Functions
- RAND(), Mathematical Functions
- raw
- mysql option, Options
- re-creating
- grant tables, Unix Post-Installation Procedures
- read_buffer_size myisamchk
variable, General Options for myisamchk
- REAL data type, Overview of Numeric Types
- REAL_AS_FLOAT SQL mode, The Server SQL Mode
- reconfiguring, Dealing with Problems Compiling MySQL
- reconnect
- mysql option, Options
- RECOVER
- XA transactions, XA Transaction SQL Syntax
- 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, How MySQL Optimizes IS NULL
- regex, MySQL Regular Expressions
- REGEXP, String Comparison Functions
- regular expression syntax
- described, MySQL Regular Expressions
- Related(), Functions That Test Spatial Relationships Between Geometries
- relational databases
- defined, Overview of the MySQL Database Management System
- 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
- 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 options
- myisamchk, Repair Options for myisamchk
- REPAIR TABLE, REPAIR TABLE Syntax
- repairing
- tables, How to Repair Tables
- REPEAT, REPEAT Statement
- REPEAT(), String Functions
- replace, Overview of the Client-Side Scripts and Utilities
- REPLACE, REPLACE Syntax
- REPLACE ... SELECT, INSERT Syntax
- REPLACE(), String Functions
- replication, Replication in MySQL
- replication limitations, Replication Features and Known Problems
- replication masters
- commands, SQL Statements for Controlling Master Servers
- replication options, Replication Features and Known Problems
- replication slaves
- commands, SQL Statements for Controlling Slave Servers
- reporting
- bugs, How to Report Bugs or Problems
- Connector/ODBC problems, How to Report MyODBC Problems or Bugs
- errors, General Information, MySQL Mailing Lists
- MyODBC problems, How to Report MyODBC Problems or Bugs
- REQUIRE GRANT option, SSL GRANT Options, GRANT and REVOKE Syntax
- reserved words
- exceptions, Treatment of Reserved Words in MySQL
- RESET MASTER, RESET MASTER Syntax
- RESET SLAVE, RESET SLAVE Syntax
- 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
- 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, GRANT and REVOKE Syntax
- revoking
- privileges, GRANT and REVOKE Syntax
- 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 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
- 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-updates
- mysql option, Options
- safe-updates option, Using the --safe-updates Option
- 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, Asking Questions or Reporting Bugs
- two keys, Searching on Two Keys
- SECOND(), Date and Time Functions
- secure-auth
- mysql option, 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, EXPLAIN Syntax (Get Information About a SELECT)
- 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, 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, System Variables, SHOW VARIABLES Syntax
- server-side cursor restrictions, Restrictions on Server-Side Cursors
- servers
- multiple, Running Multiple MySQL Servers on the Same Machine
- SESSION_USER(), Information Functions
- SET, SET Syntax, Variable SET Statement
- size, Column Type Storage Requirements
- 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
- 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 Functions
- SHA1(), Encryption Functions
- shell syntax, Conventions Used in This Manual
- 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 FUNCTION, SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION
- SHOW CREATE PROCEDURE, SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION
- SHOW CREATE SCHEMA, SHOW Syntax, SHOW CREATE DATABASE Syntax
- SHOW CREATE TABLE, SHOW Syntax, SHOW CREATE TABLE Syntax
- SHOW CREATE VIEW, 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 extensions, Extensions to SHOW Statements
- SHOW FIELDS, SHOW Syntax
- SHOW FUNCTION STATUS, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS
- 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 PRIVILEGES, SHOW Syntax, SHOW PRIVILEGES Syntax
- SHOW PROCEDURE STATUS, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS
- 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 Information Database, Extensions to SHOW Statements
- show-warnings
- mysql option, Options
- shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
- shutting down
- the server, Unix Post-Installation Procedures
- sigint-ignore
- mysql option, Options
- SIGN(), Mathematical Functions
- silent
- mysql option, Options
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- silent column changes, Silent Column Specification Changes
- SIN(), Mathematical Functions
- single quote (\'), Strings
- size of tables, How Big MySQL Tables Can Be
- sizes
- display, Column Types
- skip-column-names
- mysql option, Options
- skip-line-numbers
- mysql option, Options
- 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
- mysql option, Options
- socket location
- changing, Typical configure Options
- Solaris installation problems, Solaris Notes
- Solaris troubleshooting, Dealing with Problems Compiling MySQL
- Solaris x86_64 issues, InnoDB Performance Tuning Tips
- 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, General Options for myisamchk
- sort_key_blocks myisamchk variable, General Options for myisamchk
- 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
- Spatial Extensions in MySQL, Introduction
- speed
- compiling, How Compiling and Linking Affects the Speed of MySQL
- increasing with replication, Replication in MySQL
- inserting, Speed of INSERT Statements
- linking, How Compiling and Linking Affects the Speed of MySQL
- of queries, Optimizing SELECT Statements and Other Queries, Speed of SELECT Queries
- SQL
- defined, Overview of the MySQL Database Management System
- SQL commands
- replication masters, SQL Statements for Controlling Master Servers
- replication slaves, SQL Statements for Controlling Slave Servers
- SQL-92
- extensions to, MySQL Standards Compliance
- 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, Column Types
- SRID(), General Geometry Functions
- SSH, Connecting to MySQL Remotely from Windows with SSH
- SSL and X509 Basics, Using Secure Connections
- SSL command-line options, SSL Command-Line Options
- SSL related options, SSL GRANT Options, GRANT and REVOKE Syntax
- stability, MySQL Stability
- standard SQL
- extensions to, MySQL Standards Compliance
- Standard SQL
- differences from, GRANT and REVOKE Syntax
- 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
- 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, 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
- statically
- compiling, Typical configure Options
- STATISTICS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA STATISTICS Table
- stats_method myisamchk variable, General Options for myisamchk
- status
- tables, SHOW TABLE STATUS Syntax
- status command
- results, mysqladmin — Client for Administering a MySQL Server
- 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
- 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
- column type, Column Type Storage Requirements
- storage space
- minimising, Make Your Data as Small as Possible
- stored procedures, Stored Procedures and Functions
- stored procedures and triggers
- defined, Stored Procedures 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
- 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
- SUM(), GROUP BY (Aggregate) Functions
- SUM(DISTINCT), GROUP BY (Aggregate) Functions
- superuser, Securing the Initial MySQL Accounts
- support
- for operating systems, Operating Systems Supported by MySQL
- mailing address, How to Report Bugs or Problems
- suppression
- default values, Constraints on Invalid Data
- Sybase compatibility, USE Syntax
- symbolic links, Using Symbolic Links, Using Symbolic Links for Databases on Windows
- SymDifference(), Spatial Operators
- syntax
- regular expression, MySQL 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, EXPLAIN Syntax (Get Information About a SELECT)
- system variables, Server System Variables, System Variables, SHOW VARIABLES Syntax
- SYSTEM_USER(), Information Functions
T
- tab (\t), Strings
- table
- changing, ALTER TABLE Syntax, Problems with ALTER TABLE
- deleting, DROP TABLE Syntax
- mysql option, Options
- 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 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, Check Options for myisamchk
- closing, How MySQL Opens and Closes Tables
- compressed format, Compressed Table Characteristics
- constant, EXPLAIN Syntax (Get Information About a SELECT), How MySQL Optimizes WHERE Clauses
- copying, CREATE TABLE Syntax
- counting rows, Counting Rows
- creating, Creating a Table
- CSV, The CSV Storage Engine
- defragment, Setting Up a Table Maintenance Schedule, Dynamic Table Characteristics
- defragmenting, 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 regimen, Setting Up a Table Maintenance Schedule
- maximum size, How Big 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 Counts Open 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, EXPLAIN Syntax (Get Information About a SELECT)
- 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
- table_cache, How MySQL Opens and Closes Tables
- TABLE_PRIVILEGES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- TAN(), Mathematical Functions
- tar
- problems on Solaris, Solaris Notes
- Tcl API, MySQL Tcl API
- tcp-ip
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- TCP/IP, Selecting a MySQL Server type, Testing The MySQL Installation
- technical support
- mailing address, How to Report Bugs or Problems
- tee
- mysql option, Options
- temporary file
- write access, Problems Running mysql_install_db
- temporary tables
- problems, TEMPORARY TABLE Problems
- terminal monitor
- defined, Tutorial
- 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, Column 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, Column 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, 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
- 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
- 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-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
- triggers, Stored Procedures and Triggers, SHOW TRIGGERS Syntax, Triggers
- TRIGGERS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TRIGGERS Table
- TRIM(), String Functions
- troubleshooting
- FreeBSD, Dealing with Problems Compiling MySQL
- Solaris, Dealing with Problems Compiling MySQL
- TRUE, Numbers
- testing for, Comparison Functions and Operators
- TRUNCATE, TRUNCATE Syntax
- TRUNCATE(), Mathematical Functions
- tutorial, Tutorial
- Twin Studies
- queries, Queries from the Twin Project
- type conversions, Comparison Functions and Operators
- types
- columns, Column Types, Choosing the Right Type for a Column
- data, Column Types
- date, Column Type Storage Requirements
- Date and Time, Date and Time Types
- numeric, Column Type Storage Requirements
- of tables, Storage Engines and Table Types
- portability, Using Column Types from Other Database Engines
- strings, String Types
- time, Column Type Storage Requirements
- typographical conventions, Conventions Used in This Manual
- TZ environment variable, Time Zone Problems, Environment Variables
U
- UCASE(), String Functions
- UCS-2, Character Set Support
- UDFs, CREATE FUNCTION/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
- mysql option, Options
- UNCOMPRESS(), String Functions
- UNCOMPRESSED_LENGTH(), String Functions
- UNHEX(), String Functions
- Unicode, Character Set Support
- Unicode Collation Algorithm, Unicode Character Sets
- UNION, Searching on Two Keys, UNION Syntax
- Union(), Spatial Operators
- UNIQUE, ALTER TABLE Syntax
- constraint, PRIMARY KEY and UNIQUE Index Constraints
- unique ID, How to Get the Unique ID for the Last Inserted Row
- UNIX_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
- UNTIL, REPEAT Statement
- UPDATE, UPDATE Syntax
- 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
- grant tables, Upgrading the Grant Tables
- to 5.0, Upgrading from Version 4.1 to 5.0
- upgrading tables
- ISAM, Upgrading from Version 4.1 to 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
- user
- mysql option, Options
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- user accounts
- creating, CREATE USER Syntax
- renaming, RENAME USER Syntax
- USER environment variable, Connecting to the MySQL Server, Environment Variables
- 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 Variables
- USER(), Information Functions
- user-defined functions
- adding, Adding New Functions to MySQL, Adding a New User-Defined Function
- User-defined functions, CREATE FUNCTION/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
- UTF8, Character Set Support
- UUID(), Miscellaneous Functions
V
- valid numbers
- examples, Numbers
- VARBINARY data type, Overview of String Types, The BINARY and VARBINARY Types
- VARCHAR
- size, Column 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, SHOW VARIABLES Syntax
- System, System Variables
- user, User Variables
- values, Server System Variables
- VARIANCE(), GROUP BY (Aggregate) Functions
- VAR_POP(), GROUP BY (Aggregate) Functions
- VAR_SAMP(), GROUP BY (Aggregate) Functions
- verbose
- mysql option, Options
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- version
- choosing, Choosing Which MySQL Distribution to Install
- latest, How to Get MySQL
- mysql option, Options
- mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
- VERSION(), Information Functions
- vertical
- mysql option, Options
- 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
- mysql option, Options
- WEEK(), Date and Time Functions
- WEEKDAY(), Date and Time Functions
- WEEKOFYEAR(), Date and Time Functions
- Well-Known Binary format, Well-Known Binary (WKB) Format
- Well-Known Text format, Well-Known Text (WKT) Format
- What is an X509/Certificate?, Basic SSL Concepts
- What is encryption, Basic SSL Concepts
- WHERE, How MySQL Optimizes WHERE Clauses
- with SHOW, The INFORMATION_SCHEMA Information Database, Extensions to SHOW Statements
- WHILE, WHILE Statement
- widths
- display, Column 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.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, General Options for myisamchk
X
- X(), Point Functions
- 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
- mysql option, Options
- XOR
- bitwise, Bit Functions
- logical, Logical Operators