Copyright © 1997-2008 MySQL AB, 2008-2010 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, 2008-2010 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 http://www.mysql.com/company/contact/.
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.26.
MySQL 3.23, MySQL 4.0, and MySQL 4.1 features. This manual describes features that are not included in every edition of MySQL 3.23, MySQL 4.0, and MySQL 4.1; such features may not be included in the edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1; licensed to you. If you have any questions about the features included in your edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1, refer to your MySQL 3.23, MySQL 4.0, or MySQL 4.1 agreement or contact your Sun Microsystems sales representative.
Document generated on: 2010-02-09 (revision: 19020)
End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Table of Contents [+/-]
tar.gz Packages on Other
Unix-Like SystemsAUTO_INCREMENTSELECT and Other Statements [+/-]EXPLAINSELECT QueriesWHERE Clause OptimizationIS NULL OptimizationLEFT JOIN and RIGHT JOIN
OptimizationORDER BY OptimizationGROUP BY OptimizationDISTINCT OptimizationLIMIT OptimizationINSERT StatementsUPDATE StatementsDELETE StatementsMyISAM Key CacheInnoDB Buffer PoolMyISAM Index Statistics CollectionGROUP BY Clauses [+/-]MyISAM Storage Engine [+/-]InnoDB Storage Engine [+/-]InnoDB Contact InformationInnoDB in MySQL 3.23InnoDB ConfigurationInnoDB Startup Options and System VariablesInnoDB TablesInnoDB Data and Log
FilesInnoDB
DatabaseInnoDB Database to Another MachineInnoDB Transaction Model and LockingInnoDB Multi-VersioningInnoDB Table and Index StructuresInnoDB Disk I/O and File Space ManagementInnoDB Error HandlingInnoDB Performance Tuning and TroubleshootingInnoDB TablesMERGE Storage Engine [+/-]MEMORY (HEAP) Storage EngineBDB (BerkeleyDB) Storage
Engine [+/-]EXAMPLE Storage EngineARCHIVE Storage EngineCSV Storage EngineBLACKHOLE Storage EngineISAM Storage EngineGeometryPointCurveLineStringSurfacePolygonGeometryCollectionMultiPointMultiCurveMultiLineStringMultiSurfaceMultiPolygonGeometry FunctionsInnoDB [+/-]List of Figures [+/-]
List of Tables [+/-]
mysqld_safe Options
mysql Options
mysqladmin Options
mysqlcheck Options
mysqldump Options
mysqlimport Options
mysqlshow Options
myisamchk Options
mysqlaccess Options
mysqlbinlog Options
mysqldumpslow Options
mysqlhotcopy Options
mysql_tableinfo
Options
GROUP BY)
Functions
List of Examples [+/-]
DriverManager
SELECT query
Connection.prepareCall()
CallableStatement input
parameters
AUTO_INCREMENT column values
using Statement.getGeneratedKeys()
AUTO_INCREMENT column values
using SELECT LAST_INSERT_ID()
AUTO_INCREMENT column values
in Updatable ResultSets
mysql_affected_rows
example
mysql_affected_rows
example using transactions
mysql_client_encoding
example
mysql_close
example
mysql_connect
example
mysql_connect
example using hostname:port syntax
mysql_connect
example using ":/path/to/socket" syntax
mysql_create_db
alternative example
mysql_data_seek
example
mysql_db_name
example
mysql_db_query
alternative example
mysql_drop_db
alternative example
mysql_errno
example
mysql_error
example
mysql_escape_string
example
mysql_fetch_array
with
MYSQL_NUM
mysql_fetch_array
with
MYSQL_ASSOC
mysql_fetch_array
with
MYSQL_BOTH
mysql_fetch_assoc
example
mysql_fetch_field
example
mysql_fetch_lengths
example
mysql_fetch_object
example
mysql_fetch_object
example
mysql_fetch_row
mysql_field_flags
example
mysql_field_len
example
mysql_field_name
example
mysql_field_table
example
mysql_field_type
example
mysql_free_result
example
mysql_get_client_info
example
mysql_get_host_info
example
mysql_get_proto_info
example
mysql_get_server_info
example
mysql_insert_id
example
mysql_list_dbs
example
mysql_list_fields
mysql_list_processes
example
mysql_list_tables
alternative example
mysql_num_fields
example
mysql_num_rows
example
mysql_ping
example
mysql_real_escape_string
example
mysql_result
example
mysql_select_db
example
mysql_stat
example
mysql_stat
example
mysql_tablename
example
mysql_thread_id
example
mysqli_get_connection_stats example
mysqli_poll
example
mysqli_get_cache_stats example
mysqli_get_client_stats example
