 |
|
| [Top] | [Contents] | [Index] | [ ? ] |
Table of Contents
- 1. General Information
- 1.1 About This Manual
- 1.2 What Is MySQL?
- 1.3 What Is MySQL AB?
- 1.4 MySQL Support and Licensing
- 1.4.1 Support Offered by MySQL AB
- 1.4.2 Copyrights and Licenses Used by MySQL
- 1.4.3 MySQL Licenses
- 1.4.4 MySQL AB Logos and Trademarks
- 1.4.4.1 The Original MySQL Logo
- 1.4.4.2 MySQL Logos that may be Used Without Written Permission
- 1.4.4.3 When do you need a Written Permission to use MySQL Logos?
- 1.4.4.4 MySQL AB Partnership Logos
- 1.4.4.5 Using the word
MySQLin Printed Text or Presentations - 1.4.4.6 Using the word
MySQLin Company and Product Names
- 1.5 MySQL Development Roadmap
- 1.6 MySQL Information Sources
- 1.7 MySQL Standards Compliancy
- 1.8 MySQL and The Future (The TODO)
- 2. Installing MySQL
- 2.1 Quick Standard Installation of MySQL
- 2.2 General Installation Issues
- 2.2.1 How to Get MySQL
- 2.2.2 Verifying Package Integrity Using
MD5 ChecksumsorGnuPG - 2.2.3 Operating Systems Supported by MySQL
- 2.2.4 Which MySQL Version to Use
- 2.2.5 Installation Layouts
- 2.2.6 How and When Updates Are Released
- 2.2.7 Release Philosophy - No Known Bugs in Releases
- 2.2.8 MySQL Binaries Compiled by MySQL AB
- 2.2.9 Installing a MySQL Binary Distribution
- 2.3 Installing a MySQL Source Distribution
- 2.4 Post-installation Setup and Testing
- 2.5 Upgrading/Downgrading MySQL
- 2.6 Operating System Specific Notes
- 2.6.1 Windows Notes
- 2.6.1.1 Starting MySQL on Windows 95, 98, or Me
- 2.6.1.2 Starting MySQL on Windows NT, 2000, or XP
- 2.6.1.3 Running MySQL on Windows
- 2.6.1.4 Connecting to MySQL Remotely from Windows with SSH
- 2.6.1.5 Distributing Data Across Different Disks on Windows
- 2.6.1.6 Compiling MySQL Clients on Windows
- 2.6.1.7 MySQL for Windows Compared to Unix MySQL
- 2.6.2 Linux Notes (All Linux Versions)
- 2.6.3 Solaris Notes
- 2.6.4 BSD Notes
- 2.6.5 Mac OS X Notes
- 2.6.6 Other Unix Notes
- 2.6.6.1 HP-UX Notes for Binary Distributions
- 2.6.6.2 HP-UX Version 10.20 Notes
- 2.6.6.3 HP-UX Version 11.x Notes
- 2.6.6.4 IBM-AIX notes
- 2.6.6.5 SunOS 4 Notes
- 2.6.6.6 Alpha-DEC-UNIX Notes (Tru64)
- 2.6.6.7 Alpha-DEC-OSF/1 Notes
- 2.6.6.8 SGI Irix Notes
- 2.6.6.9 SCO Notes
- 2.6.6.10 SCO UnixWare Version 7.1.x Notes
- 2.6.7 OS/2 Notes
- 2.6.8 Novell NetWare Notes
- 2.6.9 BeOS Notes
- 2.6.1 Windows Notes
- 2.7 Perl Installation Comments
- 3. MySQL Tutorial
- 3.1 Connecting to and Disconnecting from the Server
- 3.2 Entering Queries
- 3.3 Creating and Using a Database
- 3.4 Getting Information About Databases and Tables
- 3.5 Using
mysqlin Batch Mode - 3.6 Examples of Common Queries
- 3.6.1 The Maximum Value for a Column
- 3.6.2 The Row Holding the Maximum of a Certain Column
- 3.6.3 Maximum of Column per Group
- 3.6.4 The Rows Holding the Group-wise Maximum of a Certain Field
- 3.6.5 Using User Variables
- 3.6.6 Using Foreign Keys
- 3.6.7 Searching on Two Keys
- 3.6.8 Calculating Visits Per Day
- 3.6.9 Using
AUTO_INCREMENT
- 3.7 Queries from the Twin Project
- 3.8 Using MySQL with Apache
- 4. Database Administration
- 4.1 Configuring MySQL
- 4.2 General Security Issues and the MySQL Access Privilege System
- 4.2.1 General Security Guidelines
- 4.2.2 How to Make MySQL Secure Against Crackers
- 4.2.3 Startup Options for
mysqldConcerning Security - 4.2.4 Security issues with
LOAD DATA LOCAL - 4.2.5 What the Privilege System Does
- 4.2.6 How the Privilege System Works
- 4.2.7 Privileges Provided by MySQL
- 4.2.8 Connecting to the MySQL Server
- 4.2.9 Access Control, Stage 1: Connection Verification
- 4.2.10 Access Control, Stage 2: Request Verification
- 4.2.11 Password Hashing in MySQL 4.1
- 4.2.12 Causes of
Access deniedErrors
- 4.3 MySQL User Account Management
- 4.3.1
GRANTandREVOKESyntax - 4.3.2 MySQL User Names and Passwords
- 4.3.3 When Privilege Changes Take Effect
- 4.3.4 Setting Up the Initial MySQL Privileges
- 4.3.5 Adding New Users to MySQL
- 4.3.6 Limiting user resources
- 4.3.7 Setting Up Passwords
- 4.3.8 Keeping Your Password Secure
- 4.3.9 Using Secure Connections
- 4.3.1
- 4.4 Disaster Prevention and Recovery
- 4.4.1 Database Backups
- 4.4.2
BACKUP TABLESyntax - 4.4.3
RESTORE TABLESyntax - 4.4.4
CHECK TABLESyntax - 4.4.5
REPAIR TABLESyntax - 4.4.6 Using
myisamchkfor Table Maintenance and Crash Recovery- 4.4.6.1
myisamchkInvocation Syntax - 4.4.6.2 General Options for
myisamchk - 4.4.6.3 Check Options for
myisamchk - 4.4.6.4 Repair Options for myisamchk
- 4.4.6.5 Other Options for
myisamchk - 4.4.6.6
myisamchkMemory Usage - 4.4.6.7 Using
myisamchkfor Crash Recovery - 4.4.6.8 How to Check Tables for Errors
- 4.4.6.9 How to Repair Tables
- 4.4.6.10 Table Optimisation
- 4.4.6.1
- 4.4.7 Setting Up a Table Maintenance Regimen
- 4.4.8 Getting Information About a Table
- 4.5 Database Administration Language Reference
- 4.5.1
OPTIMIZE TABLESyntax - 4.5.2
ANALYZE TABLESyntax - 4.5.3
FLUSHSyntax - 4.5.4
RESETSyntax - 4.5.5
PURGE MASTER LOGSSyntax - 4.5.6
KILLSyntax - 4.5.7
SHOWSyntax- 4.5.7.1 Retrieving information about Database, Tables, Columns, and Indexes
- 4.5.7.2
SHOW TABLE STATUS - 4.5.7.3
SHOW STATUS - 4.5.7.4
SHOW VARIABLES - 4.5.7.5
SHOW [BDB] LOGS - 4.5.7.6
SHOW PROCESSLIST - 4.5.7.7
SHOW GRANTS - 4.5.7.8
SHOW CREATE TABLE - 4.5.7.9
SHOW WARNINGS | ERRORS - 4.5.7.10
SHOW TABLE TYPES - 4.5.7.11
SHOW PRIVILEGES
- 4.5.1
- 4.6 MySQL Localisation and International Usage
- 4.7 MySQL Server-Side Scripts and Utilities
- 4.8 MySQL Client-Side Scripts and Utilities
- 4.8.1 Overview of the Client-Side Scripts and Utilities
- 4.8.2
mysql, The Command-line Tool - 4.8.3
mysqladmin, Administrating a MySQL Server - 4.8.4
mysqlbinlog, Executing the queries from a binary log - 4.8.5 Using
mysqlcheckfor Table Maintenance and Crash Recovery - 4.8.6
mysqldump, Dumping Table Structure and Data - 4.8.7
mysqlhotcopy, Copying MySQL Databases and Tables - 4.8.8
mysqlimport, Importing Data from Text Files - 4.8.9
mysqlshow, Showing Databases, Tables, and Columns - 4.8.10
mysql_config, Get compile options for compiling clients - 4.8.11
perror, Explaining Error Codes - 4.8.12 How to Run SQL Commands from a Text File
- 4.9 The MySQL Log Files
- 4.10 Replication in MySQL
- 4.10.1 Introduction
- 4.10.2 Replication Implementation Overview
- 4.10.3 Replication Implementation Details
- 4.10.4 How To Set Up Replication
- 4.10.5 Replication Features and Known Problems
- 4.10.6 Replication Options in `my.cnf'
- 4.10.7 SQL Commands Related to Replication
- 4.10.7.1
START SLAVE(slave) - 4.10.7.2
STOP SLAVE(slave) - 4.10.7.3
SET SQL_LOG_BIN=0|1(master) - 4.10.7.4
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=n(slave) - 4.10.7.5
RESET MASTER(master) - 4.10.7.6
RESET SLAVE(slave) - 4.10.7.7
LOAD TABLE tblname FROM MASTER(slave) - 4.10.7.8
LOAD DATA FROM MASTER(slave) - 4.10.7.9
CHANGE MASTER TO master_def_list(slave) - 4.10.7.10
MASTER_POS_WAIT()(slave) - 4.10.7.11
SHOW MASTER STATUS(master) - 4.10.7.12
SHOW SLAVE HOSTS(master) - 4.10.7.13
SHOW SLAVE STATUS(slave) - 4.10.7.14
SHOW MASTER LOGS(master) - 4.10.7.15
SHOW BINLOG EVENTS(master) - 4.10.7.16
PURGE MASTER LOGS(master)
- 4.10.7.1
- 4.10.8 Replication FAQ
- 4.10.9 Troubleshooting Replication
- 5. MySQL Optimisation
- 5.1 Optimisation Overview
- 5.2 Optimising
SELECTs and Other Queries- 5.2.1
EXPLAINSyntax (Get Information About aSELECT) - 5.2.2 Estimating Query Performance
- 5.2.3 Speed of
SELECTQueries - 5.2.4 How MySQL Optimises
WHEREClauses - 5.2.5 How MySQL Optimises
IS NULL - 5.2.6 How MySQL Optimises
DISTINCT - 5.2.7 How MySQL Optimises
LEFT JOINandRIGHT JOIN - 5.2.8 How MySQL Optimises
ORDER BY - 5.2.9 How MySQL Optimises
LIMIT - 5.2.10 Speed of
INSERTQueries - 5.2.11 Speed of
UPDATEQueries - 5.2.12 Speed of
DELETEQueries - 5.2.13 Other Optimisation Tips
- 5.2.1
- 5.3 Locking Issues
- 5.4 Optimising Database Structure
- 5.5 Optimising the MySQL Server
- 5.6 Disk Issues
- 6. MySQL Language Reference
- 6.1 Language Structure
- 6.2 Column Types
- 6.3 Functions for Use in
SELECTandWHEREClauses - 6.4 Data Manipulation:
SELECT,INSERT,UPDATE,DELETE - 6.5 Data Definition:
CREATE,DROP,ALTER - 6.6 Basic MySQL User Utility Commands
- 6.7 MySQL Transactional and Locking Commands
- 6.8 MySQL Full-text Search
- 6.9 MySQL Query Cache
- 7. MySQL Table Types
- 7.1
MyISAMTables - 7.2
MERGETables - 7.3
ISAMTables - 7.4
HEAPTables - 7.5
InnoDBTables- 7.5.1 InnoDB Tables Overview
- 7.5.2 InnoDB in MySQL Version 3.23
- 7.5.3 InnoDB Startup Options
- 7.5.4 Creating InnoDB Tablespace
- 7.5.5 Creating InnoDB Tables
- 7.5.6 Adding and Removing InnoDB Data and Log Files
- 7.5.7 Backing up and Recovering an InnoDB Database
- 7.5.8 Moving an InnoDB Database to Another Machine
- 7.5.9 InnoDB Transaction Model and Locking
- 7.5.9.1 InnoDB and
SET ... TRANSACTION ISOLATION LEVEL ... - 7.5.9.2 Consistent Non-Locking Read
- 7.5.9.3 Locking Reads
SELECT ... FOR UPDATEandSELECT ... LOCK IN SHARE MODE - 7.5.9.4 Next-key Locking: Avoiding the Phantom Problem
- 7.5.9.5 Locks Set by Different SQL Statements in
InnoDB - 7.5.9.6 Deadlock Detection and Rollback
- 7.5.9.7 An Example of How the Consistent Read Works in
InnoDB - 7.5.9.8 How to cope with deadlocks?
- 7.5.9.1 InnoDB and
- 7.5.10 Performance Tuning Tips
- 7.5.11 Implementation of Multi-versioning
- 7.5.12 Table and Index Structures
- 7.5.13 File Space Management and Disk I/O
- 7.5.14 Error Handling
- 7.5.15 Restrictions on InnoDB Tables
- 7.5.16 InnoDB Change History
- 7.5.16.1 MySQL/InnoDB-4.0.14, July 22, 2003
- 7.5.16.2 MySQL/InnoDB-3.23.57, June 20, 2003
- 7.5.16.3 MySQL/InnoDB-4.0.13, May 20, 2003
- 7.5.16.4 MySQL/InnoDB-4.1.0, April 3, 2003
- 7.5.16.5 MySQL/InnoDB-3.23.56, March 17, 2003
- 7.5.16.6 MySQL/InnoDB-4.0.12, March 18, 2003
- 7.5.16.7 MySQL/InnoDB-4.0.11, February 25, 2003
- 7.5.16.8 MySQL/InnoDB-4.0.10, February 4, 2003
- 7.5.16.9 MySQL/InnoDB-3.23.55, January 24, 2003
- 7.5.16.10 MySQL/InnoDB-4.0.9, January 14, 2003
- 7.5.16.11 MySQL/InnoDB-4.0.8, January 7, 2003
- 7.5.16.12 MySQL/InnoDB-4.0.7, December 26, 2002
- 7.5.16.13 MySQL/InnoDB-4.0.6, December 19, 2002
- 7.5.16.14 MySQL/InnoDB-3.23.54, December 12, 2002
- 7.5.16.15 MySQL/InnoDB-4.0.5, November 18, 2002
- 7.5.16.16 MySQL/InnoDB-3.23.53, October 9, 2002
- 7.5.16.17 MySQL/InnoDB-4.0.4, October 2, 2002
- 7.5.16.18 MySQL/InnoDB-4.0.3, August 28, 2002
- 7.5.16.19 MySQL/InnoDB-3.23.52, August 16, 2002
- 7.5.16.20 MySQL/InnoDB-4.0.2, July 10, 2002
- 7.5.16.21 MySQL/InnoDB-3.23.51, June 12, 2002
- 7.5.16.22 MySQL/InnoDB-3.23.50, April 23, 2002
- 7.5.16.23 MySQL/InnoDB-3.23.49, February 17, 2002
- 7.5.16.24 MySQL/InnoDB-3.23.48, February 9, 2002
- 7.5.16.25 MySQL/InnoDB-3.23.47, December 28, 2001
- 7.5.16.26 MySQL/InnoDB-4.0.1, December 23, 2001
- 7.5.16.27 MySQL/InnoDB-3.23.46, November 30, 2001
- 7.5.16.28 MySQL/InnoDB-3.23.45, November 23, 2001
- 7.5.16.29 MySQL/InnoDB-3.23.44, November 2, 2001
- 7.5.16.30 MySQL/InnoDB-3.23.43, October 4, 2001
- 7.5.16.31 MySQL/InnoDB-3.23.42, September 9, 2001
- 7.5.16.32 MySQL/InnoDB-3.23.41, August 13, 2001
- 7.5.16.33 MySQL/InnoDB-3.23.40, July 16, 2001
- 7.5.16.34 MySQL/InnoDB-3.23.39, June 13, 2001
- 7.5.16.35 MySQL/InnoDB-3.23.38, May 12, 2001
- 7.5.17
InnoDBContact Information
- 7.6
BDBorBerkeleyDBTables
- 7.1
- 8. National Character Sets and Unicode in MySQL 4.1
- 8.1 Character Sets and Collations in General
- 8.2 Character Sets and Collations in MySQL
- 8.3 Determining The Default Character Set And Collation
- 8.3.1 Server Character Set and Collation
- 8.3.2 Database Character Set and Collation
- 8.3.3 Table Character Set and Collation
- 8.3.4 Column Character Set and Collation
- 8.3.5 Examples of Character Set and Collation Assignment
- 8.3.6 Connection Character Sets and Collations
- 8.3.7 Character String Literal Character Set and Collation
- 8.3.8
COLLATEClause in Various Parts of an SQL Query - 8.3.9
COLLATEClause Precedence - 8.3.10
BINARYOperator - 8.3.11 Some Special Cases Where the Collation Determination is Tricky
- 8.3.12 Collations Must Be for the Right Character Set
- 8.3.13 An example of the Effect of Collation
- 8.4 Operations Affected by Character Set Support
- 8.5 Unicode Support
- 8.6 UTF8 for Metadata
- 8.7 Compatibility with Other DBMSs
- 8.8 New Character Set Configuration File format
- 8.9 National Character Set
- 8.10 Upgrading from MySQL 4.0
- 8.11 The Character Sets and Collations that MySQL Supports
- 8.11.1 The Unicode Character Sets
- 8.11.2 Platform Specific Character Sets
- 8.11.3 Character Sets for South Europe and Middle East
- 8.11.4 The Asian Character Sets
- 8.11.5 The Baltic Character Sets
- 8.11.6 The Cyrillic Character Sets
- 8.11.7 The Central European Character Sets
- 8.11.8 The West European Character Sets
- 9. MySQL APIs
- 9.1 MySQL C API
- 9.1.1 C API Datatypes
- 9.1.2 C API Function Overview
- 9.1.3 C API Function Descriptions
- 9.1.3.1
mysql_affected_rows() - 9.1.3.2
mysql_change_user() - 9.1.3.3
mysql_character_set_name() - 9.1.3.4
mysql_close() - 9.1.3.5
mysql_connect() - 9.1.3.6
mysql_create_db() - 9.1.3.7
mysql_data_seek() - 9.1.3.8
mysql_debug() - 9.1.3.9
mysql_drop_db() - 9.1.3.10
mysql_dump_debug_info() - 9.1.3.11
mysql_eof() - 9.1.3.12
mysql_errno() - 9.1.3.13
mysql_error() - 9.1.3.14
mysql_escape_string() - 9.1.3.15
mysql_fetch_field() - 9.1.3.16
mysql_fetch_fields() - 9.1.3.17
mysql_fetch_field_direct() - 9.1.3.18
mysql_fetch_lengths() - 9.1.3.19
mysql_fetch_row() - 9.1.3.20
mysql_field_count() - 9.1.3.21
mysql_field_seek() - 9.1.3.22
mysql_field_tell() - 9.1.3.23
mysql_free_result() - 9.1.3.24
mysql_get_client_info() - 9.1.3.25
mysql_get_server_version() - 9.1.3.26
mysql_get_host_info() - 9.1.3.27
mysql_get_proto_info() - 9.1.3.28
mysql_get_server_info() - 9.1.3.29
mysql_info() - 9.1.3.30
mysql_init() - 9.1.3.31
mysql_insert_id() - 9.1.3.32
mysql_kill() - 9.1.3.33
mysql_list_dbs() - 9.1.3.34
mysql_list_fields() - 9.1.3.35
mysql_list_processes() - 9.1.3.36
mysql_list_tables() - 9.1.3.37
mysql_num_fields() - 9.1.3.38
mysql_num_rows() - 9.1.3.39
mysql_options() - 9.1.3.40
mysql_ping() - 9.1.3.41
mysql_query() - 9.1.3.42
mysql_real_connect() - 9.1.3.43
mysql_real_escape_string() - 9.1.3.44
mysql_real_query() - 9.1.3.45
mysql_reload() - 9.1.3.46
mysql_row_seek() - 9.1.3.47
mysql_row_tell() - 9.1.3.48
mysql_select_db() - 9.1.3.49
mysql_sqlstate() - 9.1.3.50
mysql_shutdown() - 9.1.3.51
mysql_stat() - 9.1.3.52
mysql_store_result() - 9.1.3.53
mysql_thread_id() - 9.1.3.54
mysql_use_result() - 9.1.3.55
mysql_commit() - 9.1.3.56
mysql_rollback() - 9.1.3.57
mysql_autocommit() - 9.1.3.58
mysql_more_results() - 9.1.3.59
mysql_next_result()
- 9.1.3.1
- 9.1.4 C API Prepared Statements
- 9.1.5 C API Prepared Statement Datatypes
- 9.1.6 C API Prepared Statement Function Overview
- 9.1.7 C API Prepared Statement Function Descriptions
- 9.1.7.1
mysql_prepare() - 9.1.7.2
mysql_param_count() - 9.1.7.3
mysql_prepare_result() - 9.1.7.4
mysql_bind_param() - 9.1.7.5
mysql_execute() - 9.1.7.6
mysql_stmt_affected_rows() - 9.1.7.7
mysql_bind_result() - 9.1.7.8
mysql_stmt_store_result() - 9.1.7.9
mysql_stmt_data_seek() - 9.1.7.10
mysql_stmt_row_seek() - 9.1.7.11
mysql_stmt_row_tell() - 9.1.7.12
mysql_stmt_num_rows() - 9.1.7.13
mysql_fetch() - 9.1.7.14
mysql_send_long_data() - 9.1.7.15
mysql_stmt_close() - 9.1.7.16
mysql_stmt_errno() - 9.1.7.17
mysql_stmt_error() - 9.1.7.18
mysql_stmt_sqlstate()
- 9.1.7.1
- 9.1.8 C API Handling of Multiple Query Execution
- 9.1.9 C API Handling of Date and Time Values
- 9.1.10 C API Threaded Function Descriptions
- 9.1.11 C API Embedded Server Function Descriptions
- 9.1.12 Common questions and problems when using the C API
- 9.1.13 Building Client Programs
- 9.1.14 How to Make a Threaded Client
- 9.1.15 libmysqld, the Embedded MySQL Server Library
- 9.1.15.1 Overview of the Embedded MySQL Server Library
- 9.1.15.2 Compiling Programs with
libmysqld - 9.1.15.3 Restrictions when using the Embedded MySQL Server
- 9.1.15.4 Using Option Files with the Embedded Server
- 9.1.15.5 Things left to do in Embedded Server (TODO)
- 9.1.15.6 A Simple Embedded Server Example
- 9.1.15.7 Licensing the Embedded Server
- 9.2 MySQL ODBC Support
- 9.2.1 How To Install MyODBC
- 9.2.2 How to Fill in the Various Fields in the ODBC Administrator Program
- 9.2.3 Connect parameters for MyODBC
- 9.2.4 How to Report Problems with MyODBC
- 9.2.5 Programs Known to Work with MyODBC
- 9.2.6 How to Get the Value of an
AUTO_INCREMENTColumn in ODBC - 9.2.7 Reporting Problems with MyODBC
- 9.3 MySQL Java Connectivity (JDBC)
- 9.4 MySQL PHP API
- 9.5 MySQL Perl API
- 9.6 MySQL C++ API
- 9.7 MySQL Python API
- 9.8 MySQL Tcl API
- 9.9 MySQL Eiffel Wrapper
- 9.1 MySQL C API
- 10. Error Handling in MySQL
- 11. Spatial Extensions in MySQL
- 11.1 Introduction
- 11.2 The OpenGIS Geometry Model
- 11.2.1 The Geometry Class Hierarchy
- 11.2.2 Class
Geometry - 11.2.3 Class
Point - 11.2.4 Class
Curve - 11.2.5 Class
LineString - 11.2.6 Class
Surface - 11.2.7 Class
Polygon - 11.2.8 Class
GeometryCollection - 11.2.9 Class
MultiPoint - 11.2.10 Class
MultiCurve - 11.2.11 Class
MultiLineString - 11.2.12 Class
MultiSurface - 11.2.13 Class
MultiPolygon
- 11.3 Supported Spatial Data Formats
- 11.4 Creating a Spatially Enabled MySQL Database
- 11.5 Analysing Spatial Information
- 11.5.1 Functions To Convert Geometries Between Formats
- 11.5.2
GeometryProperty Analysis Functions- 11.5.2.1 General Geometry Property Analysis Functions
- 11.5.2.2
PointProperty Analysis Functions - 11.5.2.3
LineStringProperty Analysis Functions - 11.5.2.4
MultiLineStringProperty Analysis Functions - 11.5.2.5
PolygonProperty Analysis Functions - 11.5.2.6
MultiPolygonProperty Analysis Functions - 11.5.2.7
GeometryCollectionProperty Analysis Functions
- 11.5.3 Functions That Create New Geometries From Existing Ones
- 11.5.4 Functions For Testing Spatial Relations Between Geometric Objects
- 11.5.5 Relations On Geometry Minimal Bounding Rectangles (MBRs)
- 11.5.6 Functions That Test Spatial Relationships Between Geometries
- 11.6 Optimising Spatial Analysis
- 11.7 MySQL Conformance And Compatibility
- 12. Extending MySQL
- A. Problems and Common Errors
- A.1 How to Determine What Is Causing Problems
- A.2 Common Errors When Using MySQL
- A.2.1
Access deniedError - A.2.2
MySQL server has gone awayError - A.2.3
Can't connect to [local] MySQL serverError - A.2.4
Client does not support authentication protocolerror - A.2.5
Host '...' is blockedError - A.2.6
Too many connectionsError - A.2.7
Some non-transactional changed tables couldn't be rolled backError - A.2.8
Out of memoryError - A.2.9
Packet too largeError - A.2.10 Communication Errors / Aborted Connection
- A.2.11
The table is fullError - A.2.12
Can't create/write to fileError - A.2.13
Commands out of syncError in Client - A.2.14
Ignoring userError - A.2.15
Table 'xxx' doesn't existError - A.2.16
Can't initialize character set xxxerror - A.2.17 File Not Found
- A.2.1
- A.3 Installation Related Issues
- A.4 Administration Related Issues
- A.5 Query Related Issues
- A.6 Optimiser Related Issues
- A.7 Table Definition Related Issues
- B. Contributed Programs
- C. Credits
- D. MySQL Change History
- D.1 Changes in release 5.0.0 (Development)
- D.2 Changes in release 4.1.x (Alpha)
- D.3 Changes in release 4.0.x (Production)
- D.3.1 Changes in release 4.0.16 (not released yet)
- D.3.2 Changes in release 4.0.15 (03 Sep 2003)
- D.3.3 Changes in release 4.0.14 (18 Jul 2003)
- D.3.4 Changes in release 4.0.13 (16 May 2003)
- D.3.5 Changes in release 4.0.12 (15 Mar 2003: Production)
- D.3.6 Changes in release 4.0.11 (20 Feb 2003)
- D.3.7 Changes in release 4.0.10 (29 Jan 2003)
- D.3.8 Changes in release 4.0.9 (09 Jan 2003)
- D.3.9 Changes in release 4.0.8 (07 Jan 2003)
- D.3.10 Changes in release 4.0.7 (20 Dec 2002)
- D.3.11 Changes in release 4.0.6 (14 Dec 2002: Gamma)
- D.3.12 Changes in release 4.0.5 (13 Nov 2002)
- D.3.13 Changes in release 4.0.4 (29 Sep 2002)
- D.3.14 Changes in release 4.0.3 (26 Aug 2002: Beta)
- D.3.15 Changes in release 4.0.2 (01 Jul 2002)
- D.3.16 Changes in release 4.0.1 (23 Dec 2001)
- D.3.17 Changes in release 4.0.0 (Oct 2001: Alpha)
- D.4 Changes in release 3.23.x (Recent; still supported)
- D.4.1 Changes in release 3.23.59 (not released yet)
- D.4.2 Changes in release 3.23.58 (to be released soon)
- D.4.3 Changes in release 3.23.57 (06 Jun 2003)
- D.4.4 Changes in release 3.23.56 (13 Mar 2003)
- D.4.5 Changes in release 3.23.55 (23 Jan 2003)
- D.4.6 Changes in release 3.23.54 (05 Dec 2002)
- D.4.7 Changes in release 3.23.53 (09 Oct 2002)
- D.4.8 Changes in release 3.23.52 (14 Aug 2002)
- D.4.9 Changes in release 3.23.51 (31 May 2002)
- D.4.10 Changes in release 3.23.50 (21 Apr 2002)
- D.4.11 Changes in release 3.23.49
- D.4.12 Changes in release 3.23.48 (07 Feb 2002)
- D.4.13 Changes in release 3.23.47 (27 Dec 2001)
- D.4.14 Changes in release 3.23.46 (29 Nov 2001)
- D.4.15 Changes in release 3.23.45 (22 Nov 2001)
- D.4.16 Changes in release 3.23.44 (31 Oct 2001)
- D.4.17 Changes in release 3.23.43 (04 Oct 2001)
- D.4.18 Changes in release 3.23.42 (08 Sep 2001)
- D.4.19 Changes in release 3.23.41 (11 Aug 2001)
- D.4.20 Changes in release 3.23.40
- D.4.21 Changes in release 3.23.39 (12 Jun 2001)
- D.4.22 Changes in release 3.23.38 (09 May 2001)
- D.4.23 Changes in release 3.23.37 (17 Apr 2001)
- D.4.24 Changes in release 3.23.36 (27 Mar 2001)
- D.4.25 Changes in release 3.23.35 (15 Mar 2001)
- D.4.26 Changes in release 3.23.34a
- D.4.27 Changes in release 3.23.34 (10 Mar 2001)
- D.4.28 Changes in release 3.23.33 (09 Feb 2001)
- D.4.29 Changes in release 3.23.32 (22 Jan 2001: Production)
- D.4.30 Changes in release 3.23.31 (17 Jan 2001)
- D.4.31 Changes in release 3.23.30 (04 Jan 2001)
- D.4.32 Changes in release 3.23.29 (16 Dec 2000)
- D.4.33 Changes in release 3.23.28 (22 Nov 2000: Gamma)
- D.4.34 Changes in release 3.23.27 (24 Oct 2000)
- D.4.35 Changes in release 3.23.26 (18 Oct 2000)
- D.4.36 Changes in release 3.23.25 (29 Sep 2000)
- D.4.37 Changes in release 3.23.24 (08 Sep 2000)
- D.4.38 Changes in release 3.23.23 (01 Sep 2000)
- D.4.39 Changes in release 3.23.22 (31 Jul 2000)
- D.4.40 Changes in release 3.23.21
- D.4.41 Changes in release 3.23.20
- D.4.42 Changes in release 3.23.19
- D.4.43 Changes in release 3.23.18
- D.4.44 Changes in release 3.23.17
- D.4.45 Changes in release 3.23.16
- D.4.46 Changes in release 3.23.15 (May 2000: Beta)
- D.4.47 Changes in release 3.23.14
- D.4.48 Changes in release 3.23.13
- D.4.49 Changes in release 3.23.12 (07 Mar 2000)
- D.4.50 Changes in release 3.23.11
- D.4.51 Changes in release 3.23.10
- D.4.52 Changes in release 3.23.9
- D.4.53 Changes in release 3.23.8 (02 Jan 2000)
- D.4.54 Changes in release 3.23.7 (10 Dec 1999)
- D.4.55 Changes in release 3.23.6
- D.4.56 Changes in release 3.23.5 (20 Oct 1999)
- D.4.57 Changes in release 3.23.4 (28 Sep 1999)
- D.4.58 Changes in release 3.23.3
- D.4.59 Changes in release 3.23.2 (09 Aug 1999)
- D.4.60 Changes in release 3.23.1
- D.4.61 Changes in release 3.23.0 (05 Aug 1999: Alpha)
- D.5 Changes in release 3.22.x (Old; discontinued)
- D.5.1 Changes in release 3.22.35
- D.5.2 Changes in release 3.22.34
- D.5.3 Changes in release 3.22.33
- D.5.4 Changes in release 3.22.32 (14 Feb 2000)
- D.5.5 Changes in release 3.22.31
- D.5.6 Changes in release 3.22.30
- D.5.7 Changes in release 3.22.29 (02 Jan 2000)
- D.5.8 Changes in release 3.22.28 (20 Oct 1999)
- D.5.9 Changes in release 3.22.27
- D.5.10 Changes in release 3.22.26 (16 Sep 1999)
- D.5.11 Changes in release 3.22.25
- D.5.12 Changes in release 3.22.24 (05 Jul 1999)
- D.5.13 Changes in release 3.22.23 (08 Jun 1999)
- D.5.14 Changes in release 3.22.22 (30 Apr 1999)
- D.5.15 Changes in release 3.22.21
- D.5.16 Changes in release 3.22.20 (18 Mar 1999)
- D.5.17 Changes in release 3.22.19 (Mar 1999: Production)
- D.5.18 Changes in release 3.22.18
- D.5.19 Changes in release 3.22.17
- D.5.20 Changes in release 3.22.16 (Feb 1999: Gamma)
- D.5.21 Changes in release 3.22.15
- D.5.22 Changes in release 3.22.14
- D.5.23 Changes in release 3.22.13
- D.5.24 Changes in release 3.22.12
- D.5.25 Changes in release 3.22.11
- D.5.26 Changes in release 3.22.10
- D.5.27 Changes in release 3.22.9
- D.5.28 Changes in release 3.22.8
- D.5.29 Changes in release 3.22.7 (Sep 1998: Beta)
- D.5.30 Changes in release 3.22.6
- D.5.31 Changes in release 3.22.5
- D.5.32 Changes in release 3.22.4
- D.5.33 Changes in release 3.22.3
- D.5.34 Changes in release 3.22.2
- D.5.35 Changes in release 3.22.1 (Jun 1998: Alpha)
- D.5.36 Changes in release 3.22.0
- D.6 Changes in release 3.21.x
- D.6.1 Changes in release 3.21.33
- D.6.2 Changes in release 3.21.32
- D.6.3 Changes in release 3.21.31
- D.6.4 Changes in release 3.21.30
- D.6.5 Changes in release 3.21.29
- D.6.6 Changes in release 3.21.28
- D.6.7 Changes in release 3.21.27
- D.6.8 Changes in release 3.21.26
- D.6.9 Changes in release 3.21.25
- D.6.10 Changes in release 3.21.24
- D.6.11 Changes in release 3.21.23
- D.6.12 Changes in release 3.21.22
- D.6.13 Changes in release 3.21.21a
- D.6.14 Changes in release 3.21.21
- D.6.15 Changes in release 3.21.20
- D.6.16 Changes in release 3.21.19
- D.6.17 Changes in release 3.21.18
- D.6.18 Changes in release 3.21.17
- D.6.19 Changes in release 3.21.16
- D.6.20 Changes in release 3.21.15
- D.6.21 Changes in release 3.21.14b
- D.6.22 Changes in release 3.21.14a
- D.6.23 Changes in release 3.21.13
- D.6.24 Changes in release 3.21.12
- D.6.25 Changes in release 3.21.11
- D.6.26 Changes in release 3.21.10
- D.6.27 Changes in release 3.21.9
- D.6.28 Changes in release 3.21.8
- D.6.29 Changes in release 3.21.7
- D.6.30 Changes in release 3.21.6
- D.6.31 Changes in release 3.21.5
- D.6.32 Changes in release 3.21.4
- D.6.33 Changes in release 3.21.3
- D.6.34 Changes in release 3.21.2
- D.6.35 Changes in release 3.21.0
- D.7 Changes in release 3.20.x
- D.7.1 Changes in release 3.20.18
- D.7.2 Changes in release 3.20.17
- D.7.3 Changes in release 3.20.16
- D.7.4 Changes in release 3.20.15
- D.7.5 Changes in release 3.20.14
- D.7.6 Changes in release 3.20.13
- D.7.7 Changes in release 3.20.11
- D.7.8 Changes in release 3.20.10
- D.7.9 Changes in release 3.20.9
- D.7.10 Changes in release 3.20.8
- D.7.11 Changes in release 3.20.7
- D.7.12 Changes in release 3.20.6
- D.7.13 Changes in release 3.20.3
- D.7.14 Changes in release 3.20.0
- D.8 Changes in release 3.19.x
- E. Porting to Other Systems
- F. Environment Variables
- G. MySQL Regular Expressions
- H. GNU General Public License
- I. GNU Lesser General Public License
- SQL command, type and function index
- Concept Index
| [Top] | [Contents] | [Index] | [ ? ] |
Hosting by: Hurra Communications Ltd.
Generated: 2007-01-26 17:58:44