Below is the list of changes that have just been committed into a local
mysqldoc repository of root. When root does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.2735 05/06/08 15:44:34 Mike.Hillyer@stripped +19 -0
Added base XML files for user guide. One file per chapter with a main userguide.xml file that brings it all together. The userguide is also divided into three parts: Administration, Usage, and APIs.
userguide/views.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +39 -0
userguide/userguide.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +56 -0
userguide/userguide.html
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +703 -0
userguide/userguide-prepped.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +613 -0
userguide/stored-procedures.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +39 -0
userguide/storage-engines.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +39 -0
userguide/security.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +39 -0
userguide/querying.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +129 -0
userguide/populating.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +29 -0
userguide/php-mysqli.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +9 -0
userguide/modifying.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +39 -0
userguide/java.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +9 -0
userguide/introduction.xml
1.1 05/06/08 15:44:33 Mike.Hillyer@stripped +49 -0
userguide/views.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/views.xml
userguide/userguide.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/userguide.xml
userguide/userguide.html
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/userguide.html
userguide/userguide-prepped.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/userguide-prepped.xml
userguide/stored-procedures.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/stored-procedures.xml
userguide/storage-engines.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/storage-engines.xml
userguide/security.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/security.xml
userguide/querying.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/querying.xml
userguide/populating.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/populating.xml
userguide/php-mysqli.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/php-mysqli.xml
userguide/modifying.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/modifying.xml
userguide/java.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/java.xml
userguide/introduction.xml
1.0 05/06/08 15:44:33 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/introduction.xml
userguide/installing.xml
1.1 05/06/08 15:44:32 Mike.Hillyer@stripped +129 -0
userguide/indexing.xml
1.1 05/06/08 15:44:32 Mike.Hillyer@stripped +69 -0
userguide/dotnet.xml
1.1 05/06/08 15:44:32 Mike.Hillyer@stripped +9 -0
userguide/creating.xml
1.1 05/06/08 15:44:32 Mike.Hillyer@stripped +69 -0
userguide/configuring.xml
1.1 05/06/08 15:44:32 Mike.Hillyer@stripped +9 -0
userguide/Makefile
1.1 05/06/08 15:44:32 Mike.Hillyer@stripped +45 -0
userguide/installing.xml
1.0 05/06/08 15:44:32 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/installing.xml
userguide/indexing.xml
1.0 05/06/08 15:44:32 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/indexing.xml
userguide/dotnet.xml
1.0 05/06/08 15:44:32 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/dotnet.xml
userguide/creating.xml
1.0 05/06/08 15:44:32 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/creating.xml
userguide/configuring.xml
1.0 05/06/08 15:44:32 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/configuring.xml
userguide/Makefile
1.0 05/06/08 15:44:32 Mike.Hillyer@stripped +0 -0
BitKeeper file /home/mysqldoc/mysqldoc/userguide/Makefile
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: Mike.Hillyer
# Host: www.openwin.org
# Root: /home/mysqldoc/mysqldoc
--- New file ---
+++ userguide/Makefile 05/06/08 15:44:32
# Makefile for MySQL Query Browser manual
# Formats we need for docsrva
# chm
# html-chapter
# html-section
# html-web
# pdf-a4
# pdf
# xhtml
# Location of repository root relative to current directory
REPO_ROOT = ..
# Location of directory containing Makefile components
MAKE_DIR = $(REPO_ROOT)/make.d
all::
@echo "You must say what you want to do."
@echo "Some commands supported by this Makefile:"
@echo " make clean"
@echo " make doc_name.html"
@echo " make doc_name.pdf"
@echo " make doc_name.txt"
# Import standard variables and target rules
include $(MAKE_DIR)/vars-layout
include $(MAKE_DIR)/vars-shell
include $(MAKE_DIR)/vars-docbook
include $(MAKE_DIR)/xml-valid
include $(MAKE_DIR)/xml-format
include $(MAKE_DIR)/xml-useless
include $(MAKE_DIR)/xml-prep
include $(MAKE_DIR)/xml-html
include $(MAKE_DIR)/xml-html-section
include $(MAKE_DIR)/xml-html-chapter
include $(MAKE_DIR)/xml-html-web
include $(MAKE_DIR)/xml-html-help
#include $(MAKE_DIR)/xml-xhtml
include $(MAKE_DIR)/xml-pdf
include $(MAKE_DIR)/xml-txt
#include $(MAKE_DIR)/xml-texi
#include $(MAKE_DIR)/texi-info
include $(MAKE_DIR)/xml-toc
--- New file ---
+++ userguide/configuring.xml 05/06/08 15:44:32
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="configuring">
<title>Configuring MySQL</title>
</chapter>
<!-- END CONFIGURING CHAPTER -->
--- New file ---
+++ userguide/creating.xml 05/06/08 15:44:32
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="creating">
<title>Creating Schema and Tables</title>
<section id="creating-planning">
<title>Planning a Schema Design</title>
<para></para>
</section>
<!-- END PLANNING -->
<section id="creating-normalization">
<title>Database Normalization</title>
<para></para>
</section>
<!-- END NORMALIZATION -->
<section id="creating-column-types">
<title>Choosing Column Types</title>
<para></para>
</section>
<!-- END CHOOSING -->
<section id="creating-schema">
<title>Creating Schema</title>
<para></para>
</section>
<!-- END CREATING SCHEMA -->
<section id="creating-tables">
<title>Creating Tables</title>
<para></para>
</section>
<!-- END CREATING TABLES -->
<section id="creating-altering">
<title>Altering Schema and Tables</title>
<para></para>
</section>
<!-- END ALTERING -->
</chapter>
<!-- END CREATING CHAPTER -->
--- New file ---
+++ userguide/dotnet.xml 05/06/08 15:44:32
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="dotnet">
<title>Using the Connector/NET API with MySQL</title>
</chapter>
<!-- END DOTNET CHAPTER -->
--- New file ---
+++ userguide/indexing.xml 05/06/08 15:44:32
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="indexing">
<title>Indexing Data</title>
<section id="indexing-why">
<title>Why Use Indexes?</title>
<para></para>
</section>
<!-- END WHY -->
<section id="indexing-types">
<title>Types of Indexes</title>
<para></para>
</section>
<!-- END TYPES -->
<section id="indexing-displaying">
<title>Displaying Table Indexes</title>
<para></para>
</section>
<!-- END DISPLAYING -->
<section id="indexing-creating">
<title>Creating Indexes</title>
<para></para>
</section>
<!-- END CREATING -->
<section id="indexing-dropping">
<title>Dropping Indexes</title>
<para></para>
</section>
<!-- END DROPPING -->
<section id="indexing-optimizing">
<title>Using EXPLAIN to Improve Indexing</title>
<para></para>
</section>
<!-- END EXPLAIN -->
</chapter>
<!-- END INDEXING CHAPTER -->
--- New file ---
+++ userguide/installing.xml 05/06/08 15:44:32
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="installing">
<title>Installing MySQL</title>
<section id="installing-introduction">
<title>Introduction</title>
<para></para>
</section>
<!-- END INTRODUCTION -->
<section id="installing-downloading">
<title>Downloading MySQL</title>
<para></para>
</section>
<!-- END DOWNLOADING -->
<section id="installing-installation">
<title>Installation</title>
<para></para>
<section id="installing-installation-windows">
<title>Installing MySQL on Windows</title>
<para></para>
</section>
<!-- END WINDOWS -->
<section id="installing-installation-linux">
<title>Installing MySQL on Linux</title>
<para></para>
</section>
<!-- END LINUX -->
<section id="installing-installation-mac">
<title>Installing MySQL on Mac</title>
<para></para>
</section>
<!-- END MAC -->
</section>
<!-- END INSTALLING -->
<section id="installing-upgrading">
<title>Upgrading MySQL</title>
<para></para>
</section>
<!-- END UPGRADING MYSQL -->
<section id="installing-gui">
<title>Installing the MySQL GUI Tools</title>
<para></para>
<section id="installing-gui-introduction">
<title>Introduction</title>
<para></para>
</section>
<!-- END INTRODUCTION -->
<section id="installing-gui-downloading">
<title>Downloading the MySQL GUI Tools</title>
<para></para>
</section>
<!-- END DOWNLOADING -->
<section id="installing-gui-installing">
<title>Installing the MySQL GUI Tools</title>
<para></para>
</section>
<!-- END INSTALLING -->
<section id="installing-gui-starting">
<title>Starting the MySQL GUI Tools</title>
<para></para>
</section>
<!-- END STARTING -->
</section>
<!-- END GUI -->
</chapter>
<!-- END INSTALLING CHAPTER -->
--- New file ---
+++ userguide/introduction.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="introduction">
<title>Introduction</title>
<section id="introduction-what-is-rdb">
<title>What is a Relational Database?</title>
<para></para>
</section>
<!-- END WHAT IS RDB -->
<section id="introduction-what-is-rdbms">
<title>What is a Relational Database Management System?</title>
<para></para>
</section>
<!-- END WHAT IS RDBMS -->
<section id="introduction-what-is-mysql">
<title>What is MySQL?</title>
<para></para>
</section>
<!-- END WHAT IS MYSQL -->
<section id="introduction-why-use-mysql">
<title>Why Use MySQL?</title>
<para></para>
</section>
<!-- END WHY USE MYSQL -->
</chapter>
<!-- END INTRODUCTION CHAPTER -->
--- New file ---
+++ userguide/java.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="java">
<title>Using the Connector/J API with MySQL</title>
</chapter>
<!-- END JAVA CHAPTER -->
--- New file ---
+++ userguide/modifying.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="modifying">
<title>Modifying Data</title>
<section id="modifying-insert">
<title>Adding Data with the INSERT Statement</title>
<para></para>
</section>
<!-- END INSERT -->
<section id="modifying-update">
<title>Changing Data with the UPDATE Statement</title>
<para></para>
</section>
<!-- END UPDATE -->
<section id="modifying-delete">
<title>Removing Data with the DELETE Statement</title>
<para></para>
</section>
<!-- END DELETE -->
</chapter>
<!-- END MODIFYING CHAPTER -->
--- New file ---
+++ userguide/php-mysqli.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="php-mysqli">
<title>Using the PHP5 mysqli API with MySQL</title>
</chapter>
<!-- END MYSQLI CHAPTER -->
--- New file ---
+++ userguide/populating.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="populating">
<title>Populating a Schema</title>
<section id="populating-sql-file">
<title>Populating a Schema with a SQL File</title>
<para></para>
</section>
<!-- END SQL FILE -->
<section id="populating-load-data">
<title>Populating a Schema with the LOAD DATA Statement</title>
<para></para>
</section>
<!-- END LOAD DATA -->
</chapter>
<!-- END POPULATING CHAPTER -->
--- New file ---
+++ userguide/querying.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="querying">
<title>Querying Data</title>
<section id="querying-select">
<title>Using SELECT</title>
<para></para>
<section id="querying-select-clause">
<title>The SELECT Clause</title>
<para></para>
</section>
<!-- END SELECT CLAUSE -->
<section id="querying-select-from-clause">
<title>The FROM Clause</title>
<para></para>
</section>
<!-- END FROM CLAUSE -->
<section id="querying-select-where-clause">
<title>The WHERE Clause</title>
<para></para>
</section>
<!-- END WHERE CLAUSE -->
<section id="querying-select-group-by-clause">
<title>The GROUP BY Clause</title>
<para></para>
</section>
<!-- END GROUP BY -->
<section id="querying-select-having-clause">
<title>The Having Clause</title>
<para></para>
</section>
<!-- END HAVING -->
<section id="querying-select-order-by">
<title>The ORDER BY Clause</title>
<para></para>
</section>
<!-- END ORDER BY -->
<section id="querying-select-limit-clause">
<title>The LIMIT Clause</title>
<para></para>
</section>
<!-- END LIMIT -->
</section>
<!-- END SELECT -->
<section id="querying-functions">
<title>Functions in Queries</title>
<para></para>
</section>
<!-- END FUNCTIONS -->
<section id="querying-aggregate">
<title>Aggregate Functions in Queries</title>
<para></para>
</section>
<!-- END AGGREGATE -->
<section id="querying-variables">
<title>Using User Variables</title>
<para></para>
</section>
<!-- END VARIABLES -->
<section id="querying-subqueries">
<title>Subqueries</title>
<para></para>
</section>
<!-- END SUBQUERIES -->
</chapter>
<!-- END QUERYING CHAPTER -->
--- New file ---
+++ userguide/security.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="security">
<title>MySQL Security</title>
<section id="security-do-dont">
<title>Security Do's and Don'ts</title>
<para></para>
</section>
<!-- END DO'S AND DONT'S -->
<section id="security-privilege">
<title>Privilege System Basics</title>
<para></para>
</section>
<!-- END BASICS -->
<section id="security-default">
<title>Securing Default User Accounts</title>
<para></para>
</section>
<!-- END DEFAULT ACCOUNTS -->
</chapter>
<!-- END SECURITY CHAPTER -->
--- New file ---
+++ userguide/storage-engines.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="storage-engines">
<title>MySQL Storage Engines</title>
<section id="storage-engines-myisam">
<title>The MyISAM Storage Engine</title>
<para></para>
</section>
<!-- END MYISAM -->
<section id="storage-engines-innodb">
<title>The InnoDB Storage Engine</title>
<para></para>
</section>
<!-- END TYPES -->
<section id="storage-engines-other">
<title>Other Storage Engines</title>
<para></para>
</section>
<!-- END OTHER -->
</chapter>
<!-- END STORAGE ENGINE CHAPTER -->
--- New file ---
+++ userguide/stored-procedures.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="stored-procedures">
<title>MySQL Stored Procedures</title>
<section id="stored-procedures-what">
<title>What is a Stored Procedure?</title>
<para></para>
</section>
<!-- END WHAT -->
<section id="stored-procedures-creating">
<title>Creating Stored Procedures</title>
<para></para>
</section>
<!-- END CREATING -->
<section id="stored-procedures-using">
<title>Using Stored Procedures to Reduce or Replace Application Logic</title>
<para></para>
</section>
<!-- END USING -->
</chapter>
<!-- END STORED PROCEDURES CHAPTER -->
--- New file ---
+++ userguide/userguide-prepped.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="utf-8" standalone="no"?>
<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN" "http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<book lang="en" id="userguide">
<title>MySQL User Guide</title>
<chapter id="introduction">
<title>Introduction</title>
<section id="introduction-what-is-rdb">
<title>What is a Relational Database?</title>
<para/>
</section>
<section id="introduction-what-is-rdbms">
<title>What is a Relational Database Management System?</title>
<para/>
</section>
<section id="introduction-what-is-mysql">
<title>What is MySQL?</title>
<para/>
</section>
<section id="introduction-why-use-mysql">
<title>Why Use MySQL?</title>
<para/>
</section>
</chapter>
<part label="Part I: MySQL Administration">
<title>MySQL Server Administration</title>
<chapter id="installing">
<title>Installing MySQL</title>
<section id="installing-introduction">
<title>Introduction</title>
<para/>
</section>
<section id="installing-downloading">
<title>Downloading MySQL</title>
<para/>
</section>
<section id="installing-installation">
<title>Installation</title>
<para/>
<section id="installing-installation-windows">
<title>Installing MySQL on Windows</title>
<para/>
</section>
<section id="installing-installation-linux">
<title>Installing MySQL on Linux</title>
<para/>
</section>
<section id="installing-installation-mac">
<title>Installing MySQL on Mac</title>
<para/>
</section>
</section>
<section id="installing-upgrading">
<title>Upgrading MySQL</title>
<para/>
</section>
<section id="installing-gui">
<title>Installing the MySQL GUI Tools</title>
<para/>
<section id="installing-gui-introduction">
<title>Introduction</title>
<para/>
</section>
<section id="installing-gui-downloading">
<title>Downloading the MySQL GUI Tools</title>
<para/>
</section>
<section id="installing-gui-installing">
<title>Installing the MySQL GUI Tools</title>
<para/>
</section>
<section id="installing-gui-starting">
<title>Starting the MySQL GUI Tools</title>
<para/>
</section>
</section>
</chapter>
<chapter id="configuring">
<title>Configuring MySQL</title>
</chapter>
<chapter id="security">
<title>MySQL Security</title>
<section id="security-do-dont">
<title>Security Do's and Don'ts</title>
<para/>
</section>
<section id="security-privilege">
<title>Privilege System Basics</title>
<para/>
</section>
<section id="security-default">
<title>Securing Default User Accounts</title>
<para/>
</section>
</chapter>
</part>
<part label="Part II: MySQL Usage">
<title>Using MySQL</title>
<chapter id="creating">
<title>Creating Schema and Tables</title>
<section id="creating-planning">
<title>Planning a Schema Design</title>
<para/>
</section>
<section id="creating-normalization">
<title>Database Normalization</title>
<para/>
</section>
<section id="creating-column-types">
<title>Choosing Column Types</title>
<para/>
</section>
<section id="creating-schema">
<title>Creating Schema</title>
<para/>
</section>
<section id="creating-tables">
<title>Creating Tables</title>
<para/>
</section>
<section id="creating-altering">
<title>Altering Schema and Tables</title>
<para/>
</section>
</chapter>
<chapter id="populating">
<title>Populating a Schema</title>
<section id="populating-sql-file">
<title>Populating a Schema with a SQL File</title>
<para/>
</section>
<section id="populating-load-data">
<title>Populating a Schema with the LOAD DATA Statement</title>
<para/>
</section>
</chapter>
<chapter id="querying">
<title>Querying Data</title>
<section id="querying-select">
<title>Using SELECT</title>
<para/>
<section id="querying-select-clause">
<title>The SELECT Clause</title>
<para/>
</section>
<section id="querying-select-from-clause">
<title>The FROM Clause</title>
<para/>
</section>
<section id="querying-select-where-clause">
<title>The WHERE Clause</title>
<para/>
</section>
<section id="querying-select-group-by-clause">
<title>The GROUP BY Clause</title>
<para/>
</section>
<section id="querying-select-having-clause">
<title>The Having Clause</title>
<para/>
</section>
<section id="querying-select-order-by">
<title>The ORDER BY Clause</title>
<para/>
</section>
<section id="querying-select-limit-clause">
<title>The LIMIT Clause</title>
<para/>
</section>
</section>
<section id="querying-functions">
<title>Functions in Queries</title>
<para/>
</section>
<section id="querying-aggregate">
<title>Aggregate Functions in Queries</title>
<para/>
</section>
<section id="querying-variables">
<title>Using User Variables</title>
<para/>
</section>
<section id="querying-subqueries">
<title>Subqueries</title>
<para/>
</section>
</chapter>
<chapter id="modifying">
<title>Modifying Data</title>
<section id="modifying-insert">
<title>Adding Data with the INSERT Statement</title>
<para/>
</section>
<section id="modifying-update">
<title>Changing Data with the UPDATE Statement</title>
<para/>
</section>
<section id="modifying-delete">
<title>Removing Data with the DELETE Statement</title>
<para/>
</section>
</chapter>
<chapter id="indexing">
<title>Indexing Data</title>
<section id="indexing-why">
<title>Why Use Indexes?</title>
<para/>
</section>
<section id="indexing-types">
<title>Types of Indexes</title>
<para/>
</section>
<section id="indexing-displaying">
<title>Displaying Table Indexes</title>
<para/>
</section>
<section id="indexing-creating">
<title>Creating Indexes</title>
<para/>
</section>
<section id="indexing-dropping">
<title>Dropping Indexes</title>
<para/>
</section>
<section id="indexing-optimizing">
<title>Using EXPLAIN to Improve Indexing</title>
<para/>
</section>
</chapter>
<chapter id="storage-engines">
<title>MySQL Storage Engines</title>
<section id="storage-engines-myisam">
<title>The MyISAM Storage Engine</title>
<para/>
</section>
<section id="storage-engines-innodb">
<title>The InnoDB Storage Engine</title>
<para/>
</section>
<section id="storage-engines-other">
<title>Other Storage Engines</title>
<para/>
</section>
</chapter>
<chapter id="views">
<title>MySQL Views</title>
<section id="views-what">
<title>What is a Database VIEW?</title>
<para/>
</section>
<section id="views-creating">
<title>The InnoDB Storage Engine</title>
<para/>
</section>
<section id="views-security">
<title>Using VIEWs to Grant Access to Portions of Your Data</title>
<para/>
</section>
</chapter>
<chapter id="stored-procedures">
<title>MySQL Stored Procedures</title>
<section id="stored-procedures-what">
<title>What is a Stored Procedure?</title>
<para/>
</section>
<section id="stored-procedures-creating">
<title>Creating Stored Procedures</title>
<para/>
</section>
<section id="stored-procedures-using">
<title>Using Stored Procedures to Reduce or Replace Application Logic</title>
<para/>
</section>
</chapter>
</part>
<part label="Part III: MySQL APIs">
<title>Using the MySQL APIs</title>
<chapter id="php-mysqli">
<title>Using the PHP5 mysqli API with MySQL</title>
</chapter>
<chapter id="dotnet">
<title>Using the Connector/NET API with MySQL</title>
</chapter>
<chapter id="java">
<title>Using the Connector/J API with MySQL</title>
</chapter>
</part>
</book>
--- New file ---
+++ userguide/userguide.html 05/06/08 15:44:33
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>MySQL User Guide</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.68.1">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="book" lang="en">
<div class="titlepage">
<div><div><h1 class="title">
<a name="userguide"></a>MySQL User Guide</h1></div></div>
<hr>
</div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="chapter"><a href="#introduction">1. Introduction</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#introduction-what-is-rdb">1.1. What is a Relational Database?</a></span></dt>
<dt><span class="section"><a href="#introduction-what-is-rdbms">1.2. What is a Relational Database Management System?</a></span></dt>
<dt><span class="section"><a href="#introduction-what-is-mysql">1.3. What is MySQL?</a></span></dt>
<dt><span class="section"><a href="#introduction-why-use-mysql">1.4. Why Use MySQL?</a></span></dt>
</dl></dd>
<dt><span class="part"><a href="#id2835764">Part I: MySQL Administration. MySQL Server Administration</a></span></dt>
<dd><dl>
<dt><span class="chapter"><a href="#installing">2. Installing MySQL</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-introduction">2.1. Introduction</a></span></dt>
<dt><span class="section"><a href="#installing-downloading">2.2. Downloading MySQL</a></span></dt>
<dt><span class="section"><a href="#installing-installation">2.3. Installation</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-installation-windows">2.3.1. Installing MySQL on Windows</a></span></dt>
<dt><span class="section"><a href="#installing-installation-linux">2.3.2. Installing MySQL on Linux</a></span></dt>
<dt><span class="section"><a href="#installing-installation-mac">2.3.3. Installing MySQL on Mac</a></span></dt>
</dl></dd>
<dt><span class="section"><a href="#installing-upgrading">2.4. Upgrading MySQL</a></span></dt>
<dt><span class="section"><a href="#installing-gui">2.5. Installing the MySQL GUI Tools</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-gui-introduction">2.5.1. Introduction</a></span></dt>
<dt><span class="section"><a href="#installing-gui-downloading">2.5.2. Downloading the MySQL GUI Tools</a></span></dt>
<dt><span class="section"><a href="#installing-gui-installing">2.5.3. Installing the MySQL GUI Tools</a></span></dt>
<dt><span class="section"><a href="#installing-gui-starting">2.5.4. Starting the MySQL GUI Tools</a></span></dt>
</dl></dd>
</dl></dd>
<dt><span class="chapter"><a href="#configuring">3. Configuring MySQL</a></span></dt>
<dt><span class="chapter"><a href="#security">4. MySQL Security</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#security-do-dont">4.1. Security Do's and Don'ts</a></span></dt>
<dt><span class="section"><a href="#security-privilege">4.2. Privilege System Basics</a></span></dt>
<dt><span class="section"><a href="#security-default">4.3. Securing Default User Accounts</a></span></dt>
</dl></dd>
</dl></dd>
<dt><span class="part"><a href="#id2836123">Part II: MySQL Usage. Using MySQL</a></span></dt>
<dd><dl>
<dt><span class="chapter"><a href="#creating">5. Creating Schema and Tables</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#creating-planning">5.1. Planning a Schema Design</a></span></dt>
<dt><span class="section"><a href="#creating-normalization">5.2. Database Normalization</a></span></dt>
<dt><span class="section"><a href="#creating-column-types">5.3. Choosing Column Types</a></span></dt>
<dt><span class="section"><a href="#creating-schema">5.4. Creating Schema</a></span></dt>
<dt><span class="section"><a href="#creating-tables">5.5. Creating Tables</a></span></dt>
<dt><span class="section"><a href="#creating-altering">5.6. Altering Schema and Tables</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#populating">6. Populating a Schema</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#populating-sql-file">6.1. Populating a Schema with a SQL File</a></span></dt>
<dt><span class="section"><a href="#populating-load-data">6.2. Populating a Schema with the LOAD DATA Statement</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#querying">7. Querying Data</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#querying-select">7.1. Using SELECT</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#querying-select-clause">7.1.1. The SELECT Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-from-clause">7.1.2. The FROM Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-where-clause">7.1.3. The WHERE Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-group-by-clause">7.1.4. The GROUP BY Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-having-clause">7.1.5. The Having Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-order-by">7.1.6. The ORDER BY Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-limit-clause">7.1.7. The LIMIT Clause</a></span></dt>
</dl></dd>
<dt><span class="section"><a href="#querying-functions">7.2. Functions in Queries</a></span></dt>
<dt><span class="section"><a href="#querying-aggregate">7.3. Aggregate Functions in Queries</a></span></dt>
<dt><span class="section"><a href="#querying-variables">7.4. Using User Variables</a></span></dt>
<dt><span class="section"><a href="#querying-subqueries">7.5. Subqueries</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#modifying">8. Modifying Data</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#modifying-insert">8.1. Adding Data with the INSERT Statement</a></span></dt>
<dt><span class="section"><a href="#modifying-update">8.2. Changing Data with the UPDATE Statement</a></span></dt>
<dt><span class="section"><a href="#modifying-delete">8.3. Removing Data with the DELETE Statement</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#indexing">9. Indexing Data</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#indexing-why">9.1. Why Use Indexes?</a></span></dt>
<dt><span class="section"><a href="#indexing-types">9.2. Types of Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-displaying">9.3. Displaying Table Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-creating">9.4. Creating Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-dropping">9.5. Dropping Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-optimizing">9.6. Using EXPLAIN to Improve Indexing</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#storage-engines">10. MySQL Storage Engines</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#storage-engines-myisam">10.1. The MyISAM Storage Engine</a></span></dt>
<dt><span class="section"><a href="#storage-engines-innodb">10.2. The InnoDB Storage Engine</a></span></dt>
<dt><span class="section"><a href="#storage-engines-other">10.3. Other Storage Engines</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#views">11. MySQL Views</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#views-what">11.1. What is a Database VIEW?</a></span></dt>
<dt><span class="section"><a href="#views-creating">11.2. The InnoDB Storage Engine</a></span></dt>
<dt><span class="section"><a href="#views-security">11.3. Using VIEWs to Grant Access to Portions of Your Data</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#stored-procedures">12. MySQL Stored Procedures</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#stored-procedures-what">12.1. What is a Stored Procedure?</a></span></dt>
<dt><span class="section"><a href="#stored-procedures-creating">12.2. Creating Stored Procedures</a></span></dt>
<dt><span class="section"><a href="#stored-procedures-using">12.3. Using Stored Procedures to Reduce or Replace Application Logic</a></span></dt>
</dl></dd>
</dl></dd>
<dt><span class="part"><a href="#id2836918">Part III: MySQL APIs. Using the MySQL APIs</a></span></dt>
<dd><dl>
<dt><span class="chapter"><a href="#php-mysqli">13. Using the PHP5 mysqli API with MySQL</a></span></dt>
<dt><span class="chapter"><a href="#dotnet">14. Using the Connector/NET API with MySQL</a></span></dt>
<dt><span class="chapter"><a href="#java">15. Using the Connector/J API with MySQL</a></span></dt>
</dl></dd>
</dl>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="introduction"></a>Chapter 1. Introduction</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#introduction-what-is-rdb">1.1. What is a Relational Database?</a></span></dt>
<dt><span class="section"><a href="#introduction-what-is-rdbms">1.2. What is a Relational Database Management System?</a></span></dt>
<dt><span class="section"><a href="#introduction-what-is-mysql">1.3. What is MySQL?</a></span></dt>
<dt><span class="section"><a href="#introduction-why-use-mysql">1.4. Why Use MySQL?</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="introduction-what-is-rdb"></a>1.1. What is a Relational Database?</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="introduction-what-is-rdbms"></a>1.2. What is a Relational Database Management System?</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="introduction-what-is-mysql"></a>1.3. What is MySQL?</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="introduction-why-use-mysql"></a>1.4. Why Use MySQL?</h2></div></div></div>
<p></p>
</div>
</div>
<div class="part" lang="en">
<div class="titlepage"><div><div><h1 class="title">
<a name="id2835764"></a>MySQL Server Administration</h1></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="chapter"><a href="#installing">2. Installing MySQL</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-introduction">2.1. Introduction</a></span></dt>
<dt><span class="section"><a href="#installing-downloading">2.2. Downloading MySQL</a></span></dt>
<dt><span class="section"><a href="#installing-installation">2.3. Installation</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-installation-windows">2.3.1. Installing MySQL on Windows</a></span></dt>
<dt><span class="section"><a href="#installing-installation-linux">2.3.2. Installing MySQL on Linux</a></span></dt>
<dt><span class="section"><a href="#installing-installation-mac">2.3.3. Installing MySQL on Mac</a></span></dt>
</dl></dd>
<dt><span class="section"><a href="#installing-upgrading">2.4. Upgrading MySQL</a></span></dt>
<dt><span class="section"><a href="#installing-gui">2.5. Installing the MySQL GUI Tools</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-gui-introduction">2.5.1. Introduction</a></span></dt>
<dt><span class="section"><a href="#installing-gui-downloading">2.5.2. Downloading the MySQL GUI Tools</a></span></dt>
<dt><span class="section"><a href="#installing-gui-installing">2.5.3. Installing the MySQL GUI Tools</a></span></dt>
<dt><span class="section"><a href="#installing-gui-starting">2.5.4. Starting the MySQL GUI Tools</a></span></dt>
</dl></dd>
</dl></dd>
<dt><span class="chapter"><a href="#configuring">3. Configuring MySQL</a></span></dt>
<dt><span class="chapter"><a href="#security">4. MySQL Security</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#security-do-dont">4.1. Security Do's and Don'ts</a></span></dt>
<dt><span class="section"><a href="#security-privilege">4.2. Privilege System Basics</a></span></dt>
<dt><span class="section"><a href="#security-default">4.3. Securing Default User Accounts</a></span></dt>
</dl></dd>
</dl>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="installing"></a>Chapter 2. Installing MySQL</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#installing-introduction">2.1. Introduction</a></span></dt>
<dt><span class="section"><a href="#installing-downloading">2.2. Downloading MySQL</a></span></dt>
<dt><span class="section"><a href="#installing-installation">2.3. Installation</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-installation-windows">2.3.1. Installing MySQL on Windows</a></span></dt>
<dt><span class="section"><a href="#installing-installation-linux">2.3.2. Installing MySQL on Linux</a></span></dt>
<dt><span class="section"><a href="#installing-installation-mac">2.3.3. Installing MySQL on Mac</a></span></dt>
</dl></dd>
<dt><span class="section"><a href="#installing-upgrading">2.4. Upgrading MySQL</a></span></dt>
<dt><span class="section"><a href="#installing-gui">2.5. Installing the MySQL GUI Tools</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#installing-gui-introduction">2.5.1. Introduction</a></span></dt>
<dt><span class="section"><a href="#installing-gui-downloading">2.5.2. Downloading the MySQL GUI Tools</a></span></dt>
<dt><span class="section"><a href="#installing-gui-installing">2.5.3. Installing the MySQL GUI Tools</a></span></dt>
<dt><span class="section"><a href="#installing-gui-starting">2.5.4. Starting the MySQL GUI Tools</a></span></dt>
</dl></dd>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="installing-introduction"></a>2.1. Introduction</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="installing-downloading"></a>2.2. Downloading MySQL</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="installing-installation"></a>2.3. Installation</h2></div></div></div>
<p></p>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-installation-windows"></a>2.3.1. Installing MySQL on Windows</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-installation-linux"></a>2.3.2. Installing MySQL on Linux</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-installation-mac"></a>2.3.3. Installing MySQL on Mac</h3></div></div></div>
<p></p>
</div>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="installing-upgrading"></a>2.4. Upgrading MySQL</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="installing-gui"></a>2.5. Installing the MySQL GUI Tools</h2></div></div></div>
<p></p>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-gui-introduction"></a>2.5.1. Introduction</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-gui-downloading"></a>2.5.2. Downloading the MySQL GUI Tools</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-gui-installing"></a>2.5.3. Installing the MySQL GUI Tools</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="installing-gui-starting"></a>2.5.4. Starting the MySQL GUI Tools</h3></div></div></div>
<p></p>
</div>
</div>
</div>
<div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title">
<a name="configuring"></a>Chapter 3. Configuring MySQL</h2></div></div></div></div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="security"></a>Chapter 4. MySQL Security</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#security-do-dont">4.1. Security Do's and Don'ts</a></span></dt>
<dt><span class="section"><a href="#security-privilege">4.2. Privilege System Basics</a></span></dt>
<dt><span class="section"><a href="#security-default">4.3. Securing Default User Accounts</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="security-do-dont"></a>4.1. Security Do's and Don'ts</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="security-privilege"></a>4.2. Privilege System Basics</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="security-default"></a>4.3. Securing Default User Accounts</h2></div></div></div>
<p></p>
</div>
</div>
</div>
<div class="part" lang="en">
<div class="titlepage"><div><div><h1 class="title">
<a name="id2836123"></a>Using MySQL</h1></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="chapter"><a href="#creating">5. Creating Schema and Tables</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#creating-planning">5.1. Planning a Schema Design</a></span></dt>
<dt><span class="section"><a href="#creating-normalization">5.2. Database Normalization</a></span></dt>
<dt><span class="section"><a href="#creating-column-types">5.3. Choosing Column Types</a></span></dt>
<dt><span class="section"><a href="#creating-schema">5.4. Creating Schema</a></span></dt>
<dt><span class="section"><a href="#creating-tables">5.5. Creating Tables</a></span></dt>
<dt><span class="section"><a href="#creating-altering">5.6. Altering Schema and Tables</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#populating">6. Populating a Schema</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#populating-sql-file">6.1. Populating a Schema with a SQL File</a></span></dt>
<dt><span class="section"><a href="#populating-load-data">6.2. Populating a Schema with the LOAD DATA Statement</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#querying">7. Querying Data</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#querying-select">7.1. Using SELECT</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#querying-select-clause">7.1.1. The SELECT Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-from-clause">7.1.2. The FROM Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-where-clause">7.1.3. The WHERE Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-group-by-clause">7.1.4. The GROUP BY Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-having-clause">7.1.5. The Having Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-order-by">7.1.6. The ORDER BY Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-limit-clause">7.1.7. The LIMIT Clause</a></span></dt>
</dl></dd>
<dt><span class="section"><a href="#querying-functions">7.2. Functions in Queries</a></span></dt>
<dt><span class="section"><a href="#querying-aggregate">7.3. Aggregate Functions in Queries</a></span></dt>
<dt><span class="section"><a href="#querying-variables">7.4. Using User Variables</a></span></dt>
<dt><span class="section"><a href="#querying-subqueries">7.5. Subqueries</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#modifying">8. Modifying Data</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#modifying-insert">8.1. Adding Data with the INSERT Statement</a></span></dt>
<dt><span class="section"><a href="#modifying-update">8.2. Changing Data with the UPDATE Statement</a></span></dt>
<dt><span class="section"><a href="#modifying-delete">8.3. Removing Data with the DELETE Statement</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#indexing">9. Indexing Data</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#indexing-why">9.1. Why Use Indexes?</a></span></dt>
<dt><span class="section"><a href="#indexing-types">9.2. Types of Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-displaying">9.3. Displaying Table Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-creating">9.4. Creating Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-dropping">9.5. Dropping Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-optimizing">9.6. Using EXPLAIN to Improve Indexing</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#storage-engines">10. MySQL Storage Engines</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#storage-engines-myisam">10.1. The MyISAM Storage Engine</a></span></dt>
<dt><span class="section"><a href="#storage-engines-innodb">10.2. The InnoDB Storage Engine</a></span></dt>
<dt><span class="section"><a href="#storage-engines-other">10.3. Other Storage Engines</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#views">11. MySQL Views</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#views-what">11.1. What is a Database VIEW?</a></span></dt>
<dt><span class="section"><a href="#views-creating">11.2. The InnoDB Storage Engine</a></span></dt>
<dt><span class="section"><a href="#views-security">11.3. Using VIEWs to Grant Access to Portions of Your Data</a></span></dt>
</dl></dd>
<dt><span class="chapter"><a href="#stored-procedures">12. MySQL Stored Procedures</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#stored-procedures-what">12.1. What is a Stored Procedure?</a></span></dt>
<dt><span class="section"><a href="#stored-procedures-creating">12.2. Creating Stored Procedures</a></span></dt>
<dt><span class="section"><a href="#stored-procedures-using">12.3. Using Stored Procedures to Reduce or Replace Application Logic</a></span></dt>
</dl></dd>
</dl>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="creating"></a>Chapter 5. Creating Schema and Tables</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#creating-planning">5.1. Planning a Schema Design</a></span></dt>
<dt><span class="section"><a href="#creating-normalization">5.2. Database Normalization</a></span></dt>
<dt><span class="section"><a href="#creating-column-types">5.3. Choosing Column Types</a></span></dt>
<dt><span class="section"><a href="#creating-schema">5.4. Creating Schema</a></span></dt>
<dt><span class="section"><a href="#creating-tables">5.5. Creating Tables</a></span></dt>
<dt><span class="section"><a href="#creating-altering">5.6. Altering Schema and Tables</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="creating-planning"></a>5.1. Planning a Schema Design</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="creating-normalization"></a>5.2. Database Normalization</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="creating-column-types"></a>5.3. Choosing Column Types</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="creating-schema"></a>5.4. Creating Schema</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="creating-tables"></a>5.5. Creating Tables</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="creating-altering"></a>5.6. Altering Schema and Tables</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="populating"></a>Chapter 6. Populating a Schema</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#populating-sql-file">6.1. Populating a Schema with a SQL File</a></span></dt>
<dt><span class="section"><a href="#populating-load-data">6.2. Populating a Schema with the LOAD DATA Statement</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="populating-sql-file"></a>6.1. Populating a Schema with a SQL File</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="populating-load-data"></a>6.2. Populating a Schema with the LOAD DATA Statement</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="querying"></a>Chapter 7. Querying Data</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#querying-select">7.1. Using SELECT</a></span></dt>
<dd><dl>
<dt><span class="section"><a href="#querying-select-clause">7.1.1. The SELECT Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-from-clause">7.1.2. The FROM Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-where-clause">7.1.3. The WHERE Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-group-by-clause">7.1.4. The GROUP BY Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-having-clause">7.1.5. The Having Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-order-by">7.1.6. The ORDER BY Clause</a></span></dt>
<dt><span class="section"><a href="#querying-select-limit-clause">7.1.7. The LIMIT Clause</a></span></dt>
</dl></dd>
<dt><span class="section"><a href="#querying-functions">7.2. Functions in Queries</a></span></dt>
<dt><span class="section"><a href="#querying-aggregate">7.3. Aggregate Functions in Queries</a></span></dt>
<dt><span class="section"><a href="#querying-variables">7.4. Using User Variables</a></span></dt>
<dt><span class="section"><a href="#querying-subqueries">7.5. Subqueries</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="querying-select"></a>7.1. Using SELECT</h2></div></div></div>
<p></p>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-clause"></a>7.1.1. The SELECT Clause</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-from-clause"></a>7.1.2. The FROM Clause</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-where-clause"></a>7.1.3. The WHERE Clause</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-group-by-clause"></a>7.1.4. The GROUP BY Clause</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-having-clause"></a>7.1.5. The Having Clause</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-order-by"></a>7.1.6. The ORDER BY Clause</h3></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h3 class="title">
<a name="querying-select-limit-clause"></a>7.1.7. The LIMIT Clause</h3></div></div></div>
<p></p>
</div>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="querying-functions"></a>7.2. Functions in Queries</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="querying-aggregate"></a>7.3. Aggregate Functions in Queries</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="querying-variables"></a>7.4. Using User Variables</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="querying-subqueries"></a>7.5. Subqueries</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="modifying"></a>Chapter 8. Modifying Data</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#modifying-insert">8.1. Adding Data with the INSERT Statement</a></span></dt>
<dt><span class="section"><a href="#modifying-update">8.2. Changing Data with the UPDATE Statement</a></span></dt>
<dt><span class="section"><a href="#modifying-delete">8.3. Removing Data with the DELETE Statement</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="modifying-insert"></a>8.1. Adding Data with the INSERT Statement</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="modifying-update"></a>8.2. Changing Data with the UPDATE Statement</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="modifying-delete"></a>8.3. Removing Data with the DELETE Statement</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="indexing"></a>Chapter 9. Indexing Data</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#indexing-why">9.1. Why Use Indexes?</a></span></dt>
<dt><span class="section"><a href="#indexing-types">9.2. Types of Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-displaying">9.3. Displaying Table Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-creating">9.4. Creating Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-dropping">9.5. Dropping Indexes</a></span></dt>
<dt><span class="section"><a href="#indexing-optimizing">9.6. Using EXPLAIN to Improve Indexing</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="indexing-why"></a>9.1. Why Use Indexes?</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="indexing-types"></a>9.2. Types of Indexes</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="indexing-displaying"></a>9.3. Displaying Table Indexes</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="indexing-creating"></a>9.4. Creating Indexes</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="indexing-dropping"></a>9.5. Dropping Indexes</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="indexing-optimizing"></a>9.6. Using EXPLAIN to Improve Indexing</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="storage-engines"></a>Chapter 10. MySQL Storage Engines</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#storage-engines-myisam">10.1. The MyISAM Storage Engine</a></span></dt>
<dt><span class="section"><a href="#storage-engines-innodb">10.2. The InnoDB Storage Engine</a></span></dt>
<dt><span class="section"><a href="#storage-engines-other">10.3. Other Storage Engines</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="storage-engines-myisam"></a>10.1. The MyISAM Storage Engine</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="storage-engines-innodb"></a>10.2. The InnoDB Storage Engine</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="storage-engines-other"></a>10.3. Other Storage Engines</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="views"></a>Chapter 11. MySQL Views</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#views-what">11.1. What is a Database VIEW?</a></span></dt>
<dt><span class="section"><a href="#views-creating">11.2. The InnoDB Storage Engine</a></span></dt>
<dt><span class="section"><a href="#views-security">11.3. Using VIEWs to Grant Access to Portions of Your Data</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="views-what"></a>11.1. What is a Database VIEW?</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="views-creating"></a>11.2. The InnoDB Storage Engine</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="views-security"></a>11.3. Using VIEWs to Grant Access to Portions of Your Data</h2></div></div></div>
<p></p>
</div>
</div>
<div class="chapter" lang="en">
<div class="titlepage"><div><div><h2 class="title">
<a name="stored-procedures"></a>Chapter 12. MySQL Stored Procedures</h2></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="section"><a href="#stored-procedures-what">12.1. What is a Stored Procedure?</a></span></dt>
<dt><span class="section"><a href="#stored-procedures-creating">12.2. Creating Stored Procedures</a></span></dt>
<dt><span class="section"><a href="#stored-procedures-using">12.3. Using Stored Procedures to Reduce or Replace Application Logic</a></span></dt>
</dl>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="stored-procedures-what"></a>12.1. What is a Stored Procedure?</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="stored-procedures-creating"></a>12.2. Creating Stored Procedures</h2></div></div></div>
<p></p>
</div>
<div class="section" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="stored-procedures-using"></a>12.3. Using Stored Procedures to Reduce or Replace Application Logic</h2></div></div></div>
<p></p>
</div>
</div>
</div>
<div class="part" lang="en">
<div class="titlepage"><div><div><h1 class="title">
<a name="id2836918"></a>Using the MySQL APIs</h1></div></div></div>
<div class="toc">
<p><b>Table of Contents</b></p>
<dl>
<dt><span class="chapter"><a href="#php-mysqli">13. Using the PHP5 mysqli API with MySQL</a></span></dt>
<dt><span class="chapter"><a href="#dotnet">14. Using the Connector/NET API with MySQL</a></span></dt>
<dt><span class="chapter"><a href="#java">15. Using the Connector/J API with MySQL</a></span></dt>
</dl>
</div>
<div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title">
<a name="php-mysqli"></a>Chapter 13. Using the PHP5 mysqli API with MySQL</h2></div></div></div></div>
<div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title">
<a name="dotnet"></a>Chapter 14. Using the Connector/NET API with MySQL</h2></div></div></div></div>
<div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title">
<a name="java"></a>Chapter 15. Using the Connector/J API with MySQL</h2></div></div></div></div>
</div>
</div></body>
</html>
--- New file ---
+++ userguide/userguide.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<book id="userguide" lang="en">
<title>MySQL User Guide</title>
<xi:include href="introduction.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<part label="Part I: MySQL Administration">
<title>MySQL Server Administration</title>
<xi:include href="installing.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="configuring.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="security.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
</part>
<part label="Part II: MySQL Usage">
<title>Using MySQL</title>
<xi:include href="creating.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="populating.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="querying.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="modifying.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="indexing.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="storage-engines.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="views.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="stored-procedures.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
</part>
<part label="Part III: MySQL APIs">
<title>Using the MySQL APIs</title>
<xi:include href="php-mysqli.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="dotnet.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="java.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
</part>
</book>
--- New file ---
+++ userguide/views.xml 05/06/08 15:44:33
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<chapter id="views">
<title>MySQL Views</title>
<section id="views-what">
<title>What is a Database VIEW?</title>
<para></para>
</section>
<!-- END WHAT -->
<section id="views-creating">
<title>The InnoDB Storage Engine</title>
<para></para>
</section>
<!-- END CREATING -->
<section id="views-security">
<title>Using VIEWs to Grant Access to Portions of Your Data</title>
<para></para>
</section>
<!-- END SECURITY -->
</chapter>
<!-- END VIEWS CHAPTER -->
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (Mike.Hillyer:1.2735) | mhillyer | 8 Jun |
