Author: mcbrown
Date: 2007-03-01 14:43:34 +0100 (Thu, 01 Mar 2007)
New Revision: 5129
Log:
Completing appendix rationalization for 5.0 manual
Removed:
trunk/refman-5.0/error-handling.xml
trunk/refman-5.0/limits.xml
trunk/refman-5.0/porting.xml
Modified:
trunk/refman-5.0/Makefile
trunk/refman-5.0/faqs.xml
trunk/refman-5.0/functions.xml
trunk/refman-5.0/installing-cs.xml
trunk/refman-5.0/manual.xml
trunk/refman-5.0/renamed-nodes.txt
Modified: trunk/refman-5.0/Makefile
===================================================================
--- trunk/refman-5.0/Makefile 2007-03-01 12:23:04 UTC (rev 5128)
+++ trunk/refman-5.0/Makefile 2007-03-01 13:43:34 UTC (rev 5129)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 11147 bytes
@@ -44,7 +44,7 @@
MANUAL_SRCS_EXTRA = versions.ent ../common/fixedchars.ent ../refman-common/urls.ent ../common/phrases.ent
-MANUAL_SRCS = $(MANUAL_SRCS_EXTRA) manual.xml ../refman-common/bug-reports.xml ../refman-common/connector-j.xml ../refman-common/connector-mxj.xml ../refman-common/connector-net.xml ../refman-common/connector-odbc.xml ../refman-common/connector-php.xml ../refman-common/connector-vstudioplugin.xml ../refman-common/credits.xml ../refman-common/environment-variables.xml ../refman-common/gpl-license.xml ../refman-common/images/cmxj-overview.png ../refman-common/images/cnet-win-install-step1.png ../refman-common/images/cnet-win-install-step2.png ../refman-common/images/cnet-win-install-step3.png ../refman-common/images/cnet-win-install-step4.png ../refman-common/images/myaccess-odbc.png ../refman-common/images/myaccess.png ../refman-common/images/myarchitecture.png ../refman-common/images/myflowchart.png ../refman-common/images/myodbc-crystal-1.png ../refman-common/images/myodbc-crystal-2.png ../refman-common/images/myodbc-crystal-3.png ../refman-common/images/myodbc-crystal-4.p!
ng ../refman-common/images/myodbc-crystal-5.png ../refman-common/images/myodbc-crystal-6.png ../refman-common/images/myodbc-excel-step1.png ../refman-common/images/myodbc-excel-step2.png ../refman-common/images/myodbc-excel-step3.png ../refman-common/images/myodbc-excel-step4.png ../refman-common/images/myodbc-excel-step5.png ../refman-common/images/myodbc-link-step1.png ../refman-common/images/myodbc-link-step3.png ../refman-common/images/myodbc-link-step4.png ../refman-common/images/myodbc-link-step5.png ../refman-common/images/myodbc-macosx-install-step1.png ../refman-common/images/myodbc-macosx-install-step2.png ../refman-common/images/myodbc-macosx-install-step3.png ../refman-common/images/myodbc-macosx-install-step4.png ../refman-common/images/myodbc-macosx-install-step5.png ../refman-common/images/myodbc-macosx-install-step6.png ../refman-common/images/myodbc-macosx-odbcadmin-adddsn.png ../refman-common/images/myodbc-macosx-odbcadmin-main.png ../refman-common/images/!
myodbc-macosx-odbcadmin-sampledsn.png ../refman-common/images/!
myodbc-m
acosx-odbcadmin-tracing.png ../refman-common/images/myodbc-win-install-step1.png ../refman-common/images/myodbc-win-install-step2.png ../refman-common/images/myodbc-win-install-step3.png ../refman-common/images/myodbc-win-install-step4.png ../refman-common/images/myodbc-win-odbcadmin-adddsn.png ../refman-common/images/myodbc-win-odbcadmin-advanced.png ../refman-common/images/myodbc-win-odbcadmin-driverselect.png ../refman-common/images/myodbc-win-odbcadmin-main.png ../refman-common/images/myodbc-win-odbcadmin-options.png ../refman-common/images/myodbc-win-odbcadmin-sampledsn.png ../refman-common/images/myodbc-win-tracing.png ../refman-common/images/mysql-vstudioplugin-1.png ../refman-common/images/mysql-vstudioplugin-3.png ../refman-common/images/mysql-vstudioplugin-4.png ../refman-common/information-sources.xml ../refman-common/manual-conventions.en.xml ../refman-common/maxdb.en.xml ../refman-common/mysql-floss-license-exception.xml ../refman-common/news-cluster.xml ../refm!
an-common/news-connector-j.xml ../refman-common/news-connector-net.xml ../refman-common/news-myodbc.xml ../refman-common/news-vstudioplugin.xml ../refman-common/regexp.xml ../refman-common/what-is-mysql-ab.en.xml ../refman-common/what-is.en.xml apis-c.xml apis.xml charset.xml client-utility-programs.xml config-wizard.xml connectors.xml copyright.xml data-types.xml database-administration.xml dba-optvars-table.xml errmsgs-client.xml errmsgs-server.xml error-handling.xml extending-mysql.xml faqs.xml functions.xml images/blackhole-1.png images/cluster-components-1.png images/cluster-upgrade-downgrade-table.png images/multi-comp-1.png images/mysql-cfg-fig1.png images/mysql-cfg-fig10.png images/mysql-cfg-fig2.png images/mysql-cfg-fig3.png images/mysql-cfg-fig4.png images/mysql-cfg-fig5.png images/mysql-cfg-fig6.png images/mysql-cfg-fig7.png images/mysql-cfg-fig8.png images/mysql-cfg-fig9.png images/mysql-esi-linux-fig1.png images/mysql-esi-merlin-1.png images/mysql-esi-merlin-10!
.png images/mysql-esi-merlin-11.png images/mysql-esi-merlin-12!
.png ima
ges/mysql-esi-merlin-13.png images/mysql-esi-merlin-2.png images/mysql-esi-merlin-3.png images/mysql-esi-merlin-4.png images/mysql-esi-merlin-5.png images/mysql-esi-merlin-6.png images/mysql-esi-merlin-7.png images/mysql-esi-merlin-8.png images/mysql-esi-merlin-9.png images/mysql-esi-win32-fig1.png images/mysql-esi-win32-fig2.png images/mysql-esi-win32-fig3.png images/mysql-esi-win32-fig4.png images/mysql-esi-win32-fig6.png images/mysql-esi-win32-fig7.png images/mysql-esi-win32-uninst.png images/ndb-size-pl-1.png images/replicas-groups-1-1.png images/replicas-groups-1-2.png images/rolling-restarts.png information-schema.xml installing-cs.xml installing-es.xml installing-version.xml installing.xml introduction.xml language-structure.xml legalnotice.en.xml limits.xml mysql-cluster.xml news-5.0.xml news.xml optimization.xml porting.xml precision-math.xml preface.xml problems.xml releasenotes-cs-5.0.xml releasenotes-cs.xml releasenotes-es-5.0.xml releasenotes-es.xml replication.!
xml reserved-new-5.0.xml reservedwords.xml restrictions.xml se-archive.xml se-bdb.xml se-blackhole.xml se-csv.xml se-example.xml se-federated.xml se-innodb.xml se-memory.xml se-merge.xml se-myisam.xml spatial-extensions.xml sql-syntax.xml storage-engines.xml stored-procedures.xml triggers.xml tutorial.xml using-mysql-programs.xml views.xml
+MANUAL_SRCS = $(MANUAL_SRCS_EXTRA) manual.xml ../refman-common/bug-reports.xml ../refman-common/connector-j.xml ../refman-common/connector-mxj.xml ../refman-common/connector-net.xml ../refman-common/connector-odbc.xml ../refman-common/connector-php.xml ../refman-common/connector-vstudioplugin.xml ../refman-common/credits.xml ../refman-common/images/cmxj-overview.png ../refman-common/images/cnet-win-install-step1.png ../refman-common/images/cnet-win-install-step2.png ../refman-common/images/cnet-win-install-step3.png ../refman-common/images/cnet-win-install-step4.png ../refman-common/images/myaccess-odbc.png ../refman-common/images/myaccess.png ../refman-common/images/myarchitecture.png ../refman-common/images/myflowchart.png ../refman-common/images/myodbc-crystal-1.png ../refman-common/images/myodbc-crystal-2.png ../refman-common/images/myodbc-crystal-3.png ../refman-common/images/myodbc-crystal-4.png ../refman-common/images/myodbc-crystal-5.png ../refman-common/images/myod!
bc-crystal-6.png ../refman-common/images/myodbc-excel-step1.png ../refman-common/images/myodbc-excel-step2.png ../refman-common/images/myodbc-excel-step3.png ../refman-common/images/myodbc-excel-step4.png ../refman-common/images/myodbc-excel-step5.png ../refman-common/images/myodbc-link-step1.png ../refman-common/images/myodbc-link-step3.png ../refman-common/images/myodbc-link-step4.png ../refman-common/images/myodbc-link-step5.png ../refman-common/images/myodbc-macosx-install-step1.png ../refman-common/images/myodbc-macosx-install-step2.png ../refman-common/images/myodbc-macosx-install-step3.png ../refman-common/images/myodbc-macosx-install-step4.png ../refman-common/images/myodbc-macosx-install-step5.png ../refman-common/images/myodbc-macosx-install-step6.png ../refman-common/images/myodbc-macosx-odbcadmin-adddsn.png ../refman-common/images/myodbc-macosx-odbcadmin-main.png ../refman-common/images/myodbc-macosx-odbcadmin-sampledsn.png ../refman-common/images/myodbc-macosx-!
odbcadmin-tracing.png ../refman-common/images/myodbc-win-insta!
ll-step1
.png ../refman-common/images/myodbc-win-install-step2.png ../refman-common/images/myodbc-win-install-step3.png ../refman-common/images/myodbc-win-install-step4.png ../refman-common/images/myodbc-win-odbcadmin-adddsn.png ../refman-common/images/myodbc-win-odbcadmin-advanced.png ../refman-common/images/myodbc-win-odbcadmin-driverselect.png ../refman-common/images/myodbc-win-odbcadmin-main.png ../refman-common/images/myodbc-win-odbcadmin-options.png ../refman-common/images/myodbc-win-odbcadmin-sampledsn.png ../refman-common/images/myodbc-win-tracing.png ../refman-common/images/mysql-vstudioplugin-1.png ../refman-common/images/mysql-vstudioplugin-3.png ../refman-common/images/mysql-vstudioplugin-4.png ../refman-common/information-sources.xml ../refman-common/licenses.xml ../refman-common/manual-conventions.en.xml ../refman-common/maxdb.en.xml ../refman-common/news-cluster.xml ../refman-common/news-connector-j.xml ../refman-common/news-connector-net.xml ../refman-common/news-myod!
bc.xml ../refman-common/news-vstudioplugin.xml ../refman-common/what-is-mysql-ab.en.xml ../refman-common/what-is.en.xml apis-c.xml apis.xml charset.xml client-utility-programs.xml config-wizard.xml connectors.xml copyright.xml data-types.xml database-administration.xml dba-optvars-table.xml errmsgs-client.xml errmsgs-server.xml errors-problems.xml extending-mysql.xml faqs.xml functions.xml images/blackhole-1.png images/cluster-components-1.png images/cluster-upgrade-downgrade-table.png images/multi-comp-1.png images/mysql-cfg-fig1.png images/mysql-cfg-fig10.png images/mysql-cfg-fig2.png images/mysql-cfg-fig3.png images/mysql-cfg-fig4.png images/mysql-cfg-fig5.png images/mysql-cfg-fig6.png images/mysql-cfg-fig7.png images/mysql-cfg-fig8.png images/mysql-cfg-fig9.png images/mysql-esi-linux-fig1.png images/mysql-esi-merlin-1.png images/mysql-esi-merlin-10.png images/mysql-esi-merlin-11.png images/mysql-esi-merlin-12.png images/mysql-esi-merlin-13.png images/mysql-esi-merlin-2.!
png images/mysql-esi-merlin-3.png images/mysql-esi-merlin-4.pn!
g images
/mysql-esi-merlin-5.png images/mysql-esi-merlin-6.png images/mysql-esi-merlin-7.png images/mysql-esi-merlin-8.png images/mysql-esi-merlin-9.png images/mysql-esi-win32-fig1.png images/mysql-esi-win32-fig2.png images/mysql-esi-win32-fig3.png images/mysql-esi-win32-fig4.png images/mysql-esi-win32-fig6.png images/mysql-esi-win32-fig7.png images/mysql-esi-win32-uninst.png images/ndb-size-pl-1.png images/replicas-groups-1-1.png images/replicas-groups-1-2.png images/rolling-restarts.png information-schema.xml installing-cs.xml installing-es.xml installing-version.xml installing.xml introduction.xml language-structure.xml legalnotice.en.xml mysql-cluster.xml news-5.0.xml news.xml optimization.xml precision-math.xml preface.xml releasenotes-cs-5.0.xml releasenotes-cs.xml releasenotes-es-5.0.xml releasenotes-es.xml replication.xml reserved-new-5.0.xml reservedwords.xml restrictions.xml se-archive.xml se-bdb.xml se-blackhole.xml se-csv.xml se-example.xml se-federated.xml se-innodb.xml !
se-memory.xml se-merge.xml se-myisam.xml spatial-extensions.xml sql-syntax.xml storage-engines.xml stored-procedures.xml triggers.xml tutorial.xml using-mysql-programs.xml views.xml
manual-prepped.xml: $(MANUAL_SRCS) $(IDMAP_OBJS)
manual-manprepped.xml: $(MANUAL_SRCS) $(IDMAP_OBJS)
Modified: trunk/refman-5.0/faqs.xml
===================================================================
--- trunk/refman-5.0/faqs.xml 2007-03-01 12:23:04 UTC (rev 5128)
+++ trunk/refman-5.0/faqs.xml 2007-03-01 13:43:34 UTC (rev 5129)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 444 bytes
@@ -11,7 +11,7 @@
]>
<appendix id="faqs">
- <title>Frequently Asked Questions About MySQL ¤t-series;</title>
+ <title>MySQL ¤t-series; Frequently Asked Questions</title>
<section id="faqs-general">
Modified: trunk/refman-5.0/functions.xml
===================================================================
--- trunk/refman-5.0/functions.xml 2007-03-01 12:23:04 UTC (rev 5128)
+++ trunk/refman-5.0/functions.xml 2007-03-01 13:43:34 UTC (rev 5129)
Changed blocks: 1, Lines Added: 468, Lines Deleted: 0; 16344 bytes
@@ -4549,6 +4549,474 @@
</section>
+<section id="regexp">
+
+ <title>Regular Expressions</title>
+
+ <indexterm>
+ <primary>REGEXP operator</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>pattern matching</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>regular expression syntax</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>syntax</primary>
+ <secondary>regular expression</secondary>
+ </indexterm>
+
+ <para>
+ A regular expression is a powerful way of specifying a pattern for a
+ complex search.
+ </para>
+
+ <para>
+ MySQL uses Henry Spencer's implementation of regular expressions,
+ which is aimed at conformance with POSIX 1003.2. See
+ <xref linkend="credits"/>. MySQL uses the extended version to
+ support pattern-matching operations performed with the
+ <literal>REGEXP</literal> operator in SQL statements. See
+ <xref linkend="pattern-matching"/>, and
+ <xref linkend="string-comparison-functions"/>.
+ </para>
+
+ <para>
+ This section is a summary, with examples, of the special characters
+ and constructs that can be used in MySQL for
+ <literal>REGEXP</literal> operations. It does not contain all the
+ details that can be found in Henry Spencer's
+ <literal>regex(7)</literal> manual page. That manual page is
+ included in MySQL source distributions, in the
+ <filename>regex.7</filename> file under the
+ <filename>regex</filename> directory.
+ </para>
+
+ <para>
+ A regular expression describes a set of strings. The simplest
+ regular expression is one that has no special characters in it. For
+ example, the regular expression <literal>hello</literal> matches
+ <literal>hello</literal> and nothing else.
+ </para>
+
+ <para>
+ Non-trivial regular expressions use certain special constructs so
+ that they can match more than one string. For example, the regular
+ expression <literal>hello|word</literal> matches either the string
+ <literal>hello</literal> or the string <literal>word</literal>.
+ </para>
+
+ <para>
+ As a more complex example, the regular expression
+ <literal>B[an]*s</literal> matches any of the strings
+ <literal>Bananas</literal>, <literal>Baaaaas</literal>,
+ <literal>Bs</literal>, and any other string starting with a
+ <literal>B</literal>, ending with an <literal>s</literal>, and
+ containing any number of <literal>a</literal> or
+ <literal>n</literal> characters in between.
+ </para>
+
+ <para>
+ A regular expression for the <literal>REGEXP</literal> operator may
+ use any of the following special characters and constructs:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>^</literal>
+ </para>
+
+ <para>
+ Match the beginning of a string.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'fo\nfo' REGEXP '^fo$';</userinput> -> 0
+mysql> <userinput>SELECT 'fofo' REGEXP '^fo';</userinput> -> 1
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>$</literal>
+ </para>
+
+ <para>
+ Match the end of a string.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'fo\no' REGEXP '^fo\no$';</userinput> -> 1
+mysql> <userinput>SELECT 'fo\no' REGEXP '^fo$';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>.</literal>
+ </para>
+
+ <para>
+ Match any character (including carriage return and newline).
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'fofo' REGEXP '^f.*$';</userinput> -> 1
+mysql> <userinput>SELECT 'fo\r\nfo' REGEXP '^f.*$';</userinput> -> 1
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>a*</literal>
+ </para>
+
+ <para>
+ Match any sequence of zero or more <literal>a</literal>
+ characters.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'Ban' REGEXP '^Ba*n';</userinput> -> 1
+mysql> <userinput>SELECT 'Baaan' REGEXP '^Ba*n';</userinput> -> 1
+mysql> <userinput>SELECT 'Bn' REGEXP '^Ba*n';</userinput> -> 1
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>a+</literal>
+ </para>
+
+ <para>
+ Match any sequence of one or more <literal>a</literal>
+ characters.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'Ban' REGEXP '^Ba+n';</userinput> -> 1
+mysql> <userinput>SELECT 'Bn' REGEXP '^Ba+n';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>a?</literal>
+ </para>
+
+ <para>
+ Match either zero or one <literal>a</literal> character.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'Bn' REGEXP '^Ba?n';</userinput> -> 1
+mysql> <userinput>SELECT 'Ban' REGEXP '^Ba?n';</userinput> -> 1
+mysql> <userinput>SELECT 'Baan' REGEXP '^Ba?n';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>de|abc</literal>
+ </para>
+
+ <para>
+ Match either of the sequences <literal>de</literal> or
+ <literal>abc</literal>.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'pi' REGEXP 'pi|apa';</userinput> -> 1
+mysql> <userinput>SELECT 'axe' REGEXP 'pi|apa';</userinput> -> 0
+mysql> <userinput>SELECT 'apa' REGEXP 'pi|apa';</userinput> -> 1
+mysql> <userinput>SELECT 'apa' REGEXP '^(pi|apa)$';</userinput> -> 1
+mysql> <userinput>SELECT 'pi' REGEXP '^(pi|apa)$';</userinput> -> 1
+mysql> <userinput>SELECT 'pix' REGEXP '^(pi|apa)$';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>(abc)*</literal>
+ </para>
+
+ <para>
+ Match zero or more instances of the sequence
+ <literal>abc</literal>.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'pi' REGEXP '^(pi)*$';</userinput> -> 1
+mysql> <userinput>SELECT 'pip' REGEXP '^(pi)*$';</userinput> -> 0
+mysql> <userinput>SELECT 'pipi' REGEXP '^(pi)*$';</userinput> -> 1
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>{1}</literal>, <literal>{2,3}</literal>
+ </para>
+
+ <para>
+ <literal>{n}</literal> or <literal>{m,n}</literal> notation
+ provides a more general way of writing regular expressions that
+ match many occurrences of the previous atom (or
+ <quote>piece</quote>) of the pattern. <literal>m</literal> and
+ <literal>n</literal> are integers.
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>a*</literal>
+ </para>
+
+ <para>
+ Can be written as <literal>a{0,}</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>a+</literal>
+ </para>
+
+ <para>
+ Can be written as <literal>a{1,}</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>a?</literal>
+ </para>
+
+ <para>
+ Can be written as <literal>a{0,1}</literal>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ To be more precise, <literal>a{n}</literal> matches exactly
+ <literal>n</literal> instances of <literal>a</literal>.
+ <literal>a{n,}</literal> matches <literal>n</literal> or more
+ instances of <literal>a</literal>. <literal>a{m,n}</literal>
+ matches <literal>m</literal> through <literal>n</literal>
+ instances of <literal>a</literal>, inclusive.
+ </para>
+
+ <para>
+ <literal>m</literal> and <literal>n</literal> must be in the
+ range from <literal>0</literal> to <literal>RE_DUP_MAX</literal>
+ (default 255), inclusive. If both <literal>m</literal> and
+ <literal>n</literal> are given, <literal>m</literal> must be
+ less than or equal to <literal>n</literal>.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'abcde' REGEXP 'a[bcd]{2}e';</userinput> -> 0
+mysql> <userinput>SELECT 'abcde' REGEXP 'a[bcd]{3}e';</userinput> -> 1
+mysql> <userinput>SELECT 'abcde' REGEXP 'a[bcd]{1,10}e';</userinput> -> 1
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>[a-dX]</literal>, <literal>[^a-dX]</literal>
+ </para>
+
+ <para>
+ Matches any character that is (or is not, if ^ is used) either
+ <literal>a</literal>, <literal>b</literal>,
+ <literal>c</literal>, <literal>d</literal> or
+ <literal>X</literal>. A <literal>-</literal> character between
+ two other characters forms a range that matches all characters
+ from the first character to the second. For example,
+ <literal>[0-9]</literal> matches any decimal digit. To include a
+ literal <literal>]</literal> character, it must immediately
+ follow the opening bracket <literal>[</literal>. To include a
+ literal <literal>-</literal> character, it must be written first
+ or last. Any character that does not have a defined special
+ meaning inside a <literal>[]</literal> pair matches only itself.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'aXbc' REGEXP '[a-dXYZ]';</userinput> -> 1
+mysql> <userinput>SELECT 'aXbc' REGEXP '^[a-dXYZ]$';</userinput> -> 0
+mysql> <userinput>SELECT 'aXbc' REGEXP '^[a-dXYZ]+$';</userinput> -> 1
+mysql> <userinput>SELECT 'aXbc' REGEXP '^[^a-dXYZ]+$';</userinput> -> 0
+mysql> <userinput>SELECT 'gheis' REGEXP '^[^a-dXYZ]+$';</userinput> -> 1
+mysql> <userinput>SELECT 'gheisa' REGEXP '^[^a-dXYZ]+$';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>[.characters.]</literal>
+ </para>
+
+ <para>
+ Within a bracket expression (written using <literal>[</literal>
+ and <literal>]</literal>), matches the sequence of characters of
+ that collating element. <literal>characters</literal> is either
+ a single character or a character name like
+ <literal>newline</literal>. You can find the full list of
+ character names in the <filename>regexp/cname.h</filename> file.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT '~' REGEXP '[[.~.]]';</userinput> -> 1
+mysql> <userinput>SELECT '~' REGEXP '[[.tilde.]]';</userinput> -> 1
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>[=character_class=]</literal>
+ </para>
+
+ <para>
+ Within a bracket expression (written using <literal>[</literal>
+ and <literal>]</literal>),
+ <literal>[=character_class=]</literal> represents an equivalence
+ class. It matches all characters with the same collation value,
+ including itself. For example, if <literal>o</literal> and
+ <literal>(+)</literal> are the members of an equivalence class,
+ then <literal>[[=o=]]</literal>, <literal>[[=(+)=]]</literal>,
+ and <literal>[o(+)]</literal> are all synonymous. An equivalence
+ class may not be used as an endpoint of a range.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>[:character_class:]</literal>
+ </para>
+
+ <para>
+ Within a bracket expression (written using <literal>[</literal>
+ and <literal>]</literal>),
+ <literal>[:character_class:]</literal> represents a character
+ class that matches all characters belonging to that class. The
+ following table lists the standard class names. These names
+ stand for the character classes defined in the
+ <literal>ctype(3)</literal> manual page. A particular locale may
+ provide other class names. A character class may not be used as
+ an endpoint of a range.
+ </para>
+
+ <informaltable>
+ <tgroup cols="2">
+ <colspec colwidth="10*"/>
+ <colspec colwidth="90*"/>
+ <tbody>
+ <row>
+ <entry><literal>alnum</literal></entry>
+ <entry>Alphanumeric characters</entry>
+ </row>
+ <row>
+ <entry><literal>alpha</literal></entry>
+ <entry>Alphabetic characters</entry>
+ </row>
+ <row>
+ <entry><literal>blank</literal></entry>
+ <entry>Whitespace characters</entry>
+ </row>
+ <row>
+ <entry><literal>cntrl</literal></entry>
+ <entry>Control characters</entry>
+ </row>
+ <row>
+ <entry><literal>digit</literal></entry>
+ <entry>Digit characters</entry>
+ </row>
+ <row>
+ <entry><literal>graph</literal></entry>
+ <entry>Graphic characters</entry>
+ </row>
+ <row>
+ <entry><literal>lower</literal></entry>
+ <entry>Lowercase alphabetic characters</entry>
+ </row>
+ <row>
+ <entry><literal>print</literal></entry>
+ <entry>Graphic or space characters</entry>
+ </row>
+ <row>
+ <entry><literal>punct</literal></entry>
+ <entry>Punctuation characters</entry>
+ </row>
+ <row>
+ <entry><literal>space</literal></entry>
+ <entry>Space, tab, newline, and carriage return</entry>
+ </row>
+ <row>
+ <entry><literal>upper</literal></entry>
+ <entry>Uppercase alphabetic characters</entry>
+ </row>
+ <row>
+ <entry><literal>xdigit</literal></entry>
+ <entry>Hexadecimal digit characters</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+<programlisting>
+mysql> <userinput>SELECT 'justalnums' REGEXP '[[:alnum:]]+';</userinput> -> 1
+mysql> <userinput>SELECT '!!' REGEXP '[[:alnum:]]+';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>[[:<:]]</literal>, <literal>[[:>:]]</literal>
+ </para>
+
+ <para>
+ These markers stand for word boundaries. They match the
+ beginning and end of words, respectively. A word is a sequence
+ of word characters that is not preceded by or followed by word
+ characters. A word character is an alphanumeric character in the
+ <literal>alnum</literal> class or an underscore
+ (<literal>_</literal>).
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 'a word a' REGEXP '[[:<:]]word[[:>:]]';</userinput> -> 1
+mysql> <userinput>SELECT 'a xword a' REGEXP '[[:<:]]word[[:>:]]';</userinput> -> 0
+</programlisting>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ To use a literal instance of a special character in a regular
+ expression, precede it by two backslash (\) characters. The MySQL
+ parser interprets one of the backslashes, and the regular expression
+ library interprets the other. For example, to match the string
+ <literal>1+2</literal> that contains the special
+ <literal>+</literal> character, only the last of the following
+ regular expressions is the correct one:
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT '1+2' REGEXP '1+2';</userinput> -> 0
+mysql> <userinput>SELECT '1+2' REGEXP '1\+2';</userinput> -> 0
+mysql> <userinput>SELECT '1+2' REGEXP '1\\+2';</userinput> -> 1
+</programlisting>
+
+</section>
+
</section>
<section id="numeric-functions">
Modified: trunk/refman-5.0/installing-cs.xml
===================================================================
--- trunk/refman-5.0/installing-cs.xml 2007-03-01 12:23:04 UTC (rev 5128)
+++ trunk/refman-5.0/installing-cs.xml 2007-03-01 13:43:34 UTC (rev 5129)
Changed blocks: 1, Lines Added: 358, Lines Deleted: 0; 10465 bytes
@@ -17353,6 +17353,364 @@
</section>
+<section id="environment-variables" role="cses">
+
+ <title>Environment Variables</title>
+
+ <indexterm>
+ <primary>environment variables</primary>
+ <secondary>list of</secondary>
+ </indexterm>
+
+ <para>
+ This section lists all the environment variables that are used
+ directly or indirectly by MySQL. Most of these can also be found in
+ other places in this manual.
+ </para>
+
+ <para>
+ Note that any options on the command line take precedence over
+ values specified in option files and environment variables, and
+ values in option files take precedence over values in environment
+ variables.
+ </para>
+
+ <para>
+ In many cases, it is preferable to use an option file instead of
+ environment variables to modify the behavior of MySQL. See
+ <xref linkend="option-files"/>.
+ </para>
+
+ <indexterm>
+ <primary>CXX environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>CXX</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>CC environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>CC</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>CFLAGS environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>CFLAGS</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>CXXFLAGS environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>CXXFLAGS</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>DBI_USER environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>DBI_USER</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>DBI_TRACE environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>DBI_TRACE</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>HOME environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>HOME</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>LD_RUN_PATH environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>LD_RUN_PATH</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_DEBUG environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_DEBUG</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_GROUP_SUFFIX environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_GROUP_SUFFIX</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_HISTFILE environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_HISTFILE</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_HOME environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_HOME</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_HOST environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_HOST</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_PS1 environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_PS1</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_PWD environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_PWD</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_TCP_PORT environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_TCP_PORT</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>MYSQL_UNIX_PORT environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>MYSQL_UNIX_PORT</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>PATH environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>PATH</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>TMPDIR environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>TMPDIR</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>TZ environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>TZ</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>UMASK_DIR environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>UMASK_DIR</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>UMASK environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>UMASK</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>USER environment variable</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>Environment variable</primary>
+ <secondary>USER</secondary>
+ </indexterm>
+
+ <informaltable>
+ <tgroup cols="2">
+ <colspec colwidth="25*"/>
+ <colspec colwidth="70*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Variable</emphasis></entry>
+ <entry><emphasis role="bold">Description</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>CXX</literal></entry>
+ <entry>The name of your C++ compiler (for running
+ <command>configure</command>).</entry>
+ </row>
+ <row>
+ <entry><literal>CC</literal></entry>
+ <entry>The name of your C compiler (for running <command>configure</command>).</entry>
+ </row>
+ <row>
+ <entry><literal>CFLAGS</literal></entry>
+ <entry>Flags for your C compiler (for running <command>configure</command>).</entry>
+ </row>
+ <row>
+ <entry><literal>CXXFLAGS</literal></entry>
+ <entry>Flags for your C++ compiler (for running <command>configure</command>).</entry>
+ </row>
+ <row>
+ <entry><literal>DBI_USER</literal></entry>
+ <entry>The default username for Perl DBI.</entry>
+ </row>
+ <row>
+ <entry><literal>DBI_TRACE</literal></entry>
+ <entry>Trace options for Perl DBI.</entry>
+ </row>
+ <row>
+ <entry><literal>HOME</literal></entry>
+ <entry>The default path for the <command>mysql</command> history file is
+ <filename>$HOME/.mysql_history</filename>.</entry>
+ </row>
+ <row>
+ <entry><literal>LD_RUN_PATH</literal></entry>
+ <entry>Used to specify the location of <filename>libmysqlclient.so</filename>.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_DEBUG</literal></entry>
+ <entry>Debug trace options when debugging.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_GROUP_SUFFIX</literal></entry>
+ <entry>Option group suffix value (like specifying
+ <option>--defaults-group-suffix</option>).</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_HISTFILE</literal></entry>
+ <entry>The path to the <command>mysql</command> history file. If this variable
+ is set, its value overrides the default for
+ <filename>$HOME/.mysql_history</filename>.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_HOME</literal></entry>
+ <entry>The path to the directory in which the server-specific
+ <filename>my.cnf</filename> file resides (as of MySQL
+ 5.0.3).</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_HOST</literal></entry>
+ <entry>The default hostname used by the <command>mysql</command> command-line
+ client.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_PS1</literal></entry>
+ <entry>The command prompt to use in the <command>mysql</command> command-line
+ client.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_PWD</literal></entry>
+ <entry>The default password when connecting to <command>mysqld</command>. Note
+ that using this is insecure. See
+ <xref linkend="password-security"/>.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_TCP_PORT</literal></entry>
+ <entry>The default TCP/IP port number.</entry>
+ </row>
+ <row>
+ <entry><literal>MYSQL_UNIX_PORT</literal></entry>
+ <entry>The default Unix socket filename; used for connections to
+ <literal>localhost</literal>.</entry>
+ </row>
+ <row>
+ <entry><literal>PATH</literal></entry>
+ <entry>Used by the shell to find MySQL programs.</entry>
+ </row>
+ <row>
+ <entry><literal>TMPDIR</literal></entry>
+ <entry>The directory where temporary files are created.</entry>
+ </row>
+ <row>
+ <entry><literal>TZ</literal></entry>
+ <entry>This should be set to your local time zone. See
+ <xref linkend="timezone-problems"/>.</entry>
+ </row>
+ <row>
+ <entry><literal>UMASK_DIR</literal></entry>
+ <entry>The user-directory creation mask when creating directories. Note that
+ this is <literal>AND</literal>ed with
+ <literal>UMASK</literal>.</entry>
+ </row>
+ <row>
+ <entry><literal>UMASK</literal></entry>
+ <entry>The user-file creation mask when creating files.</entry>
+ </row>
+ <row>
+ <entry><literal>USER</literal></entry>
+ <entry>The default username on Windows and NetWare used when connecting to
+ <command>mysqld</command>.</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+</section>
+
<section id="perl-support" role="cses">
<title>Perl Installation Notes</title>
Modified: trunk/refman-5.0/manual.xml
===================================================================
--- trunk/refman-5.0/manual.xml 2007-03-01 12:23:04 UTC (rev 5128)
+++ trunk/refman-5.0/manual.xml 2007-03-01 13:43:34 UTC (rev 5129)
Changed blocks: 2, Lines Added: 2, Lines Deleted: 12; 1568 bytes
@@ -107,10 +107,8 @@
<xi:include href="faqs.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
- <xi:include href="problems.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
+ <xi:include href="errors-problems.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
- <xi:include href="error-handling.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
-
<xi:include href="releasenotes-es.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<xi:include href="releasenotes-cs.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
@@ -119,16 +117,8 @@
<xi:include href="restrictions.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
- <xi:include href="porting.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
+ <xi:include href="../refman-common/licenses.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
- <xi:include href="../refman-common/environment-variables.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
-
- <xi:include href="../refman-common/regexp.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
-
- <xi:include href="../refman-common/gpl-license.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
-
- <xi:include href="../refman-common/mysql-floss-license-exception.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
-
<xi:include href="../refman-common/credits.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
<index/>
Modified: trunk/refman-5.0/renamed-nodes.txt
===================================================================
--- trunk/refman-5.0/renamed-nodes.txt 2007-03-01 12:23:04 UTC (rev 5128)
+++ trunk/refman-5.0/renamed-nodes.txt 2007-03-01 13:43:34 UTC (rev 5129)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 1411 bytes
@@ -641,3 +641,15 @@
stored-procedure-replication-faq faqs-stored-routines-triggers-replication
myodbc-examples-tools-tested myodbc-examples-tools
+porting http://dev.mysql.com/doc/internals/en/porting.html
+debugging-server http://dev.mysql.com/doc/internals/en/debugging-server
+compiling-for-debugging http://dev.mysql.com/doc/internals/en/compiling-for-debugging
+making-trace-files http://dev.mysql.com/doc/internals/en/making-trace-files
+using-gdb-on-mysqld http://dev.mysql.com/doc/internals/en/using-gdb-on-mysqld
+using-stack-trace http://dev.mysql.com/doc/internals/en/using-stack-trace
+using-log-files http://dev.mysql.com/doc/internals/en/using-log-files
+reproducible-test-case http://dev.mysql.com/doc/internals/en/reproducible-test-case
+debugging-client http://dev.mysql.com/doc/internals/en/debugging-client
+the-dbug-package http://dev.mysql.com/doc/internals/en/the-dbug-package
+rts-threads http://dev.mysql.com/doc/internals/en/rts-threads
+thread-packages http://dev.mysql.com/doc/internals/en/thread-packages
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5129 - trunk/refman-5.0 | mcbrown | 1 Mar |
