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-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 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.
概要
Document generated on: 2010-03-11 (改訂: 548)
目次
mysqld
スタートアップオプションLOAD DATA LOCAL
のセキュリティ関連事項Access denied
エラーの原因mysql
(コマンドラインツール)mysqlcc
(MySQL コントロールセンタ)mysqladmin
(MySQL サーバの管理)mysqlbinlog
(バイナリログからクエリを実行する)mysqlcheck
を使用したテーブルの保守とクラッシュのリカバリmysqldump
(テーブル構造とデータのダンプ)mysqlhotcopy
(MySQL
のデータベースとテーブルのコピー)mysqlimport
(テキストファイルからのデータのインポート)mysqlshow
(データベース、テーブル、およびカラムの表示)mysql_config
(クライアントをコンパイルするためのコンパイルオプションの取得)perror
(エラーコードの説明)SELECT
ステートメントおよびその他のクエリの最適化 [+/-]EXPLAIN
構文(SELECT
に関する情報の取得)SELECT
クエリの速度WHERE
節の最適化IS NULL
の最適化DISTINCT
の最適化LEFT JOIN
と RIGHT
JOIN
の最適化ORDER BY
の最適化LIMIT
の最適化INSERT
クエリの速度UPDATE
クエリの速度DELETE
クエリの速度MyISAM
テーブル [+/-]MERGE
テーブル [+/-]ISAM
テーブルHEAP
テーブルInnoDB
テーブル [+/-]InnoDB
についての問い合わせ先BDB
または BerkeleyDB
テーブル [+/-]COLLATE
節COLLATE
節の優先順位BINARY
演算子Access denied
エラーMySQL server has gone away
エラーCan't connect to [local] MySQL server
エラーClient does not support authentication protocol
エラーHost '...' is blocked
エラーToo many connections
エラーSome non-transactional changed tables couldn't be rolled
back
エラーOut of memory
エラー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
エラー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.