This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
Copyright © 1997-2007 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-2007 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 MySQL 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 MySQL AB. MySQL AB reserves any and all rights to this documentation not expressly granted above.
Please contact the http://www.mysql.com/company/contact/ for more information or if you are interested in doing a translation.
Résumé
Document generated on: 2010-03-21 (version: 269)
Table des matières
configureMIT-pthreadsmysql en mode batchAUTO_INCREMENTAccess deniedSELECT et autres requêtes [+/-]EXPLAIN (Obtenir des informations sur les
SELECT)SELECTWHEREIS NULLDISTINCTLEFT JOIN et
RIGHT JOINORDER BYGROUP BYLIMITINSERTUPDATEDELETEMyISAMmyisampack, le générateur de tables MySQL
compressées en lecture seulemysql, l'outil en ligne de commande [+/-]mysqladmin, administration d'un serveur MySQLmysqlbinlog, Exécuter des requêtes dans le log
binairemysqlcc, MySQL Control Centermysqlcheck pour l'entretien et la
réparationmysqldump, sauvegarde des structures de tables et les
donnéesmysqlhotcopy, copier les bases et tables MySQLmysqlimport, importer des données depuis des
fichiers texteperror, expliquer les codes d'erreursreplaceCOLLATE dans différentes parties d'une
requête SQLCOLLATE clause de précédenceBINARYSELECT et
WHERE [+/-]Full-text) dans MySQL [+/-]GROUP
BY [+/-]SELECT,
INSERT, UPDATE,
DELETE [+/-]CREATE,
DROP, ALTER [+/-]START TRANSACTION,
COMMIT et ROLLBACKSAVEPOINT et ROLLBACK TO
SAVEPOINTLOCK TABLES/UNLOCK TABLESSET TRANSACTIONMyISAM [+/-]MERGE [+/-]MEMORY (HEAP)BDB ou BerkeleyDB [+/-]BDBBDBBDBBDBBDB dans un futur
proche :BDBBDBEXAMPLEFEDERATED [+/-]ARCHIVECSVISAMInnoDB [+/-]InnoDBInnoDBInnoDB avec MySQL version 3.23InnoDBInnoDBInnoDB [+/-]InnoDB [+/-]InnoDB avec
différentes APIMyISAM vers
InnoDBAUTO_INCREMENT fonctionnent avec
InnoDBFOREIGN KEYInnoDB et la réplication MySQLInnoDB a
son fichier .ibdInnoDBInnoDB [+/-]InnoDB vers une
autre machineInnoDB et AUTOCOMMITSET ... TRANSACTION ISOLATION LEVEL ...SELECT ... FOR UPDATE et
SELECT ... LOCK IN SHARE MODEInnoDBInnoDBInnoDB [+/-]InnoDB [+/-]InnoDBInnoDB [+/-]GeometryPointCurveLineStringSurfacePolygonGeometryCollectionMultiPointMultiCurveMultiLineStringMultiSurfaceMultiPolygonGeometryCREATE PROCEDURE et CREATE
FUNCTIONALTER PROCEDURE et ALTER FUNCTIONDROP PROCEDURE et DROP FUNCTIONSHOW CREATE PROCEDURE et SHOW CREATE
FUNCTIONSHOW PROCEDURE STATUS et SHOW FUNCTION
STATUSCALLBEGIN ... ENDDECLAREINFORMATION_SCHEMA [+/-]INFORMATION_SCHEMA [+/-]INFORMATION_SCHEMA SCHEMATAINFORMATION_SCHEMA TABLESINFORMATION_SCHEMA COLUMNSINFORMATION_SCHEMA STATISTICSINFORMATION_SCHEMA USER_PRIVILEGESINFORMATION_SCHEMA SCHEMA_PRIVILEGESINFORMATION_SCHEMA TABLE_PRIVILEGESINFORMATION_SCHEMA COLUMN_PRIVILEGESINFORMATION_SCHEMA CHARACTER_SETSINFORMATION_SCHEMA COLLATIONSINFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITYINFORMATION_SCHEMA TABLE_CONSTRAINTSINFORMATION_SCHEMA KEY_COLUMN_USAGEINFORMATION_SCHEMA ROUTINESINFORMATION_SCHEMA VIEWSINFORMATION_SCHEMASHOWlibmysqld, la bibliothèque du serveur embarqué
MySQLAccess deniedCan't connect to [local] MySQL serverClient does not support authentication
protocolHost '...' is blockedToo many connectionsOut of memoryMySQL server has gone awayPacket too largeThe table is fullCan't create/write to fileCommands out of syncIgnoring userTable 'xxx' doesn't existCan't initialize character set xxx/tmp/mysql.sockDATENULLaliasSome non-transactional changed tables couldn't be rolled
backMySQL Cluster [+/-]MyODBC [+/-]mysqld sous gdbmysqldThis is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
