| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Mon, 22 Dec 2025 12:49:09 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20090201212107
location: https://web.archive.org/web/20090201212107/https://dev.mysql.com/doc/refman/4.1/en
server-timing: captures_list;dur=1.242888, exclusion.robots;dur=0.042939, exclusion.robots.policy;dur=0.034716, esindex;dur=0.008429, cdx.remote;dur=10.650138, LoadShardBlock;dur=142.497695, PetaboxLoader3.datanode;dur=66.736429, PetaboxLoader3.resolve;dur=6.387820
x-app-server: wwwb-app217-dc8
x-ts: 302
x-tr: 182
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
set-cookie: wb-p-SERVER=wwwb-app217; path=/
x-location: All
x-as: 14061
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Mon, 22 Dec 2025 12:49:10 GMT
content-type: text/html
x-archive-orig-date: Sun, 01 Feb 2009 21:21:06 GMT
x-archive-orig-server: Apache/2.0.58 (Unix) mod_ssl/2.0.58 OpenSSL/0.9.7f
x-archive-orig-expires: Thu, 19 Nov 1981 08:52:00 GMT
x-archive-orig-cache-control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
x-archive-orig-pragma: no-cache
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: utf-8
memento-datetime: Sun, 01 Feb 2009 21:21:07 GMT
link: MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual
Skip navigation links
Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 3.23, 4.0, 4.1 Reference Manual
Section Navigation [Toggle]
- MySQL 3.23, 4.0, 4.1 Reference Manual
- Preface
- 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 Replication
- 15 MySQL Cluster
- 16 Spatial Extensions
- 17 Connectors and APIs
- 18 Extending MySQL
- A Errors, Error Codes, and Common Problems
- B MySQL Change History
- C Restrictions and Limits
- Index
Copyright 1997-2008 MySQL AB, 2009 Sun Microsystems, Inc.
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.
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 3.23 through MySQL 4.1.25.
Document generated on: 2009-02-01 (revision: 13503)
End of Product Lifecycle. Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended. However, for MySQL 4.0 and 4.1, there is still extended support available. For details, see https://www.mysql.com/company/legal/lifecycle/#calendar. According to the MySQL Lifecycle Policy (see https://www.mysql.com/company/legal/lifecycle/#policy), only Security and Severity Level 1 issues will still be fixed for MySQL 4.0 and 4.1. Please consider upgrading to a recent version (MySQL 5.0 or 5.1).
Table of Contents [+/-]
- Preface
- 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. Using the 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_src_distribution — Create Source Distribution for Windows
- 4.4.3. mysql_create_system_tables — Generate Statements to Initialize MySQL System Tables
- 4.4.4. mysqlbug — Generate Bug Report
- 4.4.5. mysql_fix_privilege_tables — Upgrade MySQL System Tables
- 4.4.6. mysql_install_db — Initialize MySQL Data Directory
- 4.4.7. mysql_secure_installation — Improve MySQL Installation Security
- 4.4.8. mysql_tzinfo_to_sql — Load the Time Zone Tables
- 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 and Repair 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.6. MySQL Administrative and Utility Programs [+/-]
- 4.6.1. myisam_ftdump — Display Full-Text Index information
- 4.6.2. myisamchk — MyISAM Table-Maintenance Utility
- 4.6.3. myisamlog — Display MyISAM Log File Contents
- 4.6.4. myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.5. mysqlaccess — Client for Checking Access Privileges
- 4.6.6. mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.7. mysqldumpslow — Summarize Slow Query Log Files
- 4.6.8. mysqlhotcopy — A Database Backup Program
- 4.6.9. mysqlmanagerc — Internal Test-Suite Program
- 4.6.10. mysqlmanager-pwgen — Internal Test-Suite Program
- 4.6.11. mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.12. mysql_explain_log — Use EXPLAIN on Statements in Query Log
- 4.6.13. mysql_find_rows — Extract SQL Statements from Files
- 4.6.14. mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.15. mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.16. mysql_tableinfo — Generate Database Metadata
- 4.6.17. mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.18. 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 System Variables
- 5.1.4. Session System Variables
- 5.1.5. Using System Variables
- 5.1.6. Server Status Variables
- 5.1.7. Server SQL Modes
- 5.1.8. Server-Side Help
- 5.1.9. Server Response to Signals
- 5.1.10. The Shutdown Process
- 5.2. The mysqld-max Extended MySQL Server
- 5.3. MySQL Server Logs [+/-]
- 5.4. General Security Issues [+/-]
- 5.5. The MySQL Access Privilege System [+/-]
- 5.5.1. How the Privilege System Works
- 5.5.2. The Privilege System Grant Tables
- 5.5.3. Privileges Provided by MySQL
- 5.5.4. Access Control, Stage 1: Connection Verification
- 5.5.5. Access Control, Stage 2: Request Verification
- 5.5.6. When Privilege Changes Take Effect
- 5.5.7. Causes of Access-Denied Errors
- 5.5.8. Password Hashing as of MySQL 4.1
- 5.6. MySQL User Account Management [+/-]
- 5.6.1. MySQL User Names and Passwords
- 5.6.2. Adding User Accounts to MySQL
- 5.6.3. Removing User Accounts from MySQL
- 5.6.4. Limiting Account Resources
- 5.6.5. Assigning Account Passwords
- 5.6.6. Keeping Passwords Secure
- 5.6.7. Using SSL for Secure Connections
- 5.6.8. Connecting to MySQL Remotely from Windows with SSH
- 5.6.9. Auditing MySQL Account Activity
- 5.7. 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.
IS NULLOptimization - 7.2.7.
LEFT JOINandRIGHT JOINOptimization - 7.2.8. Nested-Loop Join Algorithms
- 7.2.9.
ORDER BYOptimization - 7.2.10.
GROUP BYOptimization - 7.2.11.
DISTINCTOptimization - 7.2.12.
LIMITOptimization - 7.2.13. How to Avoid Table Scans
- 7.2.14. Speed of
INSERTStatements - 7.2.15. Speed of
UPDATEStatements - 7.2.16. Speed of
DELETEStatements - 7.2.17. Other Optimization Tips
- 7.2.1. Optimizing Queries with
- 7.3. Locking Issues [+/-]
- 7.4. Optimizing Database Structure [+/-]
- 7.4.1. Design Choices
- 7.4.2. Make Your Data as Small as Possible
- 7.4.3. Column Indexes
- 7.4.4. Multiple-Column Indexes
- 7.4.5. How MySQL Uses Indexes
- 7.4.6. The
MyISAMKey Cache - 7.4.7.
MyISAMIndex Statistics Collection - 7.4.8. How MySQL Opens and Closes Tables
- 7.4.9. Disadvantages of Creating Many Tables in the Same Database
- 7.5. Optimizing the MySQL Server [+/-]
- 7.5.1. System Factors and Startup Parameter Tuning
- 7.5.2. Tuning Server Parameters
- 7.5.3. The MySQL Query Cache
- 7.5.4. Examining Thread Information
- 7.5.5. How Compiling and Linking Affects the Speed of MySQL
- 7.5.6. How MySQL Uses Threads for Client Connections
- 7.5.7. How MySQL Uses Memory
- 7.5.8. How MySQL Uses Internal Temporary Tables
- 7.5.9. 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. Operations Affected by Character Set Support
- 9.1.8. Unicode Support
- 9.1.9. UTF-8 for Metadata
- 9.1.10. Upgrading Character Sets from MySQL 4.0
- 9.1.11. 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. Other Functions [+/-]
- 11.11. Functions and Modifiers for Use with
GROUP BYClauses [+/-]
- 12. SQL Statement Syntax [+/-]
- 12.1. Data Definition Statements [+/-]
- 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 [+/-]
- 13. Storage Engines [+/-]
- 13.1. The
MyISAMStorage Engine [+/-] - 13.2. The
InnoDBStorage Engine [+/-] - 13.2.1.
InnoDBContact Information - 13.2.2.
InnoDBin MySQL 3.23 - 13.2.3.
InnoDBConfiguration - 13.2.4.
InnoDBStartup Options and System Variables - 13.2.5. Creating and Using
InnoDBTables - 13.2.6. Adding, Removing, or Resizing
InnoDBData and Log Files - 13.2.7. Backing Up and Recovering an
InnoDBDatabase - 13.2.8. Moving an
InnoDBDatabase to Another Machine - 13.2.9. The
InnoDBTransaction Model and Locking - 13.2.10.
InnoDBPerformance Tuning Tips - 13.2.11.
InnoDBMulti-Versioning - 13.2.12.
InnoDBTable and Index Structures - 13.2.13.
InnoDBDisk I/O and File Space Management - 13.2.14.
InnoDBError Handling - 13.2.15. Restrictions on
InnoDBTables - 13.2.16.
InnoDBTroubleshooting
- 13.2.1.
- 13.3. The
MERGEStorage Engine [+/-] - 13.4. The
MEMORY(HEAP) Storage Engine - 13.5. The
BDB(BerkeleyDB) Storage Engine [+/-] - 13.6. The
EXAMPLEStorage Engine - 13.7. The
ARCHIVEStorage Engine - 13.8. The
CSVStorage Engine - 13.9. The
BLACKHOLEStorage Engine - 13.10. The
ISAMStorage Engine
- 13.1. The
- 14. Replication [+/-]
- 14.1. Introduction to Replication
- 14.2. Replication Implementation Overview
- 14.3. Replication Implementation Details [+/-]
- 14.4. How to Set Up Replication
- 14.5. Replication Compatibility Between MySQL Versions
- 14.6. Upgrading a Replication Setup [+/-]
- 14.7. Replication Features and Known Problems
- 14.8. Replication and Binary Logging Options and Variables [+/-]
- 14.9. How Servers Evaluate Replication Rules
- 14.10. Replication FAQ
- 14.11. Troubleshooting Replication
- 14.12. How to Report Replication Bugs or Problems
- 15. MySQL Cluster [+/-]
- 15.1. MySQL Cluster Overview [+/-]
- 15.2. MySQL Cluster Multi-Computer How-To [+/-]
- 15.2.1. MySQL Cluster Hardware, Software, and Networking Requirements
- 15.2.2. MySQL Cluster Multi-Computer Installation
- 15.2.3. MySQL Cluster Multi-Computer Configuration
- 15.2.4. Initial Startup of MySQL Cluster
- 15.2.5. Loading Sample Data into MySQL Cluster and Performing Queries
- 15.2.6. Safe Shutdown and Restart of MySQL Cluster
- 15.3. MySQL Cluster Configuration [+/-]
- 15.4. MySQL Cluster Options and Variables [+/-]
- 15.5. Upgrading and Downgrading MySQL Cluster [+/-]
- 15.6. Process Management in MySQL Cluster [+/-]
- 15.7. Management of MySQL Cluster [+/-]
- 15.7.1. Summary of MySQL Cluster Start Phases
- 15.7.2. Commands in the MySQL Cluster Management Client
- 15.7.3. Online Backup of MySQL Cluster
- 15.7.4. Event Reports Generated in MySQL Cluster
- 15.7.5. MySQL Cluster Log Messages
- 15.7.6. MySQL Cluster Single User Mode
- 15.7.7. Quick Reference: MySQL Cluster SQL Statements
- 15.8. MySQL Cluster Security Issues [+/-]
- 15.9. MySQL Cluster Utility Programs [+/-]
- 15.9.1. ndb_config — Extract MySQL Cluster Configuration Information
- 15.9.2. ndb_cpcd — Automate Testing for NDB Development
- 15.9.3. ndb_delete_all — Delete All Rows from an NDB Table
- 15.9.4. ndb_desc — Describe NDB Tables
- 15.9.5. ndb_drop_index — Drop Index from an NDB Table
- 15.9.6. ndb_drop_table — Drop an NDB Table
- 15.9.7. ndb_error_reporter — NDB Error-Reporting Utility
- 15.9.8. ndb_print_backup_file — Print NDB Backup File Contents
- 15.9.9. ndb_print_schema_file — Print NDB Schema File Contents
- 15.9.10. ndb_print_sys_file — Print NDB System File Contents
- 15.9.11. ndb_select_all — Print Rows from an NDB Table
- 15.9.12. ndb_select_count — Print Row Counts for NDB Tables
- 15.9.13. ndb_show_tables — Display List of NDB Tables
- 15.9.14. ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 15.9.15. ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 15.10. Using High-Speed Interconnects with MySQL Cluster [+/-]
- 15.11. Known Limitations of MySQL Cluster [+/-]
- 15.11.1. Non-Compliance with SQL Syntax in MySQL Cluster
- 15.11.2. Limits and Differences of MySQL Cluster from Standard MySQL Limits
- 15.11.3. Limits Relating to Transaction Handling in MySQL Cluster
- 15.11.4. MySQL Cluster Error Handling
- 15.11.5. Limits Associated with Database Objects in MySQL Cluster
- 15.11.6. Unsupported or Missing Features in MySQL Cluster
- 15.11.7. Limitations Relating to Performance in MySQL Cluster
- 15.11.8. Issues Exclusive to MySQL Cluster
- 15.11.9. Limitations Relating to Multiple MySQL Cluster Nodes
- 15.12. MySQL 4.1 FAQ — MySQL Cluster
- 15.13. MySQL Cluster Glossary
- 16. Spatial Extensions [+/-]
- 16.1. Introduction to MySQL Spatial Support
- 16.2. The OpenGIS Geometry Model [+/-]
- 16.2.1. The Geometry Class Hierarchy
- 16.2.2. Class
Geometry - 16.2.3. Class
Point - 16.2.4. Class
Curve - 16.2.5. Class
LineString - 16.2.6. Class
Surface - 16.2.7. Class
Polygon - 16.2.8. Class
GeometryCollection - 16.2.9. Class
MultiPoint - 16.2.10. Class
MultiCurve - 16.2.11. Class
MultiLineString - 16.2.12. Class
MultiSurface - 16.2.13. Class
MultiPolygon
- 16.3. Supported Spatial Data Formats [+/-]
- 16.4. Creating a Spatially Enabled MySQL Database [+/-]
- 16.5. Analyzing Spatial Information [+/-]
- 16.5.1. Geometry Format Conversion Functions
- 16.5.2.
GeometryFunctions - 16.5.3. Functions That Create New Geometries from Existing Ones
- 16.5.4. Functions for Testing Spatial Relations Between Geometric Objects
- 16.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)
- 16.5.6. Functions That Test Spatial Relationships Between Geometries
- 16.6. Optimizing Spatial Analysis [+/-]
- 16.7. MySQL Conformance and Compatibility
- 17. Connectors and APIs [+/-]
- 17.1. MySQL Connector/ODBC [+/-]
- 17.2. MySQL Connector/NET [+/-]
- 17.3. MySQL Visual Studio Plugin [+/-]
- 17.4. MySQL Connector/J [+/-]
- 17.5. MySQL Connector/MXJ [+/-]
- 17.6. libmysqld, the Embedded MySQL Server Library [+/-]
- 17.7. MySQL C API [+/-]
- 17.7.1. C API Data Types
- 17.7.2. C API Function Overview
- 17.7.3. C API Function Descriptions
- 17.7.4. C API Prepared Statements
- 17.7.5. C API Prepared Statement Data types
- 17.7.6. C API Prepared Statement Function Overview
- 17.7.7. C API Prepared Statement Function Descriptions
- 17.7.8. C API Threaded Function Descriptions
- 17.7.9. C API Embedded Server Function Descriptions
- 17.7.10. Common Questions and Problems When Using the C API
- 17.7.11. Controlling Automatic Reconnection Behavior
- 17.7.12. C API Handling of Multiple Statement Execution
- 17.7.13. C API Prepared Statement Problems
- 17.7.14. C API Prepared Statement Handling of Date and Time Values
- 17.7.15. Building Client Programs
- 17.7.16. How to Make a Threaded Client
- 17.8. MySQL PHP API [+/-]
- 17.9. MySQL Perl API
- 17.10. MySQL C++ API
- 17.11. MySQL Python API
- 17.12. MySQL Ruby APIs [+/-]
- 17.13. MySQL Tcl API
- 17.14. MySQL Eiffel Wrapper
- 18. Extending MySQL [+/-]
- A. Errors, Error Codes, and Common Problems [+/-]
- B. MySQL Change History [+/-]
- B.1. Changes in release 4.1.x (Production) [+/-]
- B.1.1. Changes in MySQL 4.1.25 (01 December 2008)
- B.1.2. Changes in MySQL 4.1.24 (01 March 2008)
- B.1.3. Changes in MySQL 4.1.23 (12 June 2007)
- B.1.4. Changes in MySQL 4.1.22 (02 November 2006)
- B.1.5. Changes in MySQL 4.1.21 (19 July 2006)
- B.1.6. Changes in MySQL 4.1.20 (24 May 2006)
- B.1.7. Changes in MySQL 4.1.19 (29 April 2006)
- B.1.8. Changes in MySQL 4.1.18 (27 January 2006)
- B.1.9. Changes in MySQL 4.1.17 (Not released)
- B.1.10. Changes in MySQL 4.1.16 (29 November 2005)
- B.1.11. Changes in MySQL 4.1.15 (13 October 2005)
- B.1.12. Changes in MySQL 4.1.14 (17 August 2005)
- B.1.13. Changes in MySQL 4.1.13 (15 July 2005)
- B.1.14. Changes in MySQL 4.1.12 (13 May 2005)
- B.1.15. Changes in MySQL 4.1.11 (01 April 2005)
- B.1.16. Changes in MySQL 4.1.10 (12 February 2005)
- B.1.17. Changes in MySQL 4.1.9 (11 January 2005)
- B.1.18. Changes in MySQL 4.1.8 (14 December 2004)
- B.1.19. Changes in MySQL 4.1.7 (23 October 2004: Production)
- B.1.20. Changes in MySQL 4.1.6 (10 October 2004)
- B.1.21. Changes in MySQL 4.1.5 (16 September 2004)
- B.1.22. Changes in MySQL 4.1.4 (26 August 2004: Gamma)
- B.1.23. Changes in MySQL 4.1.3 (28 June 2004: Beta)
- B.1.24. Changes in MySQL 4.1.2 (28 May 2004)
- B.1.25. Changes in MySQL 4.1.1 (01 December 2003)
- B.1.26. Changes in MySQL 4.1.0 (03 April 2003: Alpha)
- B.2. Changes in release 4.0.x [+/-]
- B.2.1. Changes in release 4.0.31 (Not yet released)
- B.2.2. Changes in release 4.0.30 (12 February 2007)
- B.2.3. Changes in release 4.0.29 (Not released)
- B.2.4. Changes in release 4.0.28 (Not released)
- B.2.5. Changes in release 4.0.27 (06 May 2006)
- B.2.6. Changes in release 4.0.26 (08 September 2005)
- B.2.7. Changes in release 4.0.25 (05 July 2005)
- B.2.8. Changes in release 4.0.24 (04 March 2005)
- B.2.9. Changes in release 4.0.23 (18 December 2004)
- B.2.10. Changes in release 4.0.22 (27 October 2004)
- B.2.11. Changes in release 4.0.21 (06 September 2004)
- B.2.12. Changes in release 4.0.20 (17 May 2004)
- B.2.13. Changes in release 4.0.19 (04 May 2004)
- B.2.14. Changes in release 4.0.18 (12 February 2004)
- B.2.15. Changes in release 4.0.17 (14 December 2003)
- B.2.16. Changes in release 4.0.16 (17 October 2003)
- B.2.17. Changes in release 4.0.15 (03 September 2003)
- B.2.18. Changes in release 4.0.14 (18 July 2003)
- B.2.19. Changes in release 4.0.13 (16 May 2003)
- B.2.20. Changes in release 4.0.12 (15 March 2003: Production)
- B.2.21. Changes in release 4.0.11 (20 February 2003)
- B.2.22. Changes in release 4.0.10 (29 January 2003)
- B.2.23. Changes in release 4.0.9 (09 January 2003)
- B.2.24. Changes in release 4.0.8 (07 January 2003)
- B.2.25. Changes in release 4.0.7 (20 December 2002)
- B.2.26. Changes in release 4.0.6 (14 December 2002: Gamma)
- B.2.27. Changes in release 4.0.5 (13 November 2002)
- B.2.28. Changes in release 4.0.4 (29 September 2002)
- B.2.29. Changes in release 4.0.3 (26 August 2002: Beta)
- B.2.30. Changes in release 4.0.2 (01 July 2002)
- B.2.31. Changes in release 4.0.1 (23 December 2001)
- B.2.32. Changes in release 4.0.0 (October 2001: Alpha)
- B.3. Changes in release 3.23.x [+/-]
- B.3.1. Changes in release 3.23.59 (Not yet released)
- B.3.2. Changes in release 3.23.58 (11 September 2003)
- B.3.3. Changes in release 3.23.57 (06 June 2003)
- B.3.4. Changes in release 3.23.56 (13 March 2003)
- B.3.5. Changes in release 3.23.55 (23 January 2003)
- B.3.6. Changes in release 3.23.54 (05 December 2002)
- B.3.7. Changes in release 3.23.53 (09 October 2002)
- B.3.8. Changes in release 3.23.52 (14 August 2002)
- B.3.9. Changes in release 3.23.51 (31 May 2002)
- B.3.10. Changes in release 3.23.50 (21 April 2002)
- B.3.11. Changes in release 3.23.49 (14 February 2002)
- B.3.12. Changes in release 3.23.48 (07 February 2002)
- B.3.13. Changes in release 3.23.47 (27 December 2001)
- B.3.14. Changes in release 3.23.46 (29 November 2001)
- B.3.15. Changes in release 3.23.45 (22 November 2001)
- B.3.16. Changes in release 3.23.44 (31 October 2001)
- B.3.17. Changes in release 3.23.43 (04 October 2001)
- B.3.18. Changes in release 3.23.42 (08 September 2001)
- B.3.19. Changes in release 3.23.41 (11 August 2001)
- B.3.20. Changes in release 3.23.40 (18 July 2001)
- B.3.21. Changes in release 3.23.39 (12 June 2001)
- B.3.22. Changes in release 3.23.38 (09 May 2001)
- B.3.23. Changes in release 3.23.37 (17 April 2001)
- B.3.24. Changes in release 3.23.36 (27 March 2001)
- B.3.25. Changes in release 3.23.35 (15 March 2001)
- B.3.26. Changes in release 3.23.34a (11 March 2001)
- B.3.27. Changes in release 3.23.34 (10 March 2001)
- B.3.28. Changes in release 3.23.33 (09 February 2001)
- B.3.29. Changes in release 3.23.32 (22 January 2001)
- B.3.30. Changes in release 3.23.31 (17 January 2001: Production)
- B.3.31. Changes in release 3.23.30 (04 January 2001)
- B.3.32. Changes in release 3.23.29 (16 December 2000)
- B.3.33. Changes in release 3.23.28 (22 November 2000: Gamma)
- B.3.34. Changes in release 3.23.27 (24 October 2000)
- B.3.35. Changes in release 3.23.26 (18 October 2000)
- B.3.36. Changes in release 3.23.25 (29 September 2000)
- B.3.37. Changes in release 3.23.24 (08 September 2000)
- B.3.38. Changes in release 3.23.23 (01 September 2000)
- B.3.39. Changes in release 3.23.22 (31 July 2000)
- B.3.40. Changes in release 3.23.21 (04 July 2000)
- B.3.41. Changes in release 3.23.20 (28 June 2000: Beta)
- B.3.42. Changes in release 3.23.19
- B.3.43. Changes in release 3.23.18 (11 June 2000)
- B.3.44. Changes in release 3.23.17 (07 June 2000)
- B.3.45. Changes in release 3.23.16 (16 May 2000)
- B.3.46. Changes in release 3.23.15 (08 May 2000)
- B.3.47. Changes in release 3.23.14 (09 April 2000)
- B.3.48. Changes in release 3.23.13 (14 March 2000)
- B.3.49. Changes in release 3.23.12 (07 March 2000)
- B.3.50. Changes in release 3.23.11 (16 February 2000)
- B.3.51. Changes in release 3.23.10 (30 January 2000)
- B.3.52. Changes in release 3.23.9 (29 January 2000)
- B.3.53. Changes in release 3.23.8 (02 January 2000)
- B.3.54. Changes in release 3.23.7 (10 December 1999)
- B.3.55. Changes in release 3.23.6 (15 December 1999)
- B.3.56. Changes in release 3.23.5 (20 October 1999)
- B.3.57. Changes in release 3.23.4 (28 September 1999)
- B.3.58. Changes in release 3.23.3 (13 September 1999)
- B.3.59. Changes in release 3.23.2 (09 August 1999)
- B.3.60. Changes in release 3.23.1 (08 July 1999)
- B.3.61. Changes in release 3.23.0 (05 July 1999: Alpha)
- B.4. Changes in
InnoDB[+/-] - B.4.1. Changes in MySQL/InnoDB-4.0.21, September 10, 2004
- B.4.2. Changes in MySQL/InnoDB-4.1.4, August 31, 2004
- B.4.3. Changes in MySQL/InnoDB-4.1.3, June 28, 2004
- B.4.4. Changes in MySQL/InnoDB-4.1.2, May 30, 2004
- B.4.5. Changes in MySQL/InnoDB-4.0.20, May 18, 2004
- B.4.6. Changes in MySQL/InnoDB-4.0.19, May 4, 2004
- B.4.7. Changes in MySQL/InnoDB-4.0.18, February 13, 2004
- B.4.8. Changes in MySQL/InnoDB-5.0.0, December 24, 2003
- B.4.9. Changes in MySQL/InnoDB-4.0.17, December 17, 2003
- B.4.10. Changes in MySQL/InnoDB-4.1.1, December 4, 2003
- B.4.11. Changes in MySQL/InnoDB-4.0.16, October 22, 2003
- B.4.12. Changes in MySQL/InnoDB-3.23.58, September 15, 2003
- B.4.13. Changes in MySQL/InnoDB-4.0.15, September 10, 2003
- B.4.14. Changes in MySQL/InnoDB-4.0.14, July 22, 2003
- B.4.15. Changes in MySQL/InnoDB-3.23.57, June 20, 2003
- B.4.16. Changes in MySQL/InnoDB-4.0.13, May 20, 2003
- B.4.17. Changes in MySQL/InnoDB-4.1.0, April 3, 2003
- B.4.18. Changes in MySQL/InnoDB-3.23.56, March 17, 2003
- B.4.19. Changes in MySQL/InnoDB-4.0.12, March 18, 2003
- B.4.20. Changes in MySQL/InnoDB-4.0.11, February 25, 2003
- B.4.21. Changes in MySQL/InnoDB-4.0.10, February 4, 2003
- B.4.22. Changes in MySQL/InnoDB-3.23.55, January 24, 2003
- B.4.23. Changes in MySQL/InnoDB-4.0.9, January 14, 2003
- B.4.24. Changes in MySQL/InnoDB-4.0.8, January 7, 2003
- B.4.25. Changes in MySQL/InnoDB-4.0.7, December 26, 2002
- B.4.26. Changes in MySQL/InnoDB-4.0.6, December 19, 2002
- B.4.27. Changes in MySQL/InnoDB-3.23.54, December 12, 2002
- B.4.28. Changes in MySQL/InnoDB-4.0.5, November 18, 2002
- B.4.29. Changes in MySQL/InnoDB-3.23.53, October 9, 2002
- B.4.30. Changes in MySQL/InnoDB-4.0.4, October 2, 2002
- B.4.31. Changes in MySQL/InnoDB-4.0.3, August 28, 2002
- B.4.32. Changes in MySQL/InnoDB-3.23.52, August 16, 2002
- B.4.33. Changes in MySQL/InnoDB-4.0.2, July 10, 2002
- B.4.34. Changes in MySQL/InnoDB-3.23.51, June 12, 2002
- B.4.35. Changes in MySQL/InnoDB-3.23.50, April 23, 2002
- B.4.36. Changes in MySQL/InnoDB-3.23.49, February 17, 2002
- B.4.37. Changes in MySQL/InnoDB-3.23.48, February 9, 2002
- B.4.38. Changes in MySQL/InnoDB-3.23.47, December 28, 2001
- B.4.39. Changes in MySQL/InnoDB-4.0.1, December 23, 2001
- B.4.40. Changes in MySQL/InnoDB-3.23.46, November 30, 2001
- B.4.41. Changes in MySQL/InnoDB-3.23.45, November 23, 2001
- B.4.42. Changes in MySQL/InnoDB-3.23.44, November 2, 2001
- B.4.43. Changes in MySQL/InnoDB-3.23.43, October 4, 2001
- B.4.44. Changes in MySQL/InnoDB-3.23.42, September 9, 2001
- B.4.45. Changes in MySQL/InnoDB-3.23.41, August 13, 2001
- B.4.46. Changes in MySQL/InnoDB-3.23.40, July 16, 2001
- B.4.47. Changes in MySQL/InnoDB-3.23.39, June 13, 2001
- B.4.48. Changes in MySQL/InnoDB-3.23.38, May 12, 2001
- B.5. Changes in MySQL Cluster [+/-]
- B.5.1. Changes in MySQL Cluster-5.0.7 (10 June 2005)
- B.5.2. Changes in MySQL Cluster-5.0.6 (26 May 2005)
- B.5.3. Changes in MySQL Cluster-5.0.5 (Not released)
- B.5.4. Changes in MySQL Cluster-5.0.4 (16 April 2005)
- B.5.5. Changes in MySQL Cluster-5.0.3 (23 March 2005: Beta)
- B.5.6. Changes in MySQL Cluster-5.0.1 (27 July 2004)
- B.5.7. Changes in MySQL Cluster-4.1.13 (15 July 2005)
- B.5.8. Changes in MySQL Cluster-4.1.12 (13 May 2005)
- B.5.9. Changes in MySQL Cluster-4.1.11 (01 April 2005)
- B.5.10. Changes in MySQL Cluster-4.1.10 (12 February 2005)
- B.5.11. Changes in MySQL Cluster-4.1.9 (13 January 2005)
- B.5.12. Changes in MySQL Cluster-4.1.8 (14 December 2004)
- B.5.13. Changes in MySQL Cluster-4.1.7 (23 October 2004)
- B.5.14. Changes in MySQL Cluster-4.1.6 (10 October 2004)
- B.5.15. Changes in MySQL Cluster-4.1.5 (16 September 2004)
- B.5.16. Changes in MySQL Cluster-4.1.4 (31 August 2004)
- B.5.17. Changes in MySQL Cluster-4.1.3 (28 June 2004)
- B.6. MySQL Connector/ODBC (MyODBC) Change History [+/-]
- B.6.1. Changes in MySQL Connector/ODBC 5.1.6 (Not yet released)
- B.6.2. Changes in MySQL Connector/ODBC 5.1.5 (18 August 2008)
- B.6.3. Changes in MySQL Connector/ODBC 5.1.4 (15 April 2008)
- B.6.4. Changes in MySQL Connector/ODBC 5.1.3 (26 March 2008)
- B.6.5. Changes in MySQL Connector/ODBC 5.1.2 (13 February 2008)
- B.6.6. Changes in MySQL Connector/ODBC 5.1.1 (13 December 2007)
- B.6.7. Changes in MySQL Connector/ODBC 5.1.0 (10 September 2007)
- B.6.8. Changes in MySQL Connector/ODBC 5.0.12 (Never released)
- B.6.9. Changes in MySQL Connector/ODBC 5.0.11 (31 January 2007)
- B.6.10. Changes in MySQL Connector/ODBC 5.0.10 (14 December 2006)
- B.6.11. Changes in MySQL Connector/ODBC 5.0.9 (22 November 2006)
- B.6.12. Changes in MySQL Connector/ODBC 5.0.8 (17 November 2006)
- B.6.13. Changes in MySQL Connector/ODBC 5.0.7 (08 November 2006)
- B.6.14. Changes in MySQL Connector/ODBC 5.0.6 (03 November 2006)
- B.6.15. Changes in MySQL Connector/ODBC 5.0.5 (17 October 2006)
- B.6.16. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June 2006)
- B.6.17. Changes in Connector/ODBC 5.0.2 (Never released)
- B.6.18. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June 2006)
- B.6.19. Changes in MySQL Connector/ODBC 3.51.27 (20 November 2008)
- B.6.20. Changes in MySQL Connector/ODBC 3.51.26 (07 July 2008)
- B.6.21. Changes in MySQL Connector/ODBC 3.51.25 (11 April 2008)
- B.6.22. Changes in MySQL Connector/ODBC 3.51.24 (14 March 2008)
- B.6.23. Changes in MySQL Connector/ODBC 3.51.23 (09 January 2008)
- B.6.24. Changes in MySQL Connector/ODBC 3.51.22 (13 November 2007)
- B.6.25. Changes in MySQL Connector/ODBC 3.51.21 (08 October 2007)
- B.6.26. Changes in MySQL Connector/ODBC 3.51.20 (10 September 2007)
- B.6.27. Changes in MySQL Connector/ODBC 3.51.19 (10 August 2007)
- B.6.28. Changes in MySQL Connector/ODBC 3.51.18 (08 August 2007)
- B.6.29. Changes in MySQL Connector/ODBC 3.51.17 (14 July 2007)
- B.6.30. Changes in MySQL Connector/ODBC 3.51.16 (14 June 2007)
- B.6.31. Changes in MySQL Connector/ODBC 3.51.15 (07 May 2007)
- B.6.32. Changes in MySQL Connector/ODBC 3.51.14 (08 March 2007)
- B.6.33. Changes in MySQL Connector/ODBC 3.51.13 (Never released)
- B.6.34. Changes in MySQL Connector/ODBC 3.51.12 (11 February 2005)
- B.6.35. Changes in MySQL Connector/ODBC 3.51.11 (28 January 2005)
- B.7. MySQL Connector/NET Change History [+/-]
- B.7.1. Changes in MySQL Connector/NET 5.3.0 (Not yet released)
- B.7.2. Changes in MySQL Connector/NET 5.2.6 (Not yet released)
- B.7.3. Changes in MySQL Connector/NET 5.2.5 (19 November 2008)
- B.7.4. Changes in MySQL Connector/NET 5.2.4 (13 November 2008)
- B.7.5. Changes in MySQL Connector/NET 5.2.3 (19 August 2008)
- B.7.6. Changes in MySQL Connector/NET 5.2.2 (12 May 2008)
- B.7.7. Changes in MySQL Connector/NET 5.2.1 (27 February 2008)
- B.7.8. Changes in MySQL Connector/NET 5.2.0 (11 February 2008)
- B.7.9. Changes in MySQL Connector/NET 5.1.8 (Not yet released)
- B.7.10. Changes in MySQL Connector/NET 5.1.7 (21 August 2008)
- B.7.11. Changes in MySQL Connector/NET 5.1.6 (12 May 2008)
- B.7.12. Changes in MySQL Connector/NET 5.1.5 (Not yet released)
- B.7.13. Changes in MySQL Connector/NET 5.1.4 (20 November 2007)
- B.7.14. Changes in MySQL Connector/NET 5.1.3 (21 September 2007: beta)
- B.7.15. Changes in MySQL Connector/NET 5.1.2 (18 June 2007)
- B.7.16. Changes in MySQL Connector/NET 5.1.1 (23 May 2007)
- B.7.17. Changes in MySQL Connector/NET 5.1.0 (01 May 2007)
- B.7.18. Changes in MySQL Connector/NET 5.0.10 (Not yet released)
- B.7.19. Changes in MySQL Connector/NET 5.0.9 (Not yet released)
- B.7.20. Changes in MySQL Connector/NET 5.0.8 (21 August 2007)
- B.7.21. Changes in MySQL Connector/NET 5.0.7 (18 May 2007)
- B.7.22. Changes in MySQL Connector/NET 5.0.6 (22 March 2007)
- B.7.23. Changes in MySQL Connector/NET 5.0.5 (07 March 2007)
- B.7.24. Changes in MySQL Connector/NET 5.0.4 (Not released)
- B.7.25. Changes in MySQL Connector/NET 5.0.3 (05 January 2007)
- B.7.26. Changes in MySQL Connector/NET 5.0.2 (06 November 2006)
- B.7.27. Changes in MySQL Connector/NET 5.0.1 (01 October 2006)
- B.7.28. Changes in MySQL Connector/NET 5.0.0 (08 August 2006)
- B.7.29. Changes in MySQL Connector/NET 1.0.11 (Not yet released)
- B.7.30. Changes in MySQL Connector/NET 1.0.10 (24 August 2007)
- B.7.31. Changes in MySQL Connector/NET 1.0.9 (02 February 2007)
- B.7.32. Changes in MySQL Connector/NET 1.0.8 (20 October 2006)
- B.7.33. Changes in MySQL Connector/NET 1.0.7 (21 November 2005)
- B.7.34. Changes in MySQL Connector/NET 1.0.6 (03 October 2005)
- B.7.35. Changes in MySQL Connector/NET 1.0.5 (29 August 2005)
- B.7.36. Changes in MySQL Connector/NET 1.0.4 (20 January 2005)
- B.7.37. Changes in MySQL Connector/NET 1.0.3 (12 October 2004: gamma)
- B.7.38. Changes in MySQL Connector/NET 1.0.2 (15 November 2004: gamma)
- B.7.39. Changes in MySQL Connector/NET 1.0.1 (27 October 2004: beta)
- B.7.40. Changes in MySQL Connector/NET 1.0.0 (01 September 2004)
- B.7.41. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
- B.7.42. Changes in MySQL Connector/NET Version 0.76
- B.7.43. Changes in MySQL Connector/NET Version 0.75
- B.7.44. Changes in MySQL Connector/NET Version 0.74
- B.7.45. Changes in MySQL Connector/NET Version 0.71
- B.7.46. Changes in MySQL Connector/NET Version 0.70
- B.7.47. Changes in MySQL Connector/NET Version 0.68
- B.7.48. Changes in MySQL Connector/NET Version 0.65
- B.7.49. Changes in MySQL Connector/NET Version 0.60
- B.7.50. Changes in MySQL Connector/NET Version 0.50
- B.8. MySQL Connector/J Change History [+/-]
- B.8.1. Changes in MySQL Connector/J 5.1.x
- B.8.2. Changes in MySQL Connector/J 5.0.x
- B.8.3. Changes in MySQL Connector/J 3.1.x
- B.8.4. Changes in MySQL Connector/J 3.0.x
- B.8.5. Changes in MySQL Connector/J 2.0.x
- B.8.6. Changes in MySQL Connector/J 1.2b (04 July 1999)
- B.8.7. Changes in MySQL Connector/J 1.2.x and lower
- B.9. MySQL Connector/MXJ Change History [+/-]
- B.9.1. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)
- B.9.2. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)
- B.9.3. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)
- B.9.4. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)
- B.9.5. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)
- B.9.6. Changes in MySQL Connector/MXJ 5.0.1 (Never released)
- B.9.7. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)
- B.10. MySQL Proxy Change History [+/-]
- C. Restrictions and Limits [+/-]
- Index
List of Tables
- 5.1. mysqld Option/Variable Summary
- 5.2. mysqld Session System Variable Summary
- 5.3. mysqld Security Option/Variable Summary
- 5.4. mysqld SSL Option/Variable Summary
- 14.1. mysqld Replication Option/Variable Summary
- 14.2. mysqld Binary Logging Option/Variable Summary
- 15.1. mysqld Option/Variable Reference
- 17.1. MySQL APIs and Interfaces
- 17.2. MySQL Connector versions and MySQL Server versions
- 17.3. Mapping of MySQL Error Numbers to SQLStates
- 17.4. MySQL Configuration Options
- 17.5. MySQL client constants
- 17.6. MySQL fetch constants
- 17.7. MySQLi Configuration Options
- 17.8. Possible mysqli_info return values
- 17.9. Valid options
- 17.10. Supported flags
- 17.11. Attribute values
- 17.12. Type specification chars
- 17.13. Return Values
- 17.14. Object attributes
- 17.15. Object properties
- 17.16. Object properties
- 17.17. Supported flags
List of Examples
- 17.1. Obtaining a connection from the
DriverManager - 17.2. Using java.sql.Statement to execute a
SELECTquery - 17.3. Stored Procedures
- 17.4. Using
Connection.prepareCall() - 17.5. Registering output parameters
- 17.6. Setting
CallableStatementinput parameters - 17.7. Retrieving results and output parameter values
- 17.8. Retrieving
AUTO_INCREMENTcolumn values usingStatement.getGeneratedKeys() - 17.9. Retrieving
AUTO_INCREMENTcolumn values usingSELECT LAST_INSERT_ID() - 17.10. Retrieving
AUTO_INCREMENTcolumn values inUpdatable ResultSets - 17.11. Using a connection pool with a J2EE application server
- 17.12. Example of transaction with retry logic
- 17.13. MySQL extension overview example
- 17.14.
mysql_affected_rowsexample - 17.15.
mysql_affected_rowsexample using transactions - 17.16.
mysql_client_encodingexample - 17.17.
mysql_closeexample - 17.18.
mysql_connectexample - 17.19.
mysql_connectexample usinghostname:portsyntax - 17.20.
mysql_connectexample using ":/path/to/socket" syntax - 17.21.
mysql_create_dbalternative example - 17.22.
mysql_data_seekexample - 17.23.
mysql_db_nameexample - 17.24.
mysql_db_queryalternative example - 17.25.
mysql_drop_dbalternative example - 17.26.
mysql_errnoexample - 17.27.
mysql_errorexample - 17.28.
mysql_escape_stringexample - 17.29. Query with aliased duplicate field names
- 17.30.
mysql_fetch_arraywithMYSQL_NUM - 17.31.
mysql_fetch_arraywithMYSQL_ASSOC - 17.32.
mysql_fetch_arraywithMYSQL_BOTH - 17.33. An expanded
mysql_fetch_assocexample - 17.34.
mysql_fetch_fieldexample - 17.35. A
mysql_fetch_lengthsexample - 17.36.
mysql_fetch_objectexample - 17.37.
mysql_fetch_objectexample - 17.38. Fetching one row with
mysql_fetch_row - 17.39. A
mysql_field_flagsexample - 17.40.
mysql_field_lenexample - 17.41.
mysql_field_nameexample - 17.42. A
mysql_field_tableexample - 17.43.
mysql_field_typeexample - 17.44. A
mysql_free_resultexample - 17.45.
mysql_get_client_infoexample - 17.46.
mysql_get_host_infoexample - 17.47.
mysql_get_proto_infoexample - 17.48.
mysql_get_server_infoexample - 17.49. Relevant MySQL Statements
- 17.50.
mysql_insert_idexample - 17.51.
mysql_list_dbsexample - 17.52. Alternate to deprecated
mysql_list_fields - 17.53.
mysql_list_processesexample - 17.54.
mysql_list_tablesalternative example - 17.55. A
mysql_num_fieldsexample - 17.56.
mysql_num_rowsexample - 17.57. A
mysql_pingexample - 17.58. Invalid Query
- 17.59. Valid Query
- 17.60. Simple
mysql_real_escape_stringexample - 17.61. An example SQL Injection Attack
- 17.62. A "Best Practice" query
- 17.63.
mysql_resultexample - 17.64.
mysql_select_dbexample - 17.65.
mysql_statexample - 17.66. Alternative
mysql_statexample - 17.67.
mysql_tablenameexample - 17.68.
mysql_thread_idexample - 17.69. Object oriented style
- 17.70. Procedural style
- 17.71. Object oriented style
- 17.72. Procedural style
- 17.73. Object oriented style
- 17.74. Procedural style
- 17.75. Object oriented style
- 17.76. Procedural style
- 17.77. Object oriented style
- 17.78. Procedural style
- 17.79.
mysqli_connect_errnoexample - 17.80.
mysqli_connect_errorexample - 17.81. Object oriented style
- 17.82. Procedural style
- 17.83. Generating a Trace File
- 17.84. Object oriented style
- 17.85. Procedural style
- 17.86. Object oriented style
- 17.87. Procedural style
- 17.88. Object oriented style
- 17.89. Procedural style
- 17.90. Object oriented style
- 17.91. Procedural style
- 17.92. mysqli_get_client_info
- 17.93. mysqli_get_client_version
- 17.94. Object oriented style
- 17.95. Procedural style
- 17.96. Object oriented style
- 17.97. Procedural style
- 17.98. Object oriented style
- 17.99. Procedural style
- 17.100. Object oriented style
- 17.101. Procedural style
- 17.102. Object oriented style
- 17.103. Procedural style
- 17.104. Object oriented style
- 17.105. Procedural style
- 17.106. Object oriented style
- 17.107. Procedural style
- 17.108. Object oriented style
- 17.109. Procedural style
- 17.110. Object oriented style
- 17.111. Procedural style
- 17.112. Object oriented style
- 17.113. Procedural style
- 17.114. Object oriented style
- 17.115. Procedural style
- 17.116. Object oriented style
- 17.117. Procedural style
- 17.118. Object oriented style
- 17.119. Procedural style
- 17.120. Object oriented style
- 17.121. Procedural style
- 17.122. Object oriented style
- 17.123. Procedural style
- 17.124. Object oriented style
- 17.125. Procedural style
- 17.126. Object oriented style
- 17.127. Procedural style
- 17.128. Object oriented style
- 17.129. Procedural style
- 17.130. Object oriented style
- 17.131. Procedural style
- 17.132. Object oriented style
- 17.133. Procedural style
- 17.134. Object oriented style
- 17.135. Procedural style
- 17.136. Object oriented style
- 17.137. Procedural style
- 17.138. Object oriented style
- 17.139. Procedural style
- 17.140. Object oriented style
- 17.141. Procedural style
- 17.142. Object oriented style
- 17.143. Procedural style
- 17.144. Object oriented style
- 17.145. Procedural style
- 17.146. Object oriented style
- 17.147. Procedural style
- 17.148. Object oriented style
- 17.149. Procedural style
- 17.150. Object oriented style
- 17.151. Procedural style
- 17.152. Object oriented style
- 17.153. Procedural style
- 17.154. Object oriented style
- 17.155. Procedural style
- 17.156. Object oriented style
- 17.157. Procedural style
- 17.158. Object oriented style
- 17.159. Procedural style
- 17.160. Object oriented style
- 17.161. Procedural style
- 17.162. Object oriented style
- 17.163. Object oriented style
- 17.164. Procedural style
- 17.165. Object oriented style
- 17.166. Procedural style
- 17.167. Object oriented style
- 17.168. Procedural style
- 17.169. Object oriented style
- 17.170. Procedural style
- 17.171. Object oriented style
- 17.172. Procedural style
- 17.173. Object oriented style
- 17.174. Procedural style
- 17.175. Object oriented style
- 17.176. Procedural style
- 17.177. Object oriented style
- 17.178. Procedural style
- 17.179. Object oriented style
- 17.180. Procedural style
- 17.181. Object oriented style
- 17.182. Procedural style
- 17.183. Object oriented style
- 17.184. Procedural style
- 17.185. Object oriented style
- 17.186. Procedural style
- 17.187. Object oriented style
- 17.188. Procedural style
- 17.189. Object oriented style
- 17.190. Procedural style
- 17.191. Object oriented style
- 17.192. Procedural style
- 17.193. Object oriented style
- 17.194. Forcing queries to be buffered in mysql
- 17.195. PDO_MYSQL DSN examples
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.