MySQL 6.0 Reference Manual
by
Bryan Hinton
—
last modified
Jul 03, 2009 04:40 PM
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 6.0 through 6.0.12.
MySQL Cluster is currently not supported in MySQL 6.0. For information about MySQL Cluster, please see MySQL Cluster NDB 6.X/7.X.
MySQL 6.0 features. This manual describes features that are not included in every edition of MySQL 6.0; such features may not be included in the edition of MySQL 6.0 licensed to you. If you have any questions about the features included in your edition of MySQL 6.0, refer to your MySQL 6.0 license agreement or contact your Sun Microsystems sales representative.
Document generated on: 2009-06-11 (revision: 15304)
The following table provides direct links into areas of the manual according to different topics. Links marked with » link to online guides and other manuals for more information.
Table 1. Topic Quick Reference
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 NetWare
- 2.8. Installing MySQL from
tar.gzPackages on Other Unix-Like Systems - 2.9. MySQL Installation Using a Source Distribution
- 2.10. Post-Installation Setup and Testing
- 2.11. Upgrading or Downgrading MySQL
- 2.12. Operating System-Specific Notes
- 2.13. Environment Variables
- 2.14. 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 Field
- 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. mysqlbackup — Display Backup Information
- 4.6.8. mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.9. mysqldumpslow — Summarize Slow Query Log Files
- 4.6.10. mysqlhotcopy — A Database Backup Program
- 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
- 5.7. Tracing mysqld Using DTrace
- 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. Index Condition Pushdown Optimization
- 7.2.9.
IS NULLOptimization - 7.2.10.
LEFT JOINandRIGHT JOINOptimization - 7.2.11. Nested-Loop Join Algorithms
- 7.2.12. Nested Join Optimization
- 7.2.13. Outer Join Simplification
- 7.2.14. Multi-Range Read Optimization
- 7.2.15. Block Nested-Loop and Batched Key Access Joins
- 7.2.16. Semi-Join Strategies
- 7.2.17.
ORDER BYOptimization - 7.2.18.
GROUP BYOptimization - 7.2.19.
DISTINCTOptimization - 7.2.20. Optimizing
IN/=ANYSubqueries - 7.2.21.
LIMITOptimization - 7.2.22. Using
optimizer_switchto Control the Optimizer - 7.2.23. How to Avoid Table Scans
- 7.2.24.
INFORMATION_SCHEMAOptimization - 7.2.25. Speed of
INSERTStatements - 7.2.26. Speed of
UPDATEStatements - 7.2.27. Speed of
DELETEStatements - 7.2.28. Other Optimization Tips
- 7.2.1. Optimizing Queries with
- 7.3. Locking Issues
- 7.4. Optimizing Database Structure
- 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. Collation Issues
- 9.1.7. String Repertoire
- 9.1.8. Operations Affected by Character Set Support
- 9.1.9. Unicode Support
- 9.1.10. Upgrading from Previous to Current 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 FUNCTIONSyntax - 12.1.4.
ALTER PROCEDURESyntax - 12.1.5.
ALTER SERVERSyntax - 12.1.6.
ALTER TABLESyntax - 12.1.7.
ALTER VIEWSyntax - 12.1.8.
CREATE DATABASESyntax - 12.1.9.
CREATE EVENTSyntax - 12.1.10.
CREATE FUNCTIONSyntax - 12.1.11.
CREATE INDEXSyntax - 12.1.12.
CREATE PROCEDUREandCREATE FUNCTIONSyntax - 12.1.13.
CREATE SERVERSyntax - 12.1.14.
CREATE TABLESyntax - 12.1.15.
CREATE TRIGGERSyntax - 12.1.16.
CREATE VIEWSyntax - 12.1.17.
DROP DATABASESyntax - 12.1.18.
DROP EVENTSyntax - 12.1.19.
DROP FUNCTIONSyntax - 12.1.20.
DROP INDEXSyntax - 12.1.21.
DROP PROCEDUREandDROP FUNCTIONSyntax - 12.1.22.
DROP SERVERSyntax - 12.1.23.
DROP TABLESyntax - 12.1.24.
DROP TRIGGERSyntax - 12.1.25.
DROP VIEWSyntax - 12.1.26.
RENAME TABLESyntax
- 12.1.1.
- 12.2. Data Manipulation Statements
- 12.3. MySQL Utility Statements
- 12.4. MySQL Transactional and Locking Statements
- 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. Comparing Transaction and Nontransaction Engines
- 13.2. Other Storage Engines
- 13.3. Setting the Storage Engine
- 13.4. Overview of MySQL Storage Engine Architecture
- 13.5. The
MyISAMStorage Engine - 13.6. The
MariaStorage Engine - 13.7. The
InnoDBStorage Engine -
- 13.7.1.
InnoDBContact Information - 13.7.2.
InnoDBConfiguration - 13.7.3.
InnoDBStartup Options and System Variables - 13.7.4. Creating and Using
InnoDBTables - 13.7.5. Adding, Removing, or Resizing
InnoDBData and Log Files - 13.7.6. Backing Up and Recovering an
InnoDBDatabase - 13.7.7. Moving an
InnoDBDatabase to Another Machine - 13.7.8. The
InnoDBTransaction Model and Locking - 13.7.9.
InnoDBMulti-Versioning - 13.7.10.
InnoDBTable and Index Structures - 13.7.11.
InnoDBDisk I/O and File Space Management - 13.7.12.
InnoDBError Handling - 13.7.13.
InnoDBPerformance Tuning and Troubleshooting - 13.7.14. Restrictions on
InnoDBTables
- 13.7.1.
- 13.8. The
FalconStorage Engine - 13.9. The
MERGEStorage Engine - 13.10. The
MEMORY(HEAP) Storage Engine - 13.11. The
EXAMPLEStorage Engine - 13.12. The
FEDERATEDStorage Engine - 13.13. The
ARCHIVEStorage Engine - 13.14. The
CSVStorage Engine - 13.15. 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. Deploying MySQL Enterprise Service Manager
- 15.5. MySQL Enterprise Dashboard
- 15.6. The Settings Page
- 15.7. The Advisors Page
- 15.8. The Events Page
- 15.9. The Graphs Page
- 15.10. The Query Analyzer Page
- 15.11. The Replication Page
- 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. Upgrading Multi-Master Replication
- 16.2.8. Setting Up Replication Using SSL
- 16.2.9. Semisynchronous Replication
- 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 TABLESPACESTable - 19.23. The
INFORMATION_SCHEMA PROCESSLISTTable - 19.24. The
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTSTable - 19.25. The
INFORMATION_SCHEMA GLOBAL_STATUSandSESSION_STATUSTables - 19.26. The
INFORMATION_SCHEMA GLOBAL_VARIABLESandSESSION_VARIABLESTables - 19.27. The
INFORMATION_SCHEMA PARAMETERSTable - 19.28. The
INFORMATION_SCHEMA PROFILINGTable - 19.29. Other
INFORMATION_SCHEMATables - 19.30. 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++ Debug Tracing
- 20.6.7. MySQL Connector/C++ References
- 20.6.8. MySQL Connector/C++ Known Bugs and Issues
- 20.6.9. MySQL Connector/C++ Feature requests
- 20.6.10. MySQL Connector/C++ Support
- 20.6.11. 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.10.17. How to Make a Threaded Client
- 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 6.0 Frequently Asked Questions
-
- A.1. MySQL 6.0 FAQ — General
- A.2. MySQL 6.0 FAQ — Storage Engines
- A.3. MySQL 6.0 FAQ — Server SQL Mode
- A.4. MySQL 6.0 FAQ — Stored Procedures and Functions
- A.5. MySQL 6.0 FAQ — Triggers
- A.6. MySQL 6.0 FAQ — Views
- A.7. MySQL 5.0 FAQ —
INFORMATION_SCHEMA - A.8. MySQL 6.0 FAQ — Migration
- A.9. MySQL 6.0 FAQ — Security
- A.10. MySQL 6.0 FAQ — MySQL Cluster
- A.11. MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
- A.12. MySQL 6.0 FAQ — Connectors & APIs
- A.13. MySQL 6.0 FAQ — Replication
- A.14. MySQL 6.0 FAQ — MySQL, DRBD, and Heartbeat
-
- A.14.1. Distributed Replicated Block Device (DRBD) Basics
- 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 6.0.x (Development)
-
- C.1.1. Changes in MySQL 6.0.12 (Not yet released)
- C.1.2. Changes in MySQL 6.0.11 (11 May 2009)
- C.1.3. Changes in MySQL 6.0.10 (03 March 2009)
- C.1.4. Changes in MySQL 6.0.9 (10 January 2009)
- C.1.5. Changes in MySQL 6.0.8 (03 November 2008)
- C.1.6. Changes in MySQL 6.0.7 (29 September 2008)
- C.1.7. Changes in MySQL 6.0.6 (11 August 2008)
- C.1.8. Changes in MySQL 6.0.5 (12 June 2008)
- C.1.9. Changes in MySQL 6.0.4 (12 February 2008)
- C.1.10. Changes in MySQL 6.0.3 (16 November 2007)
- C.1.11. Changes in MySQL 6.0.2 (04 September 2007)
- C.1.12. Changes in MySQL 6.0.1 (Not released)
- C.1.13. Changes in MySQL 6.0.0 (30 April 2007 Alpha)
- C.2. Changes in Release 5.2.x (Development)
- C.3. MySQL Enterprise Monitor Change History
-
- C.3.1. Changes in MySQL Enterprise Monitor 2.1.0 (Not yet released)
- C.3.2. Changes in MySQL Enterprise Monitor 2.0.6 (Not yet released)
- C.3.3. Changes in MySQL Enterprise Monitor 2.0.5 (18th March 2009)
- C.3.4. Changes in MySQL Enterprise Monitor 2.0.4 (5th February 2009)
- C.3.5. Changes in MySQL Enterprise Monitor 2.0.3 (23rd January 2009)
- C.3.6. Changes in MySQL Enterprise Monitor 2.0.2 (14th January 2009)
- C.3.7. Changes in MySQL Enterprise Monitor 2.0.1 (15th December 2008)
- C.3.8. 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 6.0.4 (Not yet released beta)
- C.5.2. Changes in MySQL Connector/NET 6.0.3 (28 April 2009 beta)
- C.5.3. Changes in MySQL Connector/NET 6.0.2 (07 April 2009 beta)
- C.5.4. Changes in MySQL Connector/NET 6.0.1 (02 April 2009 beta)
- C.5.5. Changes in MySQL Connector/NET 6.0.0 (02 March 2009 alpha)
- C.5.6. Changes in MySQL Connector/NET 5.3.0 (Not yet released)
- C.5.7. Changes in MySQL Connector/NET 5.2.7 (Not yet released)
- C.5.8. Changes in MySQL Connector/NET 5.2.6 (28 April 2009)
- C.5.9. Changes in MySQL Connector/NET 5.2.5 (19 November 2008)
- C.5.10. Changes in MySQL Connector/NET 5.2.4 (13 November 2008)
- C.5.11. Changes in MySQL Connector/NET 5.2.3 (19 August 2008)
- C.5.12. Changes in MySQL Connector/NET 5.2.2 (12 May 2008)
- C.5.13. Changes in MySQL Connector/NET 5.2.1 (27 February 2008)
- C.5.14. Changes in MySQL Connector/NET 5.2.0 (11 February 2008)
- C.5.15. Changes in MySQL Connector/NET 5.1.8 (Not yet released)
- C.5.16. Changes in MySQL Connector/NET 5.1.7 (21 August 2008)
- C.5.17. Changes in MySQL Connector/NET 5.1.6 (12 May 2008)
- C.5.18. Changes in MySQL Connector/NET 5.1.5 (Not yet released)
- C.5.19. Changes in MySQL Connector/NET 5.1.4 (20 November 2007)
- C.5.20. Changes in MySQL Connector/NET 5.1.3 (21 September 2007 beta)
- C.5.21. Changes in MySQL Connector/NET 5.1.2 (18 June 2007)
- C.5.22. Changes in MySQL Connector/NET 5.1.1 (23 May 2007)
- C.5.23. Changes in MySQL Connector/NET 5.1.0 (01 May 2007)
- C.5.24. Changes in MySQL Connector/NET 5.0.10 (Not yet released)
- C.5.25. Changes in MySQL Connector/NET 5.0.9 (Not yet released)
- C.5.26. Changes in MySQL Connector/NET 5.0.8 (21 August 2007)
- C.5.27. Changes in MySQL Connector/NET 5.0.7 (18 May 2007)
- C.5.28. Changes in MySQL Connector/NET 5.0.6 (22 March 2007)
- C.5.29. Changes in MySQL Connector/NET 5.0.5 (07 March 2007)
- C.5.30. Changes in MySQL Connector/NET 5.0.4 (Not released)
- C.5.31. Changes in MySQL Connector/NET 5.0.3 (05 January 2007)
- C.5.32. Changes in MySQL Connector/NET 5.0.2 (06 November 2006)
- C.5.33. Changes in MySQL Connector/NET 5.0.1 (01 October 2006)
- C.5.34. Changes in MySQL Connector/NET 5.0.0 (08 August 2006)
- C.5.35. Changes in MySQL Connector/NET 1.0.11 (Not yet released)
- C.5.36. Changes in MySQL Connector/NET 1.0.10 (24 August 2007)
- C.5.37. Changes in MySQL Connector/NET 1.0.9 (02 February 2007)
- C.5.38. Changes in MySQL Connector/NET 1.0.8 (20 October 2006)
- C.5.39. Changes in MySQL Connector/NET 1.0.7 (21 November 2005)
- C.5.40. Changes in MySQL Connector/NET 1.0.6 (03 October 2005)
- C.5.41. Changes in MySQL Connector/NET 1.0.5 (29 August 2005)
- C.5.42. Changes in MySQL Connector/NET 1.0.4 (20 January 2005)
- C.5.43. Changes in MySQL Connector/NET 1.0.3 (12 October 2004 gamma)
- C.5.44. Changes in MySQL Connector/NET 1.0.2 (15 November 2004 gamma)
- C.5.45. Changes in MySQL Connector/NET 1.0.1 (27 October 2004 beta)
- C.5.46. Changes in MySQL Connector/NET 1.0.0 (01 September 2004)
- C.5.47. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
- C.5.48. Changes in MySQL Connector/NET Version 0.76
- C.5.49. Changes in MySQL Connector/NET Version 0.75
- C.5.50. Changes in MySQL Connector/NET Version 0.74
- C.5.51. Changes in MySQL Connector/NET Version 0.71
- C.5.52. Changes in MySQL Connector/NET Version 0.70
- C.5.53. Changes in MySQL Connector/NET Version 0.68
- C.5.54. Changes in MySQL Connector/NET Version 0.65
- C.5.55. Changes in MySQL Connector/NET Version 0.60
- C.5.56. 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 Connector/C++ Change History
- C.10. MySQL Proxy Change History
- D. Restrictions and Limits
-
- D.1. Restrictions on Stored Routines, Triggers, and Events
- D.2. Restrictions on Signals
- D.3. Restrictions on Server-Side Cursors
- D.4. Restrictions on Subqueries
- D.5. Restrictions on Views
- D.6. Restrictions on XA Transactions
- D.7. Restrictions on Character Sets
- D.8. Restrictions on
BACKUP DATABASEandRESTORE - D.9. Limits in MySQL
- Index
List of Figures
- 5.1. The MySQL Architecture Using Pluggable Storage Engines
- 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 Monitor: Historical Data Migration Availability
- 15.30. MySQL Enterprise Monitor: Confirming Historical Data Migration
- 15.31. MySQL Enterprise Monitor: Historical Data Migration Progress
- 15.32. MySQL Enterprise Dashboard: The Graphs Screen
- 15.33. MySQL Enterprise Dashboard: The Heat Chart
- 15.34. MySQL Enterprise Dashboard: The Heat Chart Legend
- 15.35. MySQL Enterprise Dashboard: Settings
- 15.36. MySQL Enterprise Dashboard: User Preferences
- 15.37. MySQL Enterprise Dashboard: Manage Servers
- 15.38. MySQL Enterprise Dashboard: Server Renaming
- 15.39. MySQL Enterprise Dashboard: Manage Users
- 15.40. MySQL Enterprise Dashboard: Manage Notification Groups
- 15.41. MySQL Enterprise Dashboard: Logs
- 15.42. MySQL Enterprise Dashboard: Scheduling Dialog
- 15.43. MySQL Enterprise Dashboard: Editing Rules
- 15.44. MySQL Enterprise Dashboard: Events Screen
- 15.45. MySQL Enterprise Dashboard: Query Analyzer
- 15.46. MySQL Enterprise Dashboard: Standard Agent/Monitor Topology
- 15.47. MySQL Enterprise Dashboard: Query Analyzer Agent/Monitor Topology
- 15.48. MySQL Enterprise Dashboard: Canonical Query Tab for a Query
- 15.49. MySQL Enterprise Dashboard: Example Query Tab for a Query
- 15.50. MySQL Enterprise Dashboard: Explain Query Tab for a Query
- 15.51. MySQL Enterprise Dashboard: Query Analyzer Configuration
- 15.52. MySQL Enterprise Dashboard: Replication Groups
- 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. World Database Application
- 20.40. Windows Installer Welcome Screen
- 20.41. Windows Installer Overview Screen
- 20.42. Windows Installer Custom Setup Screen
- 20.43. Creating a New Project
- 20.44. The New Project Dialog Box
- 20.45. The Win32 Application Wizard
- 20.46. Selecting the Release Build
- 20.47. Selecting Project Properties from the Main Menu
- 20.48. Setting Properties
- 20.49. MySQL Include Directory
- 20.50. Select Directory Dialog
- 20.51. Typical Contents of MySQL lib/opt Directory
- 20.52. Additional Library Directories
- 20.53. Additional Library Directories Dialog
- 20.54.
- 20.55. Adding Additional Dependencies
- 20.56. Setting the CPPCONN_PUBLIC_FUNC Define
- 20.57. The NetBeans IDE
- 20.58. Setting the Header Include Directory
- 20.59. Setting the Static Library Directories and File Names
- 20.60. Setting the Dynamic Library Directory and File Name
- 20.61. The Example Application Running
- 20.62. Adding an Extension
- 20.63. Selecting the Database
- 20.64. Entering Connection Settings
- 20.65. Setting Up User Authentication
- 20.66. Entering User Credentials
- 20.67. Listing Tables
- A.1. Active-Master MySQL Server
List of Tables
- 1. Topic Quick Reference
- 2.1. Build (
configure) Reference - 4.1. mysqld_safe Option Reference
- 4.2. mysql Option Reference
- 4.3. mysqladmin Option Reference
- 4.4. mysqlcheck Option Reference
- 4.5. mysqldump Option Reference
- 4.6. mysqlimport Option Reference
- 4.7. mysqlshow Option Reference
- 4.8. mysqlslap Option Reference
- 4.9. myisamchk Option Reference
- 4.10. mysqlaccess Option Reference
- 4.11. mysqlbackup Option Reference
- 4.12. mysqlbinlog Option Reference
- 4.13. mysqldumpslow Option Reference
- 4.14. mysqlhotcopy Option Reference
- 5.1. mysqld Option/Variable Summary
- 5.2. mysqld System Variable Summary
- 5.3. mysqld Session System Variable Summary
- 5.4. mysqld Security Option/Variable Summary
- 5.5. mysqld SSL Option/Variable Summary
- 5.6. MySQL DTrace Probes
- 13.1. Storage Engine Features
- 13.2. MyISAM Features
- 13.3. mysqld MyISAM Option/Variable Reference
- 13.4. mysqld Maria Option/Variable Reference
- 13.5. InnoDB Features
- 13.6. mysqld InnoDB Option/Variable Reference
- 13.7. Falcon Features
- 13.8. mysqld Falcon Option/Variable Reference
- 13.9.
FalconINFORMATION_SCHEMAperformance diagnostic tables - 13.10. Memory Features
- 13.11. Archive Features
- 14.1. memcached Command Reference
- 14.2. memcached Protocol Responses
- 15.1. MySQL Enterprise Monitor: Wiki Formatting
- 16.1. mysqld Replication Option/Variable Summary
- 16.2. mysqld 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. A "Best Practice" query
- 20.63.
mysql_resultexample - 20.64.
mysql_select_dbexample - 20.65.
mysql_statexample - 20.66. Alternative
mysql_statexample - 20.67.
mysql_tablenameexample - 20.68.
mysql_thread_idexample - 20.69. Object oriented style
- 20.70. Procedural style
- 20.71. Object oriented style
- 20.72. Procedural style
- 20.73. Object oriented style
- 20.74. Procedural style
- 20.75. Object oriented style
- 20.76. Procedural style
- 20.77. Object oriented style
- 20.78. Procedural style
- 20.79.
mysqli_connect_errnoexample - 20.80.
mysqli_connect_errorexample - 20.81. Object oriented style
- 20.82. Procedural style
- 20.83. Generating a Trace File
- 20.84. Object oriented style
- 20.85. Procedural style
- 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. mysqli_get_client_info
- 20.93. mysqli_get_client_version
- 20.94. Object oriented style
- 20.95. Procedural style
- 20.96. Object oriented style
- 20.97. Procedural style
- 20.98. Object oriented style
- 20.99. Procedural style
- 20.100. Object oriented style
- 20.101. Procedural style
- 20.102. Object oriented style
- 20.103. Procedural style
- 20.104. Object oriented style
- 20.105. Procedural style
- 20.106. Object oriented style
- 20.107. Procedural style
- 20.108. Object oriented style
- 20.109. Procedural style
- 20.110. Object oriented style
- 20.111. Procedural style
- 20.112. Object oriented style
- 20.113. Procedural style
- 20.114. Object oriented style
- 20.115. Procedural style
- 20.116. Object oriented style
- 20.117. Procedural style
- 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. Procedural style
- 20.124. Object oriented style
- 20.125. Procedural style
- 20.126. Object oriented style
- 20.127. Procedural style
- 20.128. Object oriented style
- 20.129. Procedural style
- 20.130. Object oriented style
- 20.131. Procedural style
- 20.132. Object oriented style
- 20.133. Procedural style
- 20.134. Object oriented style
- 20.135. Procedural style
- 20.136. Object oriented style
- 20.137. Procedural style
- 20.138. Object oriented style
- 20.139. Procedural style
- 20.140. Object oriented style
- 20.141. Procedural style
- 20.142. Object oriented style
- 20.143. Procedural style
- 20.144. Object oriented style
- 20.145. Procedural style
- 20.146. Object oriented style
- 20.147. Procedural style
- 20.148. Object oriented style
- 20.149. Procedural style
- 20.150. Object oriented style
- 20.151. Procedural style
- 20.152. Object oriented style
- 20.153. Procedural style
- 20.154. Object oriented style
- 20.155. Procedural style
- 20.156. Object oriented style
- 20.157. Procedural style
- 20.158. Object oriented style
- 20.159. Procedural style
- 20.160. Object oriented style
- 20.161. Procedural style
- 20.162. Object oriented 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. Procedural style
- 20.171. Object oriented style
- 20.172. Procedural style
- 20.173. Object oriented style
- 20.174. Procedural style
- 20.175. Object oriented style
- 20.176. Procedural style
- 20.177. Object oriented style
- 20.178. Procedural style
- 20.179. Object oriented style
- 20.180. Procedural style
- 20.181. Object oriented style
- 20.182. Procedural style
- 20.183. Object oriented style
- 20.184. Procedural style
- 20.185. Object oriented style
- 20.186. Procedural style
- 20.187. Object oriented style
- 20.188. Procedural style
- 20.189. Object oriented style
- 20.190. Procedural style
- 20.191. Object oriented style
- 20.192. Procedural style
- 20.193. Object oriented style
- 20.194. Forcing queries to be buffered in mysql
- 20.195. PDO_MYSQL DSN examples
