Author: paul
Date: 2008-06-12 18:53:15 +0200 (Thu, 12 Jun 2008)
New Revision: 10943
Log:
r31980@frost: paul | 2008-06-12 11:48:01 -0500
Aliases may be quoted as identifiers or as strings.
(Bug#35863)
Modified:
trunk/it/refman-5.1/language-structure-core.xml
trunk/pt/refman-5.1/language-structure-core.xml
trunk/refman-4.1/language-structure.xml
trunk/refman-5.0/language-structure-core.xml
trunk/refman-5.1/language-structure-core.xml
trunk/refman-6.0/language-structure-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31979
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31653
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31980
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31653
Modified: trunk/it/refman-5.1/language-structure-core.xml
===================================================================
--- trunk/it/refman-5.1/language-structure-core.xml 2008-06-12 16:53:08 UTC (rev 10942)
+++ trunk/it/refman-5.1/language-structure-core.xml 2008-06-12 16:53:15 UTC (rev 10943)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1119 bytes
@@ -917,9 +917,6 @@
interpret double-quoted strings as identifiers. Consequently, when
this mode is enabled, string literals must be enclosed within
single quotes. They cannot be enclosed within double quotes.
- </para>
-
- <para>
The server SQL mode is controlled as described in
<xref linkend="server-sql-mode"/>.
</para>
@@ -937,6 +934,19 @@
mysql> <userinput>CREATE TABLE `a``b` (`c"d` INT);</userinput>
</programlisting>
+<para>
+Aliases may be quoted either as identifiers or as strings:
+</para>
+
+<programlisting>
+mysql> <userinput>SELECT 1 AS `one`, 2 AS 'two';</userinput>
++-----+-----+
+| one | two |
++-----+-----+
+| 1 | 2 |
++-----+-----+
+</programlisting>
+
<para>
Identifiers may begin with a digit but unless quoted may not
consist solely of digits.
Modified: trunk/pt/refman-5.1/language-structure-core.xml
===================================================================
--- trunk/pt/refman-5.1/language-structure-core.xml 2008-06-12 16:53:08 UTC (rev 10942)
+++ trunk/pt/refman-5.1/language-structure-core.xml 2008-06-12 16:53:15 UTC (rev 10943)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1119 bytes
@@ -917,9 +917,6 @@
interpret double-quoted strings as identifiers. Consequently, when
this mode is enabled, string literals must be enclosed within
single quotes. They cannot be enclosed within double quotes.
- </para>
-
- <para>
The server SQL mode is controlled as described in
<xref linkend="server-sql-mode"/>.
</para>
@@ -937,6 +934,19 @@
mysql> <userinput>CREATE TABLE `a``b` (`c"d` INT);</userinput>
</programlisting>
+<para>
+Aliases may be quoted either as identifiers or as strings:
+</para>
+
+<programlisting>
+mysql> <userinput>SELECT 1 AS `one`, 2 AS 'two';</userinput>
++-----+-----+
+| one | two |
++-----+-----+
+| 1 | 2 |
++-----+-----+
+</programlisting>
+
<para>
Identifiers may begin with a digit but unless quoted may not
consist solely of digits.
Modified: trunk/refman-4.1/language-structure.xml
===================================================================
--- trunk/refman-4.1/language-structure.xml 2008-06-12 16:53:08 UTC (rev 10942)
+++ trunk/refman-4.1/language-structure.xml 2008-06-12 16:53:15 UTC (rev 10943)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1141 bytes
@@ -854,9 +854,6 @@
interpret double-quoted strings as identifiers. Consequently, when
this mode is enabled, string literals must be enclosed within
single quotes. They cannot be enclosed within double quotes.
- </para>
-
- <para>
The server SQL mode is controlled as described in
<xref linkend="server-sql-mode"/>.
</para>
@@ -874,6 +871,19 @@
mysql> <userinput>CREATE TABLE `a``b` (`c"d` INT);</userinput>
</programlisting>
+<para>
+Aliases may be quoted either as identifiers or as strings:
+</para>
+
+<programlisting>
+mysql> <userinput>SELECT 1 AS `one`, 2 AS 'two';</userinput>
++-----+-----+
+| one | two |
++-----+-----+
+| 1 | 2 |
++-----+-----+
+</programlisting>
+
<para>
Identifier quoting was introduced in MySQL 3.23.6 to allow use of
identifiers that contain special characters or are reserved words.
Modified: trunk/refman-5.0/language-structure-core.xml
===================================================================
--- trunk/refman-5.0/language-structure-core.xml 2008-06-12 16:53:08 UTC (rev 10942)
+++ trunk/refman-5.0/language-structure-core.xml 2008-06-12 16:53:15 UTC (rev 10943)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1110 bytes
@@ -918,9 +918,6 @@
interpret double-quoted strings as identifiers. Consequently, when
this mode is enabled, string literals must be enclosed within
single quotes. They cannot be enclosed within double quotes.
- </para>
-
- <para>
The server SQL mode is controlled as described in
<xref linkend="server-sql-mode"/>.
</para>
@@ -938,6 +935,19 @@
mysql> <userinput>CREATE TABLE `a``b` (`c"d` INT);</userinput>
</programlisting>
+<para>
+Aliases may be quoted either as identifiers or as strings:
+</para>
+
+<programlisting>
+mysql> <userinput>SELECT 1 AS `one`, 2 AS 'two';</userinput>
++-----+-----+
+| one | two |
++-----+-----+
+| 1 | 2 |
++-----+-----+
+</programlisting>
+
<para>
Identifiers may begin with a digit but unless quoted may not
consist solely of digits.
Modified: trunk/refman-5.1/language-structure-core.xml
===================================================================
--- trunk/refman-5.1/language-structure-core.xml 2008-06-12 16:53:08 UTC (rev 10942)
+++ trunk/refman-5.1/language-structure-core.xml 2008-06-12 16:53:15 UTC (rev 10943)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1110 bytes
@@ -918,9 +918,6 @@
interpret double-quoted strings as identifiers. Consequently, when
this mode is enabled, string literals must be enclosed within
single quotes. They cannot be enclosed within double quotes.
- </para>
-
- <para>
The server SQL mode is controlled as described in
<xref linkend="server-sql-mode"/>.
</para>
@@ -938,6 +935,19 @@
mysql> <userinput>CREATE TABLE `a``b` (`c"d` INT);</userinput>
</programlisting>
+<para>
+Aliases may be quoted either as identifiers or as strings:
+</para>
+
+<programlisting>
+mysql> <userinput>SELECT 1 AS `one`, 2 AS 'two';</userinput>
++-----+-----+
+| one | two |
++-----+-----+
+| 1 | 2 |
++-----+-----+
+</programlisting>
+
<para>
Identifiers may begin with a digit but unless quoted may not
consist solely of digits.
Modified: trunk/refman-6.0/language-structure-core.xml
===================================================================
--- trunk/refman-6.0/language-structure-core.xml 2008-06-12 16:53:08 UTC (rev 10942)
+++ trunk/refman-6.0/language-structure-core.xml 2008-06-12 16:53:15 UTC (rev 10943)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 3; 1110 bytes
@@ -916,9 +916,6 @@
interpret double-quoted strings as identifiers. Consequently, when
this mode is enabled, string literals must be enclosed within
single quotes. They cannot be enclosed within double quotes.
- </para>
-
- <para>
The server SQL mode is controlled as described in
<xref linkend="server-sql-mode"/>.
</para>
@@ -936,6 +933,19 @@
mysql> <userinput>CREATE TABLE `a``b` (`c"d` INT);</userinput>
</programlisting>
+<para>
+Aliases may be quoted either as identifiers or as strings:
+</para>
+
+<programlisting>
+mysql> <userinput>SELECT 1 AS `one`, 2 AS 'two';</userinput>
++-----+-----+
+| one | two |
++-----+-----+
+| 1 | 2 |
++-----+-----+
+</programlisting>
+
<para>
Identifiers may begin with a digit but unless quoted may not
consist solely of digits.
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10943 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 12 Jun |
