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
configure
MIT-pthreads
mysql
en mode batchAUTO_INCREMENT
Access denied
SELECT
et autres requêtes [+/-]EXPLAIN
(Obtenir des informations sur les
SELECT
)SELECT
WHERE
IS NULL
DISTINCT
LEFT JOIN
et
RIGHT JOIN
ORDER BY
GROUP BY
LIMIT
INSERT
UPDATE
DELETE
MyISAM
myisampack
, 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'erreursreplace
COLLATE
dans différentes parties d'une
requête SQLCOLLATE
clause de précédenceBINARY
SELECT
et
WHERE
[+/-]Full-text
) dans MySQL [+/-]GROUP
BY
[+/-]SELECT
,
INSERT
, UPDATE
,
DELETE
[+/-]CREATE
,
DROP
, ALTER
[+/-]START TRANSACTION
,
COMMIT
et ROLLBACK
SAVEPOINT
et ROLLBACK TO
SAVEPOINT
LOCK TABLES/UNLOCK TABLES
SET TRANSACTION
MyISAM
[+/-]MERGE
[+/-]MEMORY
(HEAP
)BDB
ou BerkeleyDB
[+/-]BDB
BDB
BDB
BDB
BDB
dans un futur
proche :BDB
BDB
EXAMPLE
FEDERATED
[+/-]ARCHIVE
CSV
ISAM
InnoDB
[+/-]InnoDB
InnoDB
InnoDB
avec MySQL version 3.23InnoDB
InnoDB
InnoDB
[+/-]InnoDB
[+/-]InnoDB
avec
différentes APIMyISAM
vers
InnoDB
AUTO_INCREMENT
fonctionnent avec
InnoDB
FOREIGN KEY
InnoDB
et la réplication MySQLInnoDB
a
son fichier .ibd
InnoDB
InnoDB
[+/-]InnoDB
vers une
autre machineInnoDB
et AUTOCOMMIT
SET ... TRANSACTION ISOLATION LEVEL ...
SELECT ... FOR UPDATE
et
SELECT ... LOCK IN SHARE MODE
InnoDB
InnoDB
InnoDB
[+/-]InnoDB
[+/-]InnoDB
InnoDB
[+/-]Geometry
Point
Curve
LineString
Surface
Polygon
GeometryCollection
MultiPoint
MultiCurve
MultiLineString
MultiSurface
MultiPolygon
Geometry
CREATE PROCEDURE
et CREATE
FUNCTION
ALTER PROCEDURE
et ALTER FUNCTION
DROP PROCEDURE
et DROP FUNCTION
SHOW CREATE PROCEDURE
et SHOW CREATE
FUNCTION
SHOW PROCEDURE STATUS
et SHOW FUNCTION
STATUS
CALL
BEGIN ... END
DECLARE
INFORMATION_SCHEMA
[+/-]INFORMATION_SCHEMA
[+/-]INFORMATION_SCHEMA SCHEMATA
INFORMATION_SCHEMA TABLES
INFORMATION_SCHEMA COLUMNS
INFORMATION_SCHEMA STATISTICS
INFORMATION_SCHEMA USER_PRIVILEGES
INFORMATION_SCHEMA SCHEMA_PRIVILEGES
INFORMATION_SCHEMA TABLE_PRIVILEGES
INFORMATION_SCHEMA COLUMN_PRIVILEGES
INFORMATION_SCHEMA CHARACTER_SETS
INFORMATION_SCHEMA COLLATIONS
INFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITY
INFORMATION_SCHEMA TABLE_CONSTRAINTS
INFORMATION_SCHEMA KEY_COLUMN_USAGE
INFORMATION_SCHEMA ROUTINES
INFORMATION_SCHEMA VIEWS
INFORMATION_SCHEMA
SHOW
libmysqld
, la bibliothèque du serveur embarqué
MySQLAccess denied
Can't connect to [local] MySQL server
Client does not support authentication
protocol
Host '...' is blocked
Too many connections
Out of memory
MySQL server has gone away
Packet too large
The table is full
Can't create/write to file
Commands out of sync
Ignoring user
Table 'xxx' doesn't exist
Can't initialize character set xxx
/tmp/mysql.sock
DATE
NULL
alias
Some non-transactional changed tables couldn't be rolled
back
MySQL Cluster
[+/-]MyODBC
[+/-]mysqld
sous gdb
mysqld
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.