MySQL Reference Manual for version 3.23.47.

• 1 General Information About MySQL
  • 1.1 MySQL, MySQL AB, and Open Source
    • 1.1.1 What Is MySQL
    • 1.1.2 What Is MySQL AB
    • 1.1.3 About This Manual
    • 1.1.4 Conventions Used in This Manual
    • 1.1.5 History of MySQL
    • 1.1.6 The Main Features of MySQL
    • 1.1.7 How Stable Is MySQL?
    • 1.1.8 How Big Can MySQL Tables Be?
    • 1.1.9 Year 2000 Compliance
  • 1.2 MySQL Information Sources
    • 1.2.1 Books About MySQL
    • 1.2.2 General SQL Information and Tutorials
    • 1.2.3 Useful MySQL-related Links
    • 1.2.22 MySQL Mailing Lists
      • 1.2.22.1 The MySQL Mailing Lists
      • 1.2.22.2 Asking Questions or Reporting Bugs
      • 1.2.22.3 How to Report Bugs or Problems
      • 1.2.22.4 Guidelines for Answering Question on the Mailing List
  • 1.3 MySQL Licensing and Support
    • 1.3.1 MySQL Licensing Policy
    • 1.3.2 Copyrights Used by MySQL
      • 1.3.2.1 Copyright Changes
    • 1.3.3 Example Licensing Situations
      • 1.3.3.1 Selling Products that use MySQL
      • 1.3.3.2 ISP MySQL Services
      • 1.3.3.3 Running a Web Server Using MySQL
    • 1.3.4 MySQL Licensing and Support Costs
      • 1.3.4.1 Payment information
      • 1.3.4.2 Contact Information
    • 1.3.5 Types of Commercial Support
      • 1.3.5.1 Basic E-mail Support
      • 1.3.5.2 Extended E-mail Support
      • 1.3.5.3 Login Support
      • 1.3.5.4 Extended Login Support
      • 1.3.5.5 Telephone Support
      • 1.3.5.6 Support for other table handlers
  • 1.4 How Standards-compatible Is MySQL?
    • 1.4.1 MySQL Extensions to ANSI SQL92
    • 1.4.2 MySQL Differences Compared to ANSI SQL92
    • 1.4.3 Running MySQL in ANSI Mode
    • 1.4.4 Functionality Missing from MySQL
      • 1.4.4.1 Sub-selects
      • 1.4.4.2 SELECT INTO TABLE
      • 1.4.4.3 Transactions
      • 1.4.4.4 Stored Procedures and Triggers
      • 1.4.4.5 Foreign Keys
      • 1.4.4.6 Reasons NOT to Use Foreign Keys constraints
      • 1.4.4.7 Views
      • 1.4.4.8 `--' as the Start of a Comment
    • 1.4.5 What Standards Does MySQL Follow?
    • 1.4.6 How to Cope Without COMMIT/ROLLBACK
    • 1.4.7 Known errors and design deficiencies in MySQL
  • 1.5 How MySQL Compares to Other Databases
    • 1.5.1 How MySQL Compares to mSQL
      • 1.5.1.1 How to Convert mSQL Tools for MySQL
      • 1.5.1.2 How mSQL and MySQL Client/Server Communications Protocols Differ
      • 1.5.1.3 How mSQL 2.0 SQL Syntax Differs from MySQL
    • 1.5.2 How MySQL Compares to PostgreSQL
      • 1.5.2.1 MySQL and PostgreSQL development strategies
      • 1.5.2.2 Featurewise Comparison of MySQL and PostgreSQL
      • 1.5.2.3 Benchmarking MySQL and PostgreSQL
  • 1.6 MySQL and the future (The TODO)
    • 1.6.1 Things that should be in 4.0
    • 1.6.2 Things that must be done in the real near future
    • 1.6.3 Things that have to be done sometime
    • 1.6.4 Some things we don't have any plans to do
• 2 MySQL Installation
  • 2.1 Quick Standard Installation of MySQL
    • 2.1.1 Installing MySQL on Linux
    • 2.1.2 Installing MySQL on Windows
  • 2.2 General Installation Issues
    • 2.2.1 How to Get MySQL
    • 2.2.2 Operating Systems Supported by MySQL
    • 2.2.3 Which MySQL Version to Use
    • 2.2.4 Installation Layouts
    • 2.2.5 How and When Updates Are Released
    • 2.2.6 MySQL Binaries Compiled by MySQL AB
  • 2.3 Installing a MySQL Source Distribution
    • 2.3.1 Quick Installation Overview
    • 2.3.2 Applying Patches
    • 2.3.3 Typical configure Options
    • 2.3.4 Installing from the Development Source Tree
    • 2.3.5 Problems Compiling?
    • 2.3.6 MIT-pthreads Notes
  • 2.4 Post-installation Setup and Testing
    • 2.4.1 Problems Running mysql_install_db
    • 2.4.2 Problems Starting the MySQL Server
    • 2.4.3 Starting and Stopping MySQL Automatically
  • 2.5 Upgrading/Downgrading MySQL
    • 2.5.1 Upgrading From Version 3.22 to Version 3.23
    • 2.5.2 Upgrading from Version 3.21 to Version 3.22
    • 2.5.3 Upgrading from Version 3.20 to Version 3.21
    • 2.5.4 Upgrading to Another Architecture
  • 2.6 Operating System Specific Notes
    • 2.6.1 Linux Notes (All Linux Versions)
      • 2.6.1.1 Linux Notes for Binary Distributions
      • 2.6.1.2 Linux x86 Notes
      • 2.6.1.3 Linux SPARC Notes
      • 2.6.1.4 Linux Alpha Notes
      • 2.6.1.5 Linux PowerPC Notes
      • 2.6.1.6 Linux MIPS Notes
      • 2.6.1.7 Linux IA64 Notes
    • 2.6.2 Windows Notes
      • 2.6.2.1 Starting MySQL on Windows 95 or Windows 98
      • 2.6.2.2 Starting MySQL on Windows NT or Windows 2000
      • 2.6.2.3 Running MySQL on Windows
      • F.4.16 Changes in release 3.21.19
      • F.4.17 Changes in release 3.21.18
      • F.4.18 Changes in release 3.21.17
      • F.4.19 Changes in release 3.21.16
      • F.4.20 Changes in release 3.21.15
      • F.4.21 Changes in release 3.21.14b
      • F.4.22 Changes in release 3.21.14a
      • F.4.23 Changes in release 3.21.13
      • F.4.24 Changes in release 3.21.12
      • F.4.25 Changes in release 3.21.11
      • F.4.26 Changes in release 3.21.10
      • F.4.27 Changes in release 3.21.9
      • F.4.28 Changes in release 3.21.8
      • F.4.29 Changes in release 3.21.7
      • F.4.30 Changes in release 3.21.6
      • F.4.31 Changes in release 3.21.5
      • F.4.32 Changes in release 3.21.4
      • F.4.33 Changes in release 3.21.3
      • F.4.34 Changes in release 3.21.2
      • F.4.35 Changes in release 3.21.0
    • F.5 Changes in release 3.20.x
      • F.5.1 Changes in release 3.20.18
      • F.5.2 Changes in release 3.20.17
      • F.5.3 Changes in release 3.20.16
      • F.5.4 Changes in release 3.20.15
      • F.5.5 Changes in release 3.20.14
      • F.5.6 Changes in release 3.20.13
      • F.5.7 Changes in release 3.20.11
      • F.5.8 Changes in release 3.20.10
      • F.5.9 Changes in release 3.20.9
      • F.5.10 Changes in release 3.20.8
      • F.5.11 Changes in release 3.20.7
      • F.5.12 Changes in release 3.20.6
      • F.5.13 Changes in release 3.20.3
      • F.5.14 Changes in release 3.20.0
    • F.6 Changes in release 3.19.x
      • F.6.1 Changes in release 3.19.5
      • F.6.2 Changes in release 3.19.4
      • F.6.3 Changes in release 3.19.3
  • G Comments on porting to other systems
    • G.1 Debugging a MySQL server
      • G.1.1 Compiling MYSQL for debugging.
      • G.1.2 Creating trace files
      • G.1.3 Debugging mysqld under gdb
      • G.1.4 Using a stack trace
      • G.1.5 Using log files to find cause of errors in mysqld
      • G.1.6 Making a test case when you experience table corruption
    • G.2 Debugging a MySQL client
    • G.3 The DBUG package.
    • G.4 Locking methods
    • G.5 Comments about RTS threads
    • G.6 Differences between different thread packages
  • H Environment Variables
  • I Description of MySQL regular expression syntax
  • J What is Unireg?
  • K GNU GENERAL PUBLIC LICENSE
    • K.1 Preamble
    • K.2 TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
    • K.3 How to Apply These Terms to Your New Programs
  • L GNU LESSER GENERAL PUBLIC LICENSE
    • L.1 Preamble
    • L.2 TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
    • L.3 How to Apply These Terms to Your New Libraries
  • M Pieces of the manual in transit
    • M.1 Installing a MySQL Binary Distribution
    • M.2 Perl Installation Comments
      • M.2.1 Installing Perl on Unix
      • M.2.2 Installing ActiveState Perl on Windows
      • M.2.3 Installing the MySQL Perl Distribution on Windows
      • M.2.4 Problems Using the Perl DBI/DBD Interface
    • M.3 Functions for Use with GROUP BY Clauses
  • SQL command, type and function index
  • Concept Index

  ---

  This document was generated on 27 December 2001 using the texi2html translator version 1.52 (extended by davida@detron.se).