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 website 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 email <docs@mysql.com> for more information or
if you are interested in doing a translation.
Résumé
Document generated on: 2007-05-05 (version: 187)
Table des matières
configureMIT-pthreadsmysql en mode batchAUTO_INCREMENTAccess deniedSELECT et autres requêtesEXPLAIN (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 commandemysqladmin, 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édenceBINARY SELECT et WHEREFull-text) dans MySQLGROUP BYSELECT, INSERT, UPDATE, DELETECREATE, DROP, ALTERMyISAMMERGEMEMORY (HEAP)BDB ou BerkeleyDBBDBBDBBDBBDBBDB dans un futur proche : BDBBDBEXAMPLEFEDERATEDARCHIVECSVISAMInnoDBInnoDBInnoDBInnoDB avec MySQL version 3.23InnoDBInnoDBInnoDBInnoDBInnoDB avec différentes APIMyISAM vers InnoDBAUTO_INCREMENT fonctionnent avec InnoDBFOREIGN KEYInnoDB et la réplication MySQLInnoDB a son fichier .ibdInnoDBInnoDBInnoDB vers une autre machineInnoDB et AUTOCOMMITSET ... TRANSACTION ISOLATION LEVEL ...SELECT ... FOR UPDATE et SELECT ... LOCK IN SHARE MODEInnoDBInnoDBInnoDBInnoDBInnoDBInnoDBGeometryPointCurveLineStringSurfacePolygonGeometryCollectionMultiPointMultiCurveMultiLineStringMultiSurfaceMultiPolygonGeometryCREATE 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_SCHEMAINFORMATION_SCHEMAINFORMATION_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 connections Out 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 xxxDATENULLaliasSome non-transactional changed tables couldn't be rolled backMySQL ClusterMyODBCmysqld 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.