MySQL Reference Manual for version 3.23.5-alpha. - Table des matières simplifié



	Sommaire court [Sommaire complet] 1 General Information about MySQL 1.1 What is MySQL? 1.2 About this manual 1.3 History of MySQL 1.4 The main features of MySQL 1.5 How stable is MySQL? 1.6 Year 2000 compliance 1.7 General SQL information and tutorials 1.8 Useful MySQL-related links 2 MySQL mailing lists and how to ask questions or report errors (bugs) 2.1 The MySQL mailing lists 2.2 Asking questions or reporting bugs 2.3 How to report bugs or problems 2.4 Guidelines for answering questions on the mailing list 3 MySQL licensing and support 3.1 MySQL licensing policy 3.2 Copyrights used by MySQL 3.3 Distributing MySQL commercially 3.4 Example licensing situations 3.5 MySQL licensing and support costs 3.6 Types of commercial support 4 Installing MySQL 4.1 How to get MySQL 4.2 Operating systems supported by MySQL 4.3 Which MySQL version to use 4.4 How and when updates are released 4.5 Installation layouts 4.6 Installing a MySQL binary distribution 4.7 Installing a MySQL source distribution 4.8 Problems compiling? 4.9 MIT-pthreads notes 4.10 Perl installation comments 4.11 System-specific issues 4.12 Win32 notes 4.13 OS/2 notes 4.14 TcX binaries 4.15 Post-installation setup and testing 4.16 Is there anything special to do when upgrading/downgrading MySQL? 5 How standards-compatible is MySQL? 5.1 MySQL extensions to ANSI SQL92 5.2 MySQL differences compared to ANSI SQL92 5.3 Functionality missing from MySQL 5.4 What standards does MySQL follow? 5.5 How to cope without `COMMIT`/`ROLLBACK` 6 The MySQL access privilege system 6.1 What the privilege system does 6.2 MySQL user names and passwords 6.3 Connecting to the MySQL server 6.4 Keeping your password secure 6.5 Privileges provided by MySQL 6.6 How the privilege system works 6.7 Access control, stage 1: Connection verification 6.8 Access control, stage 2: Request verification 6.9 When privilege changes take effect 6.10 Setting up the initial MySQL privileges 6.11 Adding new user privileges to MySQL 6.12 How to set up passwords 6.13 Causes of `Access denied` errors 6.14 How to make MySQL secure against crackers 7 MySQL language reference 7.1 Literals: how to write strings and numbers 7.2 Column types 7.3 Functions for use in `SELECT` and `WHERE` clauses 7.4 `CREATE DATABASE` syntax 7.5 `DROP DATABASE` syntax 7.6 `CREATE TABLE` syntax 7.7 `ALTER TABLE` syntax 7.8 `OPTIMIZE TABLE` syntax 7.9 `DROP TABLE` syntax 7.10 `DELETE` syntax 7.11 `SELECT` syntax 7.12 `JOIN` syntax 7.13 `INSERT` syntax 7.14 `REPLACE` syntax 7.15 `LOAD DATA INFILE` syntax 7.16 `UPDATE` syntax 7.17 `USE` syntax 7.18 `FLUSH` syntax (clearing caches) 7.19 `KILL` syntax 7.20 `SHOW` syntax (Get information about tables, columns,...) 7.21 `EXPLAIN` syntax (Get information about a `SELECT`) 7.22 `DESCRIBE` syntax (Get information about columns) 7.23 `LOCK TABLES/UNLOCK TABLES` syntax 7.24 `SET OPTION` syntax 7.25 `GRANT` and `REVOKE` syntax 7.26 `CREATE INDEX` syntax 7.27 `DROP INDEX` syntax 7.28 Comment syntax 7.29 `CREATE FUNCTION/DROP FUNCTION` syntax 7.30 Is MySQL picky about reserved words? 8 MySQL Tutorial 8.1 Connecting to and disconnecting from the server 8.2 Entering queries 8.3 Examples of common queries 8.4 Creating and using a database 8.5 Getting information about databases and tables 8.6 Using `mysql` in batch mode 8.7 Queries from twin project 9 MySQL server functions 9.1 What languages are supported by MySQL? 9.2 The update log 9.3 How big MySQL tables can be 10 Getting maximum performance from MySQL 10.1 Tuning server parameters 10.2 How MySQL uses memory 10.3 How compiling and linking affects the speed of MySQL 10.4 How MySQL uses indexes 10.5 How MySQL optimizes `WHERE` clauses 10.6 How MySQL optimizes `LEFT JOIN` 10.7 How MySQL optimizes `LIMIT` 10.8 How MySQL opens and closes tables 10.9 Why so many open tables? 10.10 Using symbolic links for databases and tables 10.11 How MySQL locks tables 10.12 Table locking issues 10.13 How to arrange a table to be as fast/small as possible 10.14 Factors affecting the speed of `INSERT` statements 10.15 Factors affecting the speed of `DELETE` statements 10.16 How do I get MySQL to run at full speed? 10.17 What are the different row formats? Or, when should `VARCHAR/CHAR` be used? 10.18 MySQL table types. 11 The MySQL benchmark suite 12 MySQL Utilites 12.1 Overview of the different MySQL programs 12.2 Administering a MySQL server 12.3 Dumping the structure and data from MySQL databases and tables 12.4 Importing data from text files 12.5 The MySQL compressed read-only table generator 13 Maintaining a MySQL installation 13.1 Using `isamchk` for table maintenance and crash recovery 13.2 Setting up a table maintenance regimen 13.3 Getting information about a table 13.4 Using `isamchk` for crash recovery 13.5 Log file maintenance 14 Adding new functions to MySQL 14.1 Adding a new user-definable function 14.2 Adding a new native function 15 Adding new procedures to MySQL 15.1 Procedure analyse 15.2 Writing a procedure. 16 MySQL ODBC Support 16.1 Operating systems supported by MyODBC 16.2 How to report problems with MyODBC 16.3 Programs known to work with MyODBC 16.4 How to fill in the various fields in the ODBC administrator program 16.5 How to get the value of an `AUTO_INCREMENT` column in ODBC 16.6 Reporting problems with MyODBC 17 Using `MySQL` with some common programs 17.1 Using MySQL with Apache 18 Problems and common errors 18.1 What to do if MySQL keeps crashing 18.2 Some common errors when using MySQL 18.3 How MySQL handles a full disk 18.4 How to run SQL commands from a text file 18.5 Where MySQL stores temporary files 18.6 How to protect `/tmp/mysql.sock' from being deleted 18.7 `Access denied` error 18.8 How to run MySQL as a normal user 18.9 How to reset a forgotten password. 18.10 Problems with file permissions 18.11 File not found 18.12 Problems using `DATE` columns 18.13 Timezone problems 18.14 Case sensitivity in searches 18.15 Problems with `NULL` values 18.16 Problems with `alias` 18.17 Deleting rows from related tables 18.18 Solving problems with no matching rows 18.19 Problems with `ALTER TABLE`. 18.20 How to change the order of columns in a table 19 Solving some common problems with MySQL 19.1 Database replication 19.2 Database backups 19.3 Running multiple MySQL servers on the same machine 20 MySQL client tools and APIs 20.1 MySQL C API 20.2 C API datatypes 20.3 C API function overview 20.4 C API function descriptions 20.5 MySQL Perl API 20.6 MySQL Eiffel wrapper 20.7 MySQL Java connectivity (JDBC) 20.8 MySQL PHP API 20.9 MySQL C++ APIs 20.10 MySQL Python APIs 20.11 MySQL TCL APIs 21 How MySQL compares to other databases 21.1 How MySQL compares to `mSQL` 21.2 How MySQL compares to PostgreSQL A Some MySQL users A.1 General news sites A.2 Some Web search engines A.3 Some Information search engines concentrated on some area A.4 Web sites the use MySQL as a backed A.5 Some Domain/Internet/Web and related services A.6 Web sites that use `PHP` and MySQL A.7 Some MySQL consultants A.8 Programming A.9 Uncategorized pages B Contributed programs B.1 API's B.2 Clients B.3 Web tools B.4 Authentication tools B.5 Converters B.6 Using MySQL with other products B.7 Useful tools B.8 Uncategorized C Contributors to MySQL D MySQL change history D.1 Changes in release 3.23.x (Released as alpha) D.2 Changes in release 3.22.x D.3 Changes in release 3.21.x 21.3 Changes in release 3.20.x D.4 Changes in release 3.19.x E Known errors and design deficiencies in MySQL F List of things we want to add to MySQL in the future (The TODO) F.1 Things that must done in the real near future F.2 Things that have to be done sometime F.3 Some things we don't have any plans to do G Comments on porting to other systems G.1 Debugging a MySQL server G.2 Debugging a MySQL client G.3 Comments about RTS threads G.4 Differences between different thread packages H Description of MySQL regular expression syntax I What is Unireg? J The MySQL server license for non Microsoft operating systems K The MySQL license for Microsoft operating systems SQL command, type and function index Concept Index Sommaire court [Sommaire complet]

This document was generated on 11 August 2000 using the texi2html translator version 1.52 (extended by davida@detron.se, hacked by dams@nexen.net for French translation).