MySQL Lists: internals: bk commit - mysqldoc@docsrva tree (Mike.Hillyer:1.2735)

List:	Internals	« Previous Message Next Message »
From:	mhillyer	Date:	June 8 2005 11:44pm
Subject:	bk commit - mysqldoc@docsrva tree (Mike.Hillyer:1.2735)
View as plain text
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