The world's most popular open source database
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
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 Documentation Team for more information or if you are interested in doing a translation.
Résumé
Document generated on: 2009-08-20 (version: 260)
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.

