MySQL 5.1 with Maria Reference Manual
Section Navigation [Toggle]
- MySQL 5.1 with Maria Reference Manual
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 Partitioning
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
Copyright © 1997-2008 MySQL AB, 2009 Sun Microsystems, Inc. All rights reserved. U.S. Government Rights - Commercial software. Government users are subject to the Sun Microsystems, Inc. standard license agreement and applicable provisions of the FAR and its supplements. Use is subject to license terms. Sun, Sun Microsystems, the Sun logo, Java, Solaris, StarOffice, MySQL Enterprise Monitor 2.0, MySQL logo™ and MySQL™ are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. UNIX is a registered trademark in the U.S. and other countries, exclusively licensed through X/Open Company, Ltd.
Copyright © 1997-2008 MySQL AB, 2009 Sun Microsystems, Inc. Tous droits réservés. L'utilisation est soumise aux termes du contrat de licence.Sun, Sun Microsystems, le logo Sun, Java, Solaris, StarOffice, MySQL Enterprise Monitor 2.0, MySQL logo™ et MySQL™ sont des marques de fabrique ou des marques déposées de Sun Microsystems, Inc. aux Etats-Unis et dans d'autres pays. UNIX est une marque déposée aux Etats-Unis et dans d'autres pays et licenciée exlusivement par X/Open Company, Ltd.
This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms: You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how Sun disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of Sun Microsystems, Inc. Sun Microsystems, Inc. and MySQL AB reserve any and all rights to this documentation not expressly granted above.
For more information on the terms of this license, for details on how the MySQL documentation is built and produced, or if you are interested in doing a translation, please contact the Documentation Team.
For additional licensing information, including licenses for libraries used by MySQL, see Preface, Notes, Licenses.
If you want help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists where you can discuss your issues with other MySQL users.
For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML, CHM, and PDF formats, see MySQL Documentation Library.
Abstract
This is the MySQL Reference Manual. It documents MySQL
5.1 through 5.1.32. This manual also
includes specific information on the Maria
storage engine.
MySQL 5.1 with Maria does not include support
for MySQL Cluster; for information about MySQL Cluster, please
see MySQL Cluster NDB 6.X/7.X.
MySQL 5.1 Features — This manual describes features that are not included in every edition of MySQL 5.1 and such features may not be included in the edition of MySQL 5.1 licensed to you. If you have any questions about the features included in your edition of MySQL 5.1, refer to your MySQL 5.1 license agreement or contact your Sun Microsystems sales representative."
Document generated on: 2009-09-17 (revision: 16644)
Table of Contents [+/-]
- Preface, Notes, Licenses [+/-]
- 1. General Information [+/-]
- 2. Installing and Upgrading MySQL [+/-]
- 2.1. General Installation Issues [+/-]
- 2.2. Standard MySQL Installation Using a Binary Distribution
- 2.3. Installing MySQL on Windows [+/-]
- 2.3.1. Choosing An Installation Package
- 2.3.2. Installing MySQL with the Automated Installer
- 2.3.3. Using the MySQL Installation Wizard
- 2.3.4. MySQL Server Instance Configuration Wizard
- 2.3.5. Installing MySQL from a Noinstall Zip Archive
- 2.3.6. Extracting the Install Archive
- 2.3.7. Creating an Option File
- 2.3.8. Selecting a MySQL Server Type
- 2.3.9. Starting the Server for the First Time
- 2.3.10. Starting MySQL from the Windows Command Line
- 2.3.11. Starting MySQL as a Windows Service
- 2.3.12. Testing The MySQL Installation
- 2.3.13. Troubleshooting a MySQL Installation Under Windows
- 2.3.14. Upgrading MySQL on Windows
- 2.3.15. MySQL on Windows Compared to MySQL on Unix
- 2.4. Installing MySQL from RPM Packages on Linux
- 2.5. Installing MySQL on Mac OS X
- 2.6. Installing MySQL on Solaris
- 2.7. Installing MySQL on i5/OS
- 2.8. Installing MySQL on NetWare
- 2.9. Installing MySQL from
tar.gzPackages on Other Unix-Like Systems - 2.10. MySQL Installation Using a Source Distribution [+/-]
- 2.11. Post-Installation Setup and Testing [+/-]
- 2.12. Upgrading or Downgrading MySQL [+/-]
- 2.13. Operating System-Specific Notes [+/-]
- 2.14. Environment Variables
- 2.15. Perl Installation Notes [+/-]
- 3. Tutorial [+/-]
- 3.1. Connecting to and Disconnecting from the Server
- 3.2. Entering Queries
- 3.3. Creating and Using a Database [+/-]
- 3.4. Getting Information About Databases and Tables
- 3.5. Using mysql in Batch Mode
- 3.6. Examples of Common Queries [+/-]
- 3.6.1. The Maximum Value for a Column
- 3.6.2. The Row Holding the Maximum of a Certain Column
- 3.6.3. Maximum of Column per Group
- 3.6.4. The Rows Holding the Group-wise Maximum of a Certain Column
- 3.6.5. Using User-Defined Variables
- 3.6.6. Using Foreign Keys
- 3.6.7. Searching on Two Keys
- 3.6.8. Calculating Visits Per Day
- 3.6.9. Using
AUTO_INCREMENT
- 3.7. Queries from the Twin Project [+/-]
- 3.8. Using MySQL with Apache
- 4. MySQL Programs [+/-]
- 4.1. Overview of MySQL Programs
- 4.2. Using MySQL Programs [+/-]
- 4.3. MySQL Server and Server-Startup Programs [+/-]
- 4.4. MySQL Installation-Related Programs [+/-]
- 4.4.1. comp_err — Compile MySQL Error Message File
- 4.4.2. make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- 4.4.3. mysqlbug — Generate Bug Report
- 4.4.4. mysql_fix_privilege_tables — Upgrade MySQL System Tables
- 4.4.5. mysql_install_db — Initialize MySQL Data Directory
- 4.4.6. mysql_secure_installation — Improve MySQL Installation Security
- 4.4.7. mysql_tzinfo_to_sql — Load the Time Zone Tables
- 4.4.8. mysql_upgrade — Check Tables for MySQL Upgrade
- 4.5. MySQL Client Programs [+/-]
- 4.5.1. mysql — The MySQL Command-Line Tool
- 4.5.2. mysqladmin — Client for Administering a MySQL Server
- 4.5.3. mysqlcheck — A Table Maintenance Program
- 4.5.4. mysqldump — A Database Backup Program
- 4.5.5. mysqlimport — A Data Import Program
- 4.5.6. mysqlshow — Display Database, Table, and Column Information
- 4.5.7. mysqlslap — Load Emulation Client
- 4.6. MySQL Administrative and Utility Programs [+/-]
- 4.6.1. innochecksum — Offline InnoDB File Checksum Utility
- 4.6.2. myisam_ftdump — Display Full-Text Index information
- 4.6.3. myisamchk — MyISAM Table-Maintenance Utility
- 4.6.4. myisamlog — Display MyISAM Log File Contents
- 4.6.5. myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.6. mysqlaccess — Client for Checking Access Privileges
- 4.6.7. mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.8. mysqldumpslow — Summarize Slow Query Log Files
- 4.6.9. mysqlhotcopy — A Database Backup Program
- 4.6.10. mysqlmanager — The MySQL Instance Manager
- 4.6.11. mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.12. mysql_find_rows — Extract SQL Statements from Files
- 4.6.13. mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.14. mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.15. mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.16. mysql_zap — Kill Processes That Match a Pattern
- 4.7. MySQL Program Development Utilities [+/-]
- 4.8. Miscellaneous Programs [+/-]
- 5. MySQL Server Administration [+/-]
- 5.1. The MySQL Server [+/-]
- 5.1.1. Server Option and Variable Reference
- 5.1.2. Server Command Options
- 5.1.3. Server Options for Loading Plugins
- 5.1.4. Server System Variables
- 5.1.5. Session System Variables
- 5.1.6. Using System Variables
- 5.1.7. Server Status Variables
- 5.1.8. Server SQL Modes
- 5.1.9. Server-Side Help
- 5.1.10. Server Response to Signals
- 5.1.11. The Shutdown Process
- 5.2. MySQL Server Logs [+/-]
- 5.3. General Security Issues [+/-]
- 5.4. The MySQL Access Privilege System [+/-]
- 5.5. MySQL User Account Management [+/-]
- 5.5.1. User Names and Passwords
- 5.5.2. Adding User Accounts
- 5.5.3. Removing User Accounts
- 5.5.4. Limiting Account Resources
- 5.5.5. Assigning Account Passwords
- 5.5.6. Password Security in MySQL
- 5.5.7. Using SSL for Secure Connections
- 5.5.8. Connecting to MySQL Remotely from Windows with SSH
- 5.5.9. Auditing MySQL Account Activity
- 5.6. Running Multiple MySQL Servers on the Same Machine [+/-]
- 6. Backup and Recovery [+/-]
- 7. Optimization [+/-]
- 7.1. Optimization Overview [+/-]
- 7.2. Optimizing
SELECTand Other Statements [+/-] - 7.2.1. Optimizing Queries with
EXPLAIN - 7.2.2. Estimating Query Performance
- 7.2.3. Speed of
SELECTQueries - 7.2.4.
WHEREClause Optimization - 7.2.5. Range Optimization
- 7.2.6. Index Merge Optimization
- 7.2.7. Condition Pushdown Optimization
- 7.2.8.
IS NULLOptimization - 7.2.9.
LEFT JOINandRIGHT JOINOptimization - 7.2.10. Nested-Loop Join Algorithms
- 7.2.11. Nested Join Optimization
- 7.2.12. Outer Join Simplification
- 7.2.13.
ORDER BYOptimization - 7.2.14.
GROUP BYOptimization - 7.2.15.
DISTINCTOptimization - 7.2.16. Optimizing
IN/=ANYSubqueries - 7.2.17.
LIMITOptimization - 7.2.18. Using
optimizer_switchto Control the Optimizer - 7.2.19. How to Avoid Table Scans
- 7.2.20.
INFORMATION_SCHEMAOptimization - 7.2.21. Speed of
INSERTStatements - 7.2.22. Speed of
UPDATEStatements - 7.2.23. Speed of
DELETEStatements - 7.2.24. Other Optimization Tips
- 7.2.1. Optimizing Queries with
- 7.3. Locking Issues [+/-]
- 7.4. Optimizing Database Structure [+/-]
- 7.4.1. Make Your Data as Small as Possible
- 7.4.2. Column Indexes
- 7.4.3. Multiple-Column Indexes
- 7.4.4. How MySQL Uses Indexes
- 7.4.5. The
MyISAMKey Cache - 7.4.6.
MyISAMIndex Statistics Collection - 7.4.7. How MySQL Opens and Closes Tables
- 7.4.8. Disadvantages of Creating Many Tables in the Same Database
- 7.5. Optimizing the MySQL Server [+/-]
- 7.5.1. How Compiling and Linking Affects the Speed of MySQL
- 7.5.2. System Factors and Startup Parameter Tuning
- 7.5.3. Tuning Server Parameters
- 7.5.4. Controlling Query Optimizer Performance
- 7.5.5. The MySQL Query Cache
- 7.5.6. Examining Thread Information
- 7.5.7. How MySQL Uses Threads for Client Connections
- 7.5.8. How MySQL Uses Memory
- 7.5.9. Enabling Large Page Support
- 7.5.10. How MySQL Uses Internal Temporary Tables
- 7.5.11. How MySQL Uses DNS
- 7.6. Disk Issues [+/-]
- 8. Language Structure [+/-]
- 9. Internationalization and Localization [+/-]
- 9.1. Character Set Support [+/-]
- 9.1.1. Character Sets and Collations in General
- 9.1.2. Character Sets and Collations in MySQL
- 9.1.3. Specifying Character Sets and Collations
- 9.1.4. Connection Character Sets and Collations
- 9.1.5. Configuring the Character Set and Collation for Applications
- 9.1.6. Character Set for Error Messages
- 9.1.7. Collation Issues
- 9.1.8. String Repertoire
- 9.1.9. Operations Affected by Character Set Support
- 9.1.10. Unicode Support
- 9.1.11. UTF-8 for Metadata
- 9.1.12. Column Character Set Conversion
- 9.1.13. Character Sets and Collations That MySQL Supports
- 9.2. The Character Set Used for Data and Sorting
- 9.3. Setting the Error Message Language
- 9.4. Adding a New Character Set [+/-]
- 9.5. How to Add a New Collation to a Character Set [+/-]
- 9.6. Problems With Character Sets
- 9.7. MySQL Server Time Zone Support [+/-]
- 9.8. MySQL Server Locale Support
- 10. Data Types [+/-]
- 11. Functions and Operators [+/-]
- 11.1. Operator and Function Reference
- 11.2. Operators [+/-]
- 11.3. Control Flow Functions
- 11.4. String Functions [+/-]
- 11.5. Numeric Functions [+/-]
- 11.6. Date and Time Functions
- 11.7. What Calendar Is Used By MySQL?
- 11.8. Full-Text Search Functions [+/-]
- 11.9. Cast Functions and Operators
- 11.10. XML Functions
- 11.11. Other Functions [+/-]
- 11.12. Functions and Modifiers for Use with
GROUP BYClauses [+/-] - 11.13. Spatial Extensions [+/-]
- 11.14. Precision Math [+/-]
- 12. SQL Statement Syntax [+/-]
- 12.1. Data Definition Statements [+/-]
- 12.1.1.
ALTER DATABASESyntax - 12.1.2.
ALTER EVENTSyntax - 12.1.3.
ALTER LOGFILE GROUPSyntax - 12.1.4.
ALTER FUNCTIONSyntax - 12.1.5.
ALTER PROCEDURESyntax - 12.1.6.
ALTER SERVERSyntax - 12.1.7.
ALTER TABLESyntax - 12.1.8.
ALTER TABLESPACESyntax - 12.1.9.
ALTER VIEWSyntax - 12.1.10.
CREATE DATABASESyntax - 12.1.11.
CREATE EVENTSyntax - 12.1.12.
CREATE FUNCTIONSyntax - 12.1.13.
CREATE INDEXSyntax - 12.1.14.
CREATE LOGFILE GROUPSyntax - 12.1.15.
CREATE PROCEDUREandCREATE FUNCTIONSyntax - 12.1.16.
CREATE SERVERSyntax - 12.1.17.
CREATE TABLESyntax - 12.1.18.
CREATE TABLESPACESyntax - 12.1.19.
CREATE TRIGGERSyntax - 12.1.20.
CREATE VIEWSyntax - 12.1.21.
DROP DATABASESyntax - 12.1.22.
DROP EVENTSyntax - 12.1.23.
DROP FUNCTIONSyntax - 12.1.24.
DROP INDEXSyntax - 12.1.25.
DROP LOGFILE GROUPSyntax - 12.1.26.
DROP PROCEDUREandDROP FUNCTIONSyntax - 12.1.27.
DROP SERVERSyntax - 12.1.28.
DROP TABLESyntax - 12.1.29.
DROP TABLESPACESyntax - 12.1.30.
DROP TRIGGERSyntax - 12.1.31.
DROP VIEWSyntax - 12.1.32.
RENAME DATABASESyntax - 12.1.33.
RENAME TABLESyntax
- 12.1.1.
- 12.2. Data Manipulation Statements [+/-]
- 12.3. MySQL Utility Statements [+/-]
- 12.4. MySQL Transactional and Locking Statements [+/-]
- 12.4.1.
START TRANSACTION,COMMIT, andROLLBACKSyntax - 12.4.2. Statements That Cannot Be Rolled Back
- 12.4.3. Statements That Cause an Implicit Commit
- 12.4.4.
SAVEPOINTandROLLBACK TO SAVEPOINTSyntax - 12.4.5.
LOCK TABLESandUNLOCK TABLESSyntax - 12.4.6.
SET TRANSACTIONSyntax - 12.4.7. XA Transactions
- 12.4.1.
- 12.5. Database Administration Statements [+/-]
- 12.6. Replication Statements [+/-]
- 12.7. SQL Syntax for Prepared Statements [+/-]
- 12.8. MySQL Compound-Statement Syntax [+/-]
- 13. Storage Engines [+/-]
- 13.1. Overview of MySQL Storage Engine Architecture [+/-]
- 13.2. Supported Storage Engines [+/-]
- 13.3. Setting the Storage Engine
- 13.4. The
MyISAMStorage Engine [+/-] - 13.5. The
MariaStorage Engine [+/-] - 13.6. The
InnoDBStorage Engine [+/-] - 13.6.1.
InnoDBContact Information - 13.6.2.
InnoDBConfiguration - 13.6.3.
InnoDBStartup Options and System Variables - 13.6.4. Creating and Using
InnoDBTables - 13.6.5. Adding, Removing, or Resizing
InnoDBData and Log Files - 13.6.6. Backing Up and Recovering an
InnoDBDatabase - 13.6.7. Moving an
InnoDBDatabase to Another Machine - 13.6.8. The
InnoDBTransaction Model and Locking - 13.6.9.
InnoDBMulti-Versioning - 13.6.10.
InnoDBTable and Index Structures - 13.6.11.
InnoDBDisk I/O and File Space Management - 13.6.12.
InnoDBError Handling - 13.6.13.
InnoDBPerformance Tuning and Troubleshooting - 13.6.14. Restrictions on
InnoDBTables
- 13.6.1.
- 13.7. The
MERGEStorage Engine [+/-] - 13.8. The
MEMORY(HEAP) Storage Engine - 13.9. The
EXAMPLEStorage Engine - 13.10. The
FEDERATEDStorage Engine [+/-] - 13.11. The
ARCHIVEStorage Engine - 13.12. The
CSVStorage Engine [+/-] - 13.13. The
BLACKHOLEStorage Engine
- 14. High Availability and Scalability [+/-]
- 15. MySQL Enterprise Monitor [+/-]
- 15.1. An Overview of the Service [+/-]
- 15.2. Conventions Used in This Document
- 15.3. Installation and Upgrades [+/-]
- 15.4. MySQL Enterprise Dashboard [+/-]
- 15.5. The Settings Page [+/-]
- 15.6. The Advisors Page [+/-]
- 15.7. The Events Page [+/-]
- 15.8. The Graphs Page [+/-]
- 15.9. The Query Analyzer Page [+/-]
- 15.10. The Replication Page [+/-]
- 15.11. MySQL Enterprise Monitor Reference [+/-]
- 15.11.1. MySQL Enterprise Monitor Limitations
- 15.11.2. Supported Browsers
- 15.11.3. Installation Requirements
- 15.11.4. Choosing Suitable MySQL Enterprise Service Manager Hardware Configurations
- 15.11.5. Backing up MySQL Enterprise Service Manager
- 15.11.6. Migrating 1.3.x Historical Data to MySQL Enterprise Monitor 2.0
- 15.11.7. Regular MySQL Enterprise Monitor Maintenance
- 15.12. MySQL Enterprise Monitor Frequently Asked Questions
- 16. Replication [+/-]
- 16.1. Replication Configuration [+/-]
- 16.2. Replication Solutions [+/-]
- 16.2.1. Using Replication for Backups
- 16.2.2. Using Replication with Different Master and Slave Storage Engines
- 16.2.3. Using Replication for Scale-Out
- 16.2.4. Replicating Different Databases to Different Slaves
- 16.2.5. Improving Replication Performance
- 16.2.6. Switching Masters During Failover
- 16.2.7. Setting Up Replication Using SSL
- 16.3. Replication Notes and Tips [+/-]
- 16.4. Replication Implementation [+/-]
- 17. Partitioning [+/-]
- 18. Stored Programs and Views [+/-]
- 19.
INFORMATION_SCHEMATables [+/-] - 19.1. The
INFORMATION_SCHEMA SCHEMATATable - 19.2. The
INFORMATION_SCHEMA TABLESTable - 19.3. The
INFORMATION_SCHEMA COLUMNSTable - 19.4. The
INFORMATION_SCHEMA STATISTICSTable - 19.5. The
INFORMATION_SCHEMA USER_PRIVILEGESTable - 19.6. The
INFORMATION_SCHEMA SCHEMA_PRIVILEGESTable - 19.7. The
INFORMATION_SCHEMA TABLE_PRIVILEGESTable - 19.8. The
INFORMATION_SCHEMA COLUMN_PRIVILEGESTable - 19.9. The
INFORMATION_SCHEMA CHARACTER_SETSTable - 19.10. The
INFORMATION_SCHEMA COLLATIONSTable - 19.11. The
INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITYTable - 19.12. The
INFORMATION_SCHEMA TABLE_CONSTRAINTSTable - 19.13. The
INFORMATION_SCHEMA KEY_COLUMN_USAGETable - 19.14. The
INFORMATION_SCHEMA ROUTINESTable - 19.15. The
INFORMATION_SCHEMA VIEWSTable - 19.16. The
INFORMATION_SCHEMA TRIGGERSTable - 19.17. The
INFORMATION_SCHEMA PLUGINSTable - 19.18. The
INFORMATION_SCHEMA ENGINESTable - 19.19. The
INFORMATION_SCHEMA PARTITIONSTable - 19.20. The
INFORMATION_SCHEMA EVENTSTable - 19.21. The
INFORMATION_SCHEMA FILESTable - 19.22. The
INFORMATION_SCHEMA PROCESSLISTTable - 19.23. The
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTSTable - 19.24. The
INFORMATION_SCHEMA GLOBAL_STATUSandSESSION_STATUSTables - 19.25. The
INFORMATION_SCHEMA GLOBAL_VARIABLESandSESSION_VARIABLESTables - 19.26. The
INFORMATION_SCHEMA PROFILINGTable - 19.27. Other
INFORMATION_SCHEMATables - 19.28. Extensions to
SHOWStatements
- 19.1. The
- 20. Connectors and APIs [+/-]
- 20.1. MySQL Connector/ODBC [+/-]
- 20.2. MySQL Connector/NET [+/-]
- 20.3. MySQL Visual Studio Plugin [+/-]
- 20.4. MySQL Connector/J [+/-]
- 20.5. MySQL Connector/MXJ [+/-]
- 20.6. MySQL Connector/C++ [+/-]
- 20.6.1. MySQL Connector/C++ Binary Installation
- 20.6.2. MySQL Connector/C++ Source Installation
- 20.6.3. MySQL Connector/C++ Building Windows applications with Microsoft Visual Studio
- 20.6.4. MySQL Connector/C++ Building Linux applications with NetBeans
- 20.6.5. MySQL Connector/C++ Getting Started: Usage Examples
- 20.6.6. MySQL Connector/C++ Tutorials
- 20.6.7. MySQL Connector/C++ Debug Tracing
- 20.6.8. MySQL Connector/C++ Usage Notes
- 20.6.9. MySQL Connector/C++ Known Bugs and Issues
- 20.6.10. MySQL Connector/C++ Feature requests
- 20.6.11. MySQL Connector/C++ Support
- 20.6.12. MySQL Connector/C++ FAQ
- 20.7. MySQL Connector/C [+/-]
- 20.8. MySQL Connector/OpenOffice.org [+/-]
- 20.9. libmysqld, the Embedded MySQL Server Library [+/-]
- 20.10. MySQL C API [+/-]
- 20.10.1. C API Data Types
- 20.10.2. C API Function Overview
- 20.10.3. C API Function Descriptions
- 20.10.4. C API Prepared Statements
- 20.10.5. C API Prepared Statement Data types
- 20.10.6. C API Prepared Statement Function Overview
- 20.10.7. C API Prepared Statement Function Descriptions
- 20.10.8. C API Threaded Function Descriptions
- 20.10.9. C API Embedded Server Function Descriptions
- 20.10.10. Common Questions and Problems When Using the C API
- 20.10.11. Controlling Automatic Reconnection Behavior
- 20.10.12. C API Support for Multiple Statement Execution
- 20.10.13. C API Prepared Statement Problems
- 20.10.14. C API Prepared Statement Handling of Date and Time Values
- 20.10.15. C API Support for Prepared
CALLStatements - 20.10.16. Building Client Programs
- 20.11. MySQL PHP API [+/-]
- 20.12. MySQL Perl API
- 20.13. MySQL C++ API
- 20.14. MySQL Python API
- 20.15. MySQL Ruby APIs [+/-]
- 20.16. MySQL Tcl API
- 20.17. MySQL Eiffel Wrapper
- 21. Extending MySQL [+/-]
- A. MySQL 5.1 Frequently Asked Questions [+/-]
- A.1. MySQL 5.1 FAQ — General
- A.2. MySQL 5.1 FAQ — Storage Engines
- A.3. MySQL 5.1 FAQ — Server SQL Mode
- A.4. MySQL 5.1 FAQ — Stored Procedures and Functions
- A.5. MySQL 5.1 FAQ — Triggers
- A.6. MySQL 5.1 FAQ — Views
- A.7. MySQL 5.0 FAQ —
INFORMATION_SCHEMA - A.8. MySQL 5.1 FAQ — Migration
- A.9. MySQL 5.1 FAQ — Security
- A.10. MySQL 5.1 FAQ — MySQL Cluster
- A.11. MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
- A.12. MySQL 5.1 FAQ — Connectors & APIs
- A.13. MySQL 5.1 FAQ — Replication
- A.14. MySQL 5.1 FAQ — MySQL, DRBD, and Heartbeat [+/-]
- A.14.1. Distributed Replicated Block Device (DRBD)
- A.14.2. Linux Heartbeat
- A.14.3. DRBD Architecture
- A.14.4. DRBD and MySQL Replication
- A.14.5. DRBD and File Systems
- A.14.6. DRBD and LVM
- A.14.7. DRBD and Virtualization
- A.14.8. DRBD and Security
- A.14.9. DRBD and System Requirements
- A.14.10. DBRD and Support and Consulting
- B. Errors, Error Codes, and Common Problems [+/-]
- C. MySQL Change History [+/-]
- C.1. Changes in Release 5.1.x-maria (Development) [+/-]
- C.2. Changes in Release 5.1.x (Production) [+/-]
- C.2.1. Changes in MySQL 5.1.39 (Not yet released)
- C.2.2. Changes in MySQL 5.1.38 (01 September 2009)
- C.2.3. Changes in MySQL 5.1.37 (13 July 2009)
- C.2.4. Changes in MySQL 5.1.36 (16 June 2009)
- C.2.5. Changes in MySQL 5.1.35 (13 May 2009)
- C.2.6. Release Notes for MySQL Enterprise 5.1.34sp1 [QSP] (25 June 2009)
- C.2.7. Changes in MySQL 5.1.34 (02 April 2009)
- C.2.8. Changes in MySQL 5.1.33 (13 March 2009)
- C.2.9. Changes in MySQL 5.1.32 (14 February 2009)
- C.2.10. Release Notes for MySQL Enterprise 5.1.31sp1 [QSP] (19 March 2009)
- C.2.11. Changes in MySQL 5.1.31 (19 January 2009)
- C.2.12. Changes in MySQL 5.1.30 (14 November 2008 General Availability)
- C.2.13. Changes in MySQL 5.1.29 (11 October 2008)
- C.2.14. Changes in MySQL 5.1.28 (28 August 2008)
- C.2.15. Changes in MySQL 5.1.27 (Not released)
- C.2.16. Changes in MySQL 5.1.26 (30 June 2008)
- C.2.17. Changes in MySQL 5.1.25 (28 May 2008)
- C.2.18. Changes in MySQL 5.1.24 (08 April 2008)
- C.2.19. Changes in MySQL 5.1.23 (29 January 2008)
- C.2.20. Changes in MySQL 5.1.22 (24 September 2007 Release Candidate)
- C.2.21. Changes in MySQL 5.1.21 (16 August 2007)
- C.2.22. Changes in MySQL 5.1.20 (25 June 2007)
- C.2.23. Changes in MySQL 5.1.19 (25 May 2007)
- C.2.24. Changes in MySQL 5.1.18 (08 May 2007)
- C.2.25. Changes in MySQL 5.1.17 (04 April 2007)
- C.2.26. Changes in MySQL 5.1.16 (26 February 2007)
- C.2.27. Changes in MySQL 5.1.15 (25 January 2007)
- C.2.28. Changes in MySQL 5.1.14 (05 December 2006)
- C.2.29. Changes in MySQL 5.1.13 (Not released)
- C.2.30. Changes in MySQL 5.1.12 (24 October 2006)
- C.2.31. Changes in MySQL 5.1.11 (26 May 2006)
- C.2.32. Changes in MySQL 5.1.10 (Not released)
- C.2.33. Changes in MySQL 5.1.9 (12 April 2006)
- C.2.34. Changes in MySQL 5.1.8 (Not released)
- C.2.35. Changes in MySQL 5.1.7 (27 February 2006)
- C.2.36. Changes in MySQL 5.1.6 (01 February 2006)
- C.2.37. Changes in MySQL 5.1.5 (10 January 2006)
- C.2.38. Changes in MySQL 5.1.4 (21 December 2005)
- C.2.39. Changes in MySQL 5.1.3 (29 November 2005)
- C.2.40. Changes in MySQL 5.1.2 (Not released)
- C.2.41. Changes in MySQL 5.1.1 (Not released)
- C.3. MySQL Enterprise Monitor Change History [+/-]
- C.3.1. Changes in MySQL Enterprise Monitor 2.0.6 (Not yet released)
- C.3.2. Changes in MySQL Enterprise Monitor 2.0.5 (18th March 2009)
- C.3.3. Changes in MySQL Enterprise Monitor 2.0.4 (5th February 2009)
- C.3.4. Changes in MySQL Enterprise Monitor 2.0.3 (23rd January 2009)
- C.3.5. Changes in MySQL Enterprise Monitor 2.0.2 (14th January 2009)
- C.3.6. Changes in MySQL Enterprise Monitor 2.0.1 (15th December 2008)
- C.3.7. Changes in MySQL Enterprise Monitor 2.0.0 (11th December 2008)
- C.4. MySQL Connector/ODBC (MyODBC) Change History [+/-]
- C.4.1. Changes in MySQL Connector/ODBC 5.1.6 (Not yet released)
- C.4.2. Changes in MySQL Connector/ODBC 5.1.5 (18 August 2008)
- C.4.3. Changes in MySQL Connector/ODBC 5.1.4 (15 April 2008)
- C.4.4. Changes in MySQL Connector/ODBC 5.1.3 (26 March 2008)
- C.4.5. Changes in MySQL Connector/ODBC 5.1.2 (13 February 2008)
- C.4.6. Changes in MySQL Connector/ODBC 5.1.1 (13 December 2007)
- C.4.7. Changes in MySQL Connector/ODBC 5.1.0 (10 September 2007)
- C.4.8. Changes in MySQL Connector/ODBC 5.0.12 (Never released)
- C.4.9. Changes in MySQL Connector/ODBC 5.0.11 (31 January 2007)
- C.4.10. Changes in MySQL Connector/ODBC 5.0.10 (14 December 2006)
- C.4.11. Changes in MySQL Connector/ODBC 5.0.9 (22 November 2006)
- C.4.12. Changes in MySQL Connector/ODBC 5.0.8 (17 November 2006)
- C.4.13. Changes in MySQL Connector/ODBC 5.0.7 (08 November 2006)
- C.4.14. Changes in MySQL Connector/ODBC 5.0.6 (03 November 2006)
- C.4.15. Changes in MySQL Connector/ODBC 5.0.5 (17 October 2006)
- C.4.16. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June 2006)
- C.4.17. Changes in Connector/ODBC 5.0.2 (Never released)
- C.4.18. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June 2006)
- C.4.19. Changes in MySQL Connector/ODBC 3.51.27 (20 November 2008)
- C.4.20. Changes in MySQL Connector/ODBC 3.51.26 (07 July 2008)
- C.4.21. Changes in MySQL Connector/ODBC 3.51.25 (11 April 2008)
- C.4.22. Changes in MySQL Connector/ODBC 3.51.24 (14 March 2008)
- C.4.23. Changes in MySQL Connector/ODBC 3.51.23 (09 January 2008)
- C.4.24. Changes in MySQL Connector/ODBC 3.51.22 (13 November 2007)
- C.4.25. Changes in MySQL Connector/ODBC 3.51.21 (08 October 2007)
- C.4.26. Changes in MySQL Connector/ODBC 3.51.20 (10 September 2007)
- C.4.27. Changes in MySQL Connector/ODBC 3.51.19 (10 August 2007)
- C.4.28. Changes in MySQL Connector/ODBC 3.51.18 (08 August 2007)
- C.4.29. Changes in MySQL Connector/ODBC 3.51.17 (14 July 2007)
- C.4.30. Changes in MySQL Connector/ODBC 3.51.16 (14 June 2007)
- C.4.31. Changes in MySQL Connector/ODBC 3.51.15 (07 May 2007)
- C.4.32. Changes in MySQL Connector/ODBC 3.51.14 (08 March 2007)
- C.4.33. Changes in MySQL Connector/ODBC 3.51.13 (Never released)
- C.4.34. Changes in MySQL Connector/ODBC 3.51.12 (11 February 2005)
- C.4.35. Changes in MySQL Connector/ODBC 3.51.11 (28 January 2005)
- C.5. MySQL Connector/NET Change History [+/-]
- C.5.1. Changes in MySQL Connector/NET Version 6.1.x
- C.5.2. Changes in MySQL Connector/NET Version 6.0.x
- C.5.3. Changes in MySQL Connector/NET Version 5.3.x
- C.5.4. Changes in MySQL Connector/NET Version 5.2.x
- C.5.5. Changes in MySQL Connector/NET Version 5.1.x
- C.5.6. Changes in MySQL Connector/NET Version 5.0.x
- C.5.7. Changes in MySQL Connector/NET Version 1.0.x
- C.5.8. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
- C.5.9. Changes in MySQL Connector/NET Version 0.76
- C.5.10. Changes in MySQL Connector/NET Version 0.75
- C.5.11. Changes in MySQL Connector/NET Version 0.74
- C.5.12. Changes in MySQL Connector/NET Version 0.71
- C.5.13. Changes in MySQL Connector/NET Version 0.70
- C.5.14. Changes in MySQL Connector/NET Version 0.68
- C.5.15. Changes in MySQL Connector/NET Version 0.65
- C.5.16. Changes in MySQL Connector/NET Version 0.60
- C.5.17. Changes in MySQL Connector/NET Version 0.50
- C.6. MySQL Visual Studio Plugin Change History [+/-]
- C.7. MySQL Connector/J Change History [+/-]
- C.7.1. Changes in MySQL Connector/J 5.1.x
- C.7.2. Changes in MySQL Connector/J 5.0.x
- C.7.3. Changes in MySQL Connector/J 3.1.x
- C.7.4. Changes in MySQL Connector/J 3.0.x
- C.7.5. Changes in MySQL Connector/J 2.0.x
- C.7.6. Changes in MySQL Connector/J 1.2b (04 July 1999)
- C.7.7. Changes in MySQL Connector/J 1.2.x and lower
- C.8. MySQL Connector/MXJ Change History [+/-]
- C.8.1. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)
- C.8.2. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)
- C.8.3. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)
- C.8.4. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)
- C.8.5. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)
- C.8.6. Changes in MySQL Connector/MXJ 5.0.1 (Never released)
- C.8.7. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)
- C.9. MySQL Proxy Change History [+/-]
- C.9.1. Changes in MySQL Proxy 0.8.0 (Not Yet Released)
- C.9.2. Changes in MySQL Proxy 0.7.3 (Not Yet Released)
- C.9.3. Changes in MySQL Proxy 0.7.2 (30 June 2009)
- C.9.4. Changes in MySQL Proxy 0.7.1 (15 May 2009)
- C.9.5. Changes in MySQL Proxy 0.7.0 (Never Released)
- C.9.6. Changes in MySQL Proxy 0.6.1 (06 February 2008)
- C.9.7. Changes in MySQL Proxy 0.6.0 (11 September 2007)
- C.9.8. Changes in MySQL Proxy 0.5.1 (30 June 2007)
- C.9.9. Changes in MySQL Proxy 0.5.0 (19 June 2007)
- D. Restrictions and Limits [+/-]
- Index
List of Figures [+/-]
- 13.1. The MySQL architecture using pluggable storage engines
- 13.2.
FEDERATEDTable Structure - 14.1. DRBD Architecture Overview
- 14.2. DRBD Architecture Using Separate Network Interfaces
- 14.3. Heartbeat Architecture
- 14.4. memcached Architecture Overview
- 14.5. Memory Allocation in memcached
- 14.6. Typical memcached Application Flowchart
- 15.1. MySQL Enterprise Monitor Architecture
- 15.2. MySQL Enterprise Monitor: Installing Monitor on Windows: Language Selection
- 15.3. MySQL Enterprise Monitor: Installing Monitor on Windows: Installation Directory
- 15.4. MySQL Enterprise Monitor: Installing Monitor on Windows: Tomcat Server Options
- 15.5. MySQL Enterprise Monitor: Installing Monitor on Windows: Repository Configuration
- 15.6. MySQL Enterprise Monitor: Installing Monitor on OS X: Language Selection
- 15.7. MySQL Enterprise Monitor: Installing Monitor on OS X: Java Selection
- 15.8. MySQL Enterprise Monitor: Installing Monitor on OS X: Installation Directory
- 15.9. MySQL Enterprise Monitor: Installing Monitor on OS X: Tomcat Server Options
- 15.10. MySQL Enterprise Monitor: Installing Monitor on OS X: Repository Configuration
- 15.11. MySQL Enterprise Monitor: Initial Dashboard Log-In
- 15.12. MySQL Enterprise Monitor: Outgoing Email Settings
- 15.13. MySQL Enterprise Monitor: Installing Agent on Windows: Language Selection
- 15.14. MySQL Enterprise Monitor: Installing Agent on Windows: Installation Directory
- 15.15. MySQL Enterprise Monitor: Installing Agent on Windows: Monitored Database Information
- 15.16. MySQL Enterprise Monitor: Installing Agent on Windows: Query Analyzer Configuration
- 15.17. MySQL Enterprise Monitor: Installing Agent on Windows: MySQL Enterprise Service Manager Options
- 15.18. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Language Selection
- 15.19. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Installation Directory
- 15.20. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information
- 15.21. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information
- 15.22. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Query Analyzer Configuration
- 15.23. MySQL Enterprise Monitor: Installing Agent on Mac OS X: MySQL Enterprise Service Manager Options
- 15.24. MySQL Enterprise Monitor: Server Update: Language Selection
- 15.25. MySQL Enterprise Monitor: Server Update: Previous Installation
- 15.26. MySQL Enterprise Monitor: Server Update: Backup of Previous Installation
- 15.27. MySQL Enterprise Monitor: Server Update: Completed installing files
- 15.28. MySQL Enterprise Monitor: Server Update: Final Setup
- 15.29. MySQL Enterprise Dashboard: The Graphs Screen
- 15.30. MySQL Enterprise Dashboard: The Heat Chart
- 15.31. MySQL Enterprise Dashboard: The Heat Chart Legend
- 15.32. MySQL Enterprise Dashboard: Settings
- 15.33. MySQL Enterprise Dashboard: User Preferences
- 15.34. MySQL Enterprise Dashboard: Manage Servers
- 15.35. MySQL Enterprise Dashboard: Server Renaming
- 15.36. MySQL Enterprise Dashboard: Manage Users
- 15.37. MySQL Enterprise Dashboard: Manage Notification Groups
- 15.38. MySQL Enterprise Dashboard: Edit Notification Groups
- 15.39. MySQL Enterprise Dashboard: Logs
- 15.40. MySQL Enterprise Dashboard: Scheduling Dialog
- 15.41. MySQL Enterprise Dashboard: Editing Rules
- 15.42. MySQL Enterprise Dashboard: Events Screen
- 15.43. MySQL Enterprise Dashboard: Query Analyzer
- 15.44. MySQL Enterprise Dashboard: Standard Agent/Monitor Topology
- 15.45. MySQL Enterprise Dashboard: Query Analyzer Agent/Monitor Topology
- 15.46. MySQL Enterprise Dashboard: Canonical Query Tab for a Query
- 15.47. MySQL Enterprise Dashboard: Example Query Tab for a Query
- 15.48. MySQL Enterprise Dashboard: Explain Query Tab for a Query
- 15.49. MySQL Enterprise Dashboard: Query Analyzer Configuration
- 15.50. MySQL Enterprise Dashboard: Replication Groups
- 15.51. MySQL Enterprise Monitor: Historical Data Migration Availability
- 15.52. MySQL Enterprise Monitor: Confirming Historical Data Migration
- 15.53. MySQL Enterprise Monitor: Historical Data Migration Progress
- 16.1. Using Replication to Improve the Performance During Scaleout
- 16.2. Using Replication to Replicate Databases to Separate Replication Slaves
- 16.3. Using an Additional Replication Host to Improve Performance
- 16.4. Redundancy Using Replication, Initial Structure
- 16.5. Redundancy Using Replication, After Master Failure
- 20.1. Add Connection Context Menu
- 20.2. Choose Data Source
- 20.3. Add Connection Dialog
- 20.4. New Data Connection
- 20.5. Editing New Table
- 20.6. Choose Table Name
- 20.7. Newly Created Table
- 20.8. Table Designer Main Menu
- 20.9. Indexes Dialog
- 20.10. Foreign Key Relationships Dialog
- 20.11. Table Properties Menu Item
- 20.12. Table Properties
- 20.13. Editing View SQL
- 20.14. View SQL Added
- 20.15. View SQL Saved
- 20.16. Edit Stored Procedure SQL
- 20.17. Stored Procedure SQL Saved
- 20.18. Add Entity Data Model
- 20.19. Entity Data Model Wizard Screen 1
- 20.20. Entity Data Model Wizard Screen 2
- 20.21. Entity Data Model Wizard Screen 3
- 20.22. Entity Data Model Diagram
- 20.23. Entity Data Source Configuration Wizard Screen 1
- 20.24. Entity Data Source Configuration Wizard Screen 2
- 20.25. Entity Data Source Configuration Wizard Screen 3
- 20.26. Data Sources
- 20.27. Data Form Designer
- 20.28. Adding Code to the Form
- 20.29. The Populated Grid Control
- 20.30. Save Button Enabled
- 20.31. Adding Save Code to the Form
- 20.32. The Design Tab
- 20.33. Drop Down List
- 20.34. Enable AutoPostBack
- 20.35. Grid View Control
- 20.36. Placed Grid Vew Control
- 20.37. Source Code
- 20.38. The Working Web Site
- 20.39. MySQL Website Configuration Tool
- 20.40. MySQL Website Configuration Tool - Membership
- 20.41. MySQL Website Configuration Tool - Connection String Editor
- 20.42. MySQL Website Configuration Tool - Advanced Options
- 20.43. MySQL Website Configuration Tool - Roles
- 20.44. MySQL Website Configuration Tool - Profiles
- 20.45. MySQL Website Configuration Tool - Session State
- 20.46. MySQL Website Configuration Tool - Tables
- 20.47. World Database Application
- 20.48. Authentication Type
- 20.49. Select Membership and Role Provider
- 20.50. Membership and Role Provider Tables
- 20.51. Security Tab
- 20.52. Create User
- 20.53. Membership and Roles Table Contents
- 20.54. Simple Profile Application
- 20.55. Windows Installer Welcome Screen
- 20.56. Windows Installer Overview Screen
- 20.57. Windows Installer Custom Setup Screen
- 20.58. Creating a New Project
- 20.59. The New Project Dialog Box
- 20.60. The Win32 Application Wizard
- 20.61. Selecting the Release Build
- 20.62. Selecting Project Properties from the Main Menu
- 20.63. Setting Properties
- 20.64. MySQL Include Directory
- 20.65. Select Directory Dialog
- 20.66. Typical Contents of MySQL lib/opt Directory
- 20.67. Additional Library Directories
- 20.68. Additional Library Directories Dialog
- 20.69.
- 20.70. Adding Additional Dependencies
- 20.71. Setting the CPPCONN_PUBLIC_FUNC Define
- 20.72. The NetBeans IDE
- 20.73. Setting the Header Include Directory
- 20.74. Setting the Static Library Directories and File Names
- 20.75. Setting the Dynamic Library Directory and File Name
- 20.76. The Example Application Running
- 20.77. Adding an Extension
- 20.78. Selecting the Database
- 20.79. Selecting the connection type
- 20.80. Entering Connection Settings
- 20.81. Setting Up User Authentication
- 20.82. After Connecting to the Database
- 20.83. Entering the Database File Name
- 20.84. Listing Tables
- A.1. Active-Master MySQL Server
List of Tables [+/-]
- 2.1. Build (
configure) Reference - 4.1.
mysqld_safeCommand-line Options - 4.2.
mysqlOptions - 4.3.
mysqladminOptions - 4.4.
mysqlcheckOptions - 4.5.
mysqldumpOptions - 4.6.
mysqlimportOptions - 4.7.
mysqlshowOptions - 4.8.
mysqlslapOptions - 4.9.
myisamchkOptions - 4.10.
mysqlaccessOptions - 4.11.
mysqlbinlogOptions - 4.12.
mysqldumpslowOptions - 4.13.
mysqlhotcopyOptions - 5.1. Option/Variable Summary
- 5.2. System Variable Summary
- 5.3. Session System Variable Summary
- 5.4. Dynamic Variable Summary
- 5.5. Status Variable Summary
- 5.6. Security Option/Variable Summary
- 5.7. SSL Option/Variable Summary
- 11.1. Operators/Functions
- 11.2. Operators
- 11.3. Comparison Operators
- 11.4. Logical Operators
- 11.5. Flow Control Operators
- 11.6. String Operators
- 11.7. String Comparison Operators
- 11.8. String Regular Expression Operators
- 11.9. Numeric Functions
- 11.10. Arithmetic Functions
- 11.11. Mathematical Functions
- 11.12. Date/Time Functions
- 11.13. Cast Functions
- 11.14. XML Functions
- 11.15. Other Functions
- 11.16. Bitwise Functions
- 11.17. Encryption Functions
- 11.18. Information Functions
- 11.19. Miscellaneous Functions
- 11.20. Aggregate (
GROUP BY) Functions - 13.1.
MyISAMStorage Engine Features - 13.2. MyISAM Option/Variable Reference
- 13.3.
InnoDBStorage Engine Features - 13.4.
InnoDBOption/Variable Reference - 13.5.
MEMORYStorage Engine Features - 13.6.
ARCHIVEStorage Engine Features - 14.1. memcached Command Reference
- 14.2. memcached Protocol Responses
- 15.1. MySQL Enterprise Monitor: Wiki Formatting
- 16.1. Replication Option/Variable Summary
- 16.2. Binary Logging Option/Variable Summary
- 20.1. MySQL APIs and Interfaces
- 20.2. MySQL Connector Versions and MySQL Server Versions
- 20.3. Mapping of MySQL Error Numbers to SQLStates
- 20.4. MySQL Configuration Options
- 20.5. MySQL client constants
- 20.6. MySQL fetch constants
- 20.7. MySQLi Configuration Options
- 20.8. Possible mysqli_info return values
- 20.9. Valid options
- 20.10. Supported flags
- 20.11. Attribute values
- 20.12. Type specification chars
- 20.13. Return Values
- 20.14. Object attributes
- 20.15. Object properties
- 20.16. Object properties
- 20.17. Supported flags
List of Examples [+/-]
- 20.1. Connector/J: Obtaining a connection from the
DriverManager - 20.2. Connector/J: Using java.sql.Statement to execute a
SELECTquery - 20.3. Connector/J: Calling Stored Procedures
- 20.4. Connector/J: Using
Connection.prepareCall() - 20.5. Connector/J: Registering output parameters
- 20.6. Connector/J: Setting
CallableStatementinput parameters - 20.7. Connector/J: Retrieving results and output parameter values
- 20.8. Connector/J: Retrieving
AUTO_INCREMENTcolumn values usingStatement.getGeneratedKeys() - 20.9. Connector/J: Retrieving
AUTO_INCREMENTcolumn values usingSELECT LAST_INSERT_ID() - 20.10. Connector/J: Retrieving
AUTO_INCREMENTcolumn values inUpdatable ResultSets - 20.11. Connector/J: Using a connection pool with a J2EE application server
- 20.12. Connector/J: Example of transaction with retry logic
- 20.13. MySQL extension overview example
- 20.14.
mysql_affected_rowsexample - 20.15.
mysql_affected_rowsexample using transactions - 20.16.
mysql_client_encodingexample - 20.17.
mysql_closeexample - 20.18.
mysql_connectexample - 20.19.
mysql_connectexample usinghostname:portsyntax - 20.20.
mysql_connectexample using ":/path/to/socket" syntax - 20.21.
mysql_create_dbalternative example - 20.22.
mysql_data_seekexample - 20.23.
mysql_db_nameexample - 20.24.
mysql_db_queryalternative example - 20.25.
mysql_drop_dbalternative example - 20.26.
mysql_errnoexample - 20.27.
mysql_errorexample - 20.28.
mysql_escape_stringexample - 20.29. Query with aliased duplicate field names
- 20.30.
mysql_fetch_arraywithMYSQL_NUM - 20.31.
mysql_fetch_arraywithMYSQL_ASSOC - 20.32.
mysql_fetch_arraywithMYSQL_BOTH - 20.33. An expanded
mysql_fetch_assocexample - 20.34.
mysql_fetch_fieldexample - 20.35. A
mysql_fetch_lengthsexample - 20.36.
mysql_fetch_objectexample - 20.37.
mysql_fetch_objectexample - 20.38. Fetching one row with
mysql_fetch_row - 20.39. A
mysql_field_flagsexample - 20.40.
mysql_field_lenexample - 20.41.
mysql_field_nameexample - 20.42. A
mysql_field_tableexample - 20.43.
mysql_field_typeexample - 20.44. A
mysql_free_resultexample - 20.45.
mysql_get_client_infoexample - 20.46.
mysql_get_host_infoexample - 20.47.
mysql_get_proto_infoexample - 20.48.
mysql_get_server_infoexample - 20.49. Relevant MySQL Statements
- 20.50.
mysql_insert_idexample - 20.51.
mysql_list_dbsexample - 20.52. Alternate to deprecated
mysql_list_fields - 20.53.
mysql_list_processesexample - 20.54.
mysql_list_tablesalternative example - 20.55. A
mysql_num_fieldsexample - 20.56.
mysql_num_rowsexample - 20.57. A
mysql_pingexample - 20.58. Invalid Query
- 20.59. Valid Query
- 20.60. Simple
mysql_real_escape_stringexample - 20.61. An example SQL Injection Attack
- 20.62.
mysql_resultexample - 20.63.
mysql_select_dbexample - 20.64.
mysql_statexample - 20.65. Alternative
mysql_statexample - 20.66.
mysql_tablenameexample - 20.67.
mysql_thread_idexample - 20.68. Object oriented style
- 20.69. Procedural style
- 20.70. Object oriented style
- 20.71. Procedural style
- 20.72. Object oriented style
- 20.73. Procedural style
- 20.74. Object oriented style
- 20.75. Procedural style
- 20.76. Object oriented style
- 20.77. Procedural style
- 20.78. Object oriented style
- 20.79. Procedural style
- 20.80. Object oriented style
- 20.81. Procedural style
- 20.82. Object oriented style
- 20.83. Object oriented style when extending mysqli class
- 20.84. Procedural style
- 20.85. Generating a Trace File
- 20.86. Object oriented style
- 20.87. Procedural style
- 20.88. Object oriented style
- 20.89. Procedural style
- 20.90. Object oriented style
- 20.91. Procedural style
- 20.92. A
mysqli_get_cache_statsexample - 20.93. Object oriented style
- 20.94. Procedural style
- 20.95. mysqli_get_client_info
- 20.96. A
mysqli_get_client_statsexample - 20.97. mysqli_get_client_version
- 20.98. A
mysqli_get_connection_statsexample - 20.99. Object oriented style
- 20.100. Procedural style
- 20.101. Object oriented style
- 20.102. Procedural style
- 20.103. Object oriented style
- 20.104. Procedural style
- 20.105. Object oriented style
- 20.106. Procedural style
- 20.107. Object oriented style
- 20.108. Procedural style
- 20.109. Object oriented style
- 20.110. Procedural style
- 20.111. Object oriented style
- 20.112. Procedural style
- 20.113. Object oriented style
- 20.114. Procedural style
- 20.115. Object oriented style
- 20.116. Procedural style
- 20.117. A
mysqli_pollexample - 20.118. Object oriented style
- 20.119. Procedural style
- 20.120. Object oriented style
- 20.121. Procedural style
- 20.122. Object oriented style
- 20.123. Object oriented style when extending mysqli class
- 20.124. Procedural style
- 20.125. Object oriented style
- 20.126. Procedural style
- 20.127. Object oriented style
- 20.128. Procedural style
- 20.129. Object oriented style
- 20.130. Procedural style
- 20.131. Object oriented style
- 20.132. Procedural style
- 20.133. Object oriented style
- 20.134. Procedural style
- 20.135. Object oriented style
- 20.136. Procedural style
- 20.137. Object oriented style
- 20.138. Procedural style
- 20.139. Object oriented style
- 20.140. Procedural style
- 20.141. Object oriented style
- 20.142. Procedural style
- 20.143. Object oriented style
- 20.144. Procedural style
- 20.145. Object oriented style
- 20.146. Procedural style
- 20.147. Object oriented style
- 20.148. Procedural style
- 20.149. Object oriented style
- 20.150. Procedural style
- 20.151. Object oriented style
- 20.152. Procedural style
- 20.153. Object oriented style
- 20.154. Procedural style
- 20.155. Object oriented style
- 20.156. Procedural style
- 20.157. Object oriented style
- 20.158. Procedural style
- 20.159. Object oriented style
- 20.160. Procedural style
- 20.161. Object oriented style
- 20.162. Procedural style
- 20.163. Object oriented style
- 20.164. Procedural style
- 20.165. Object oriented style
- 20.166. Procedural style
- 20.167. Object oriented style
- 20.168. Procedural style
- 20.169. Object oriented style
- 20.170. Object oriented style
- 20.171. Procedural style
- 20.172. Object oriented style
- 20.173. Procedural style
- 20.174. Object oriented style
- 20.175. Procedural style
- 20.176. Object oriented style
- 20.177. Procedural style
- 20.178. Object oriented style
- 20.179. Procedural style
- 20.180. Object oriented style
- 20.181. Procedural style
- 20.182. Object oriented style
- 20.183. Procedural style
- 20.184. Object oriented style
- 20.185. Procedural style
- 20.186. Object oriented style
- 20.187. Procedural style
- 20.188. Object oriented style
- 20.189. Procedural style
- 20.190. Object oriented style
- 20.191. Procedural style
- 20.192. Object oriented style
- 20.193. Procedural style
- 20.194. Object oriented style
- 20.195. Procedural style
- 20.196. Object oriented style
- 20.197. Procedural style
- 20.198. Object oriented style
- 20.199. Procedural style
- 20.200. Object oriented style
- 20.201. Forcing queries to be buffered in mysql
- 20.202. PDO_MYSQL DSN examples
