svn commit - mysqldoc@docsrva: r3485 - trunk/userguide

[plavin]

Author: plavin
Date: 2006-09-28 00:30:29 +0200 (Thu, 28 Sep 2006)
New Revision: 3485

Log:
New file to create TOC for User Guide

Added:
   trunk/userguide/newuserguide.xml

Property changes on: trunk/userguide/newuserguide.xml
___________________________________________________________________
Name: svn:executable
   + *


Added: trunk/userguide/newuserguide.xml
===================================================================
--- trunk/userguide/newuserguide.xml	                        (rev 0)
+++ trunk/userguide/newuserguide.xml	2006-09-27 22:30:29 UTC (rev 3485)
Changed blocks: 1, Lines Added: 1285, Lines Deleted: 0; 17197 bytes

@@ -0,0 +1,1285 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!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">
+
+  <bookinfo>
+
+    <title>MySQL User Guide</title>
+
+    <abstract>
+
+      <para>
+        This is the MySQL User Guide.
+      </para>
+
+      <para>
+        Document generated on:
+
+<?dbtimestamp format="Y-m-d"?>
+
+        <remark role="repository.revision"/>
+      </para>
+
+    </abstract>
+
+  </bookinfo>
+
+  <chapter id="introduction">
+
+    <title>Introduction</title>
+
+    <section>
+
+      <title>What is MySQL?</title>
+
+      <section>
+
+        <title>Main Features</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>MySQL On the Web</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>MySQL Enterprise Applications</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>MySQL Desktop Applications</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Main Features</title>
+
+        <para></para>
+
+      </section>
+
+    </section>
+
+    <section>
+
+      <title>Why Use MySQL?</title>
+
+      <section>
+
+        <title>What Can MySQL Do?</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Example Applications</title>
+
+        <para></para>
+
+      </section>
+
+    </section>
+
+    <section>
+
+      <title>About This Book</title>
+
+      <section>
+
+        <title>Target Audience</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>This is Not the Manual</title>
+
+        <para></para>
+
+      </section>
+
+    </section>
+
+    <section>
+
+      <title>Version of MySQL Used</title>
+
+      <section>
+
+        <title>Operating Systems Supported</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Variations Between Operating Systems</title>
+
+        <para></para>
+
+      </section>
+
+    </section>
+
+  </chapter>
+
+<!--Start Part I-->
+
+  <part label="I">
+
+    <title>Getting Started</title>
+
+    <chapter>
+
+      <title>Introduction</title>
+
+      <para></para>
+
+    </chapter>
+
+    <chapter>
+
+      <title>Installing MySQL</title>
+
+      <section>
+
+        <title>Introduction</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Installing on Windows</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Installing on Linux</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Installing on Mac OS X</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Checklist If Installer/RPM Not Used</title>
+
+        <section>
+
+          <title>Introduction</title>
+
+          <para>
+            You can skip this section if
+          </para>
+
+        </section>
+
+        <section>
+
+          <title>Sections Taken from the Reference Manual</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Installing the Help Files</title>
+
+          <para></para>
+
+        </section>
+
+      </section>
+
+<!--end installing-->
+
+    </chapter>
+
+<!--gui tools-->
+
+    <chapter>
+
+      <title>Using GUI Tools</title>
+
+      <section>
+
+        <title>Installing</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>MySQL Administrator</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end gui tools-->
+
+<!--start basic admin-->
+
+    <chapter>
+
+      <title>Basic Administration</title>
+
+      <section>
+
+        <title>Post Installation Tasks</title>
+
+        <para>
+          taken from manual
+        </para>
+
+      </section>
+
+      <section>
+
+        <title>PrivilegeSystem Basics</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Access Denied Errors</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end basic admin-->
+
+<!--start useful tools-->
+
+    <chapter>
+
+      <title>Useful Tools</title>
+
+      <section>
+
+        <title>Command Line Tools</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Tips</title>
+
+        <para>
+          mysql start-up options, invoking help from command line and
+          from within MySQL Administrator
+        </para>
+
+      </section>
+
+    </chapter>
+
+<!--end useful tools-->
+
+  </part>
+
+<!--end Part I-->
+
+<!--start Part II-->
+
+  <part>
+
+    <title>Using Mysql</title>
+
+<!--intro-->
+
+    <chapter>
+
+      <title>Introduction</title>
+
+      <section>
+
+        <title>Working From the Command Line</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Using Query Browser</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Sample Schema</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end intro-->
+
+<!--populating-->
+
+    <chapter>
+
+      <title>Populating a Schema</title>
+
+      <section>
+
+        <title>Populating with an SQL File</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Populating using LOAD DATA</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end populating-->
+
+<!--start querying-->
+
+    <chapter>
+
+      <title>Querying Data</title>
+
+<!--start SELECT-->
+
+      <section>
+
+        <title>Using SELECT</title>
+
+        <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>
+
+<!--joins-->
+
+      <section>
+
+        <title>Joins</title>
+
+        <section>
+
+          <title>Keys</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Foreign Keys</title>
+
+          <para></para>
+
+        </section>
+
+      </section>
+
+<!--end joins-->
+
+      <section>
+
+        <title>Subqueries</title>
+
+        <para></para>
+
+      </section>
+
+<!--end select-->
+
+    </chapter>
+
+<!--end querying-->
+
+<!--Data Types-->
+
+    <chapter>
+
+      <title>Data Types</title>
+
+      <section>
+
+        <title>Numeric</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>String</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Date</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Binary</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end Data Types-->
+
+<!--operators-->
+
+    <chapter>
+
+      <title>Operators</title>
+
+      <section>
+
+        <title>Arithmetic</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Logical</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end operatorss-->
+
+<!--Functions-->
+
+    <chapter>
+
+      <title>Functions</title>
+
+      <section>
+
+        <title>Mathematical</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>String</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Date</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Aggregate</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end Functions-->
+
+<!--Modifying Data-->
+
+    <chapter>
+
+      <title>Modifying Data</title>
+
+      <section>
+
+        <title>Adding Data Using INSERT</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Changing Data Using UPDATE</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Removing Data Using DELETE</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end Modifying Data -->
+
+  </part>
+
+<!--end Part II-->
+
+<!--Part III-->
+
+  <part label ="III">
+
+    <title>Advanced MySQL Usage</title>
+
+    <chapter>
+
+      <title>Creating Schemas and Tables</title>
+
+      <section>
+
+        <title>Designing a Schema</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Database Normalization</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Choosing Column Types</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Creating Schemas</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Creating Tables</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Altering Schemas and Tables</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end creating-->
+
+<!--Indexing-->
+
+    <chapter>
+
+      <title>Indexing Data</title>
+
+      <section>
+
+        <title>Introduction to Indexing</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Types of Indexes</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Choosing Columns to Index</title>
+
+        <para></para>
+
+      </section>
+
+<!--creating indexes-->
+
+      <section>
+
+        <title>Creating Indexes</title>
+
+        <section>
+
+          <title>Creating Indexes with The CREATE TABLE Statement</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Using The CREATE INDEX Syntax</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Using ALTER TABLE to Create Indexes</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Indexing the Prefix of a Column</title>
+
+          <para></para>
+
+        </section>
+
+      </section>
+
+<!--end creating indexes-->
+
+<!--displaying table indexes-->
+
+      <section>
+
+        <title>Displaying Table Indexes</title>
+
+        <section>
+
+          <title>Using the SHOW Command</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Using the INFORMATION_SCHEMA Schema</title>
+
+          <para></para>
+
+        </section>
+
+        <section>
+
+          <title>Using MySQL Administrator</title>
+
+          <para></para>
+
+        </section>
+
+      </section>
+
+<!--end displaying table indexes-->
+
+      <section>
+
+        <title>Creating and Using Composite Indexes</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Dropping Indexes</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Using FULLTEXT Indexes</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end indexing-->
+
+<!--Views-->
+
+    <chapter>
+
+      <title>Views</title>
+
+      <section>
+
+        <title>What is a View</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>The InnoDB Storage Engine</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Using Views to Restrict Access to Data</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end Views-->
+
+<!--Start Triggers-->
+
+    <chapter>
+
+      <title>Triggers</title>
+
+      <section>
+
+        <title>What Are Triggers</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Events</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Using Triggers</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end triggers-->
+
+<!--Start Stored Procedures-->
+
+    <chapter>
+
+      <title>Stored Procedures</title>
+
+      <section>
+
+        <title>What is a Stored Procedure</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Creating Stored procedures</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Using Stored Procedures to Replace Application Logic</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Using Stored Procedures to Enhance Security</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end stored procedures-->
+
+<!--Optimizing-->
+
+    <chapter>
+
+      <title>Optimization</title>
+
+      <section>
+
+        <title>Using EXPLAIN</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Optimizing SELECT Statements</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Optimizing Indexes</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!--end Optimizing-->
+
+    <chapter>
+
+      <title>Miscellaneous</title>
+
+      <remark>
+        Work this into other sections?
+      </remark>
+
+      <section>
+
+        <title>Using Variables</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Metadata</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+  </part>
+
+<!--end Part III-->
+
+<!-- Part IV-->
+
+  <part>
+
+    <title>Advanced MySQL Administration</title>
+
+    <chapter>
+
+      <title>Configuring MySQL</title>
+
+      <section>
+
+        <title>The Options File</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+    <chapter>
+
+      <title>Upgrading MySQL</title>
+
+      <para></para>
+
+    </chapter>
+
+    <chapter>
+
+      <title>MySQL Security</title>
+
+      <section>
+
+        <title>Security Basics</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Grants</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Best Practices</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+    <chapter>
+
+      <title>Disaster Prevention and Recovery</title>
+
+      <section>
+
+        <title>Introduction</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Backing up Your Data</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Best Practices</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+    <chapter>
+
+      <title>MySQL Log Files</title>
+
+      <section>
+
+        <title>What They Can Tell You</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Error Log</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Slow Query Log</title>
+
+        <para></para>
+
+      </section>
+
+      <section>
+
+        <title>Utilities for Use with the Logs</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+  </part>
+
+<!--end Part IV-->
+
+<!--Part V-->
+
+  <part>
+
+    <title>Using the MySQL APIs</title>
+
+    <chapter id="php-mysqli">
+
+      <title>Using the PHP5 mysqli API with MySQL</title>
+
+      <section id="php-mysqli-configuration">
+
+        <title>Configuring the mysqli Extension</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!-- END MYSQLI CHAPTER -->
+
+    <chapter id="java">
+
+      <title>Using the Connector/J API with MySQL</title>
+
+      <section id="java-install">
+
+        <title>Obtaining and Installing Connector/J</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!-- END JAVA CHAPTER -->
+
+    <chapter id="dotnet">
+
+      <title>Using the Connector/.NET API with MySQL</title>
+
+      <section id="dotnet-installing">
+
+        <title>Obtaining and Installing Connector/.NET</title>
+
+        <para></para>
+
+      </section>
+
+    </chapter>
+
+<!-- END DOTNET CHAPTER -->
+
+  </part>
+
+<!--end Part V-->
+
+  <part label="VI">
+
+    <title>Appendices</title>
+
+    <appendix>
+
+      <title>Other GUI Tools</title>
+
+      <para></para>
+
+    </appendix>
+
+    <appendix>
+
+      <title>Other MySQL Utilities</title>
+
+      <para></para>
+
+    </appendix>
+
+    <appendix>
+
+      <title>Migrating an Excel Database to MySQL</title>
+
+      <para></para>
+
+    </appendix>
+
+    <appendix>
+
+      <title>Using PHP Data Objects (PDO) With MySQL</title>
+
+      <para></para>
+
+    </appendix>
+
+    <appendix>
+
+      <title>Ruby and MySQL</title>
+
+      <para></para>
+
+    </appendix>
+
+    <appendix>
+
+      <title>phpMyAdmin</title>
+
+      <para></para>
+
+    </appendix>
+
+    <appendix>
+
+      <title>Glossary</title>
+
+      <para></para>
+
+    </appendix>
+
+  </part>
+
+</book>


Property changes on: trunk/userguide/newuserguide.xml
___________________________________________________________________
Name: svn:executable
   + *