Author: paul
Date: 2008-04-22 16:20:45 +0200 (Tue, 22 Apr 2008)
New Revision: 10563
Log:
r30889@frost: paul | 2008-04-22 09:01:57 -0500
CREATE ... SELECT preserves:
- NULL/NOT NULL
- CHARACTER SET
- COLLATION
- COMMENT
- DEFAULT
Modified:
trunk/it/refman-5.1/sql-syntax.xml
trunk/pt/refman-5.1/sql-syntax.xml
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
trunk/refman-6.0/sql-syntax.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:30887
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30865
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:30889
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30865
Modified: trunk/it/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/it/refman-5.1/sql-syntax.xml 2008-04-22 13:32:35 UTC (rev 10562)
+++ trunk/it/refman-5.1/sql-syntax.xml 2008-04-22 14:20:45 UTC (rev 10563)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 883 bytes
@@ -5093,7 +5093,12 @@
Some conversion of data types might occur. For example, the
<literal>AUTO_INCREMENT</literal> attribute is not preserved,
and <literal>VARCHAR</literal> columns can become
- <literal>CHAR</literal> columns.
+ <literal>CHAR</literal> columns. Retrained attributes are
+ <literal>NULL</literal> (or <literal>NOT NULL</literal>) and,
+ for those columns that have them, <literal>CHARACTER
+ SET</literal>, <literal>COLLATION</literal>,
+ <literal>COMMENT</literal>, and the <literal>DEFAULT</literal>
+ clause.
</para>
<para>
Modified: trunk/pt/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/pt/refman-5.1/sql-syntax.xml 2008-04-22 13:32:35 UTC (rev 10562)
+++ trunk/pt/refman-5.1/sql-syntax.xml 2008-04-22 14:20:45 UTC (rev 10563)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 883 bytes
@@ -5093,7 +5093,12 @@
Some conversion of data types might occur. For example, the
<literal>AUTO_INCREMENT</literal> attribute is not preserved,
and <literal>VARCHAR</literal> columns can become
- <literal>CHAR</literal> columns.
+ <literal>CHAR</literal> columns. Retrained attributes are
+ <literal>NULL</literal> (or <literal>NOT NULL</literal>) and,
+ for those columns that have them, <literal>CHARACTER
+ SET</literal>, <literal>COLLATION</literal>,
+ <literal>COMMENT</literal>, and the <literal>DEFAULT</literal>
+ clause.
</para>
<para>
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2008-04-22 13:32:35 UTC (rev 10562)
+++ trunk/refman-4.1/sql-syntax.xml 2008-04-22 14:20:45 UTC (rev 10563)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 874 bytes
@@ -2984,7 +2984,12 @@
Some conversion of data types might occur. For example, the
<literal>AUTO_INCREMENT</literal> attribute is not preserved,
and <literal>VARCHAR</literal> columns can become
- <literal>CHAR</literal> columns.
+ <literal>CHAR</literal> columns. Retrained attributes are
+ <literal>NULL</literal> (or <literal>NOT NULL</literal>) and,
+ for those columns that have them, <literal>CHARACTER
+ SET</literal>, <literal>COLLATION</literal>,
+ <literal>COMMENT</literal>, and the <literal>DEFAULT</literal>
+ clause.
</para>
<para>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2008-04-22 13:32:35 UTC (rev 10562)
+++ trunk/refman-5.0/sql-syntax.xml 2008-04-22 14:20:45 UTC (rev 10563)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 874 bytes
@@ -3064,7 +3064,12 @@
Some conversion of data types might occur. For example, the
<literal>AUTO_INCREMENT</literal> attribute is not preserved,
and <literal>VARCHAR</literal> columns can become
- <literal>CHAR</literal> columns.
+ <literal>CHAR</literal> columns. Retrained attributes are
+ <literal>NULL</literal> (or <literal>NOT NULL</literal>) and,
+ for those columns that have them, <literal>CHARACTER
+ SET</literal>, <literal>COLLATION</literal>,
+ <literal>COMMENT</literal>, and the <literal>DEFAULT</literal>
+ clause.
</para>
<para>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2008-04-22 13:32:35 UTC (rev 10562)
+++ trunk/refman-5.1/sql-syntax.xml 2008-04-22 14:20:45 UTC (rev 10563)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 874 bytes
@@ -5103,7 +5103,12 @@
Some conversion of data types might occur. For example, the
<literal>AUTO_INCREMENT</literal> attribute is not preserved,
and <literal>VARCHAR</literal> columns can become
- <literal>CHAR</literal> columns.
+ <literal>CHAR</literal> columns. Retrained attributes are
+ <literal>NULL</literal> (or <literal>NOT NULL</literal>) and,
+ for those columns that have them, <literal>CHARACTER
+ SET</literal>, <literal>COLLATION</literal>,
+ <literal>COMMENT</literal>, and the <literal>DEFAULT</literal>
+ clause.
</para>
<para>
Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml 2008-04-22 13:32:35 UTC (rev 10562)
+++ trunk/refman-6.0/sql-syntax.xml 2008-04-22 14:20:45 UTC (rev 10563)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 874 bytes
@@ -5017,7 +5017,12 @@
Some conversion of data types might occur. For example, the
<literal>AUTO_INCREMENT</literal> attribute is not preserved,
and <literal>VARCHAR</literal> columns can become
- <literal>CHAR</literal> columns.
+ <literal>CHAR</literal> columns. Retrained attributes are
+ <literal>NULL</literal> (or <literal>NOT NULL</literal>) and,
+ for those columns that have them, <literal>CHARACTER
+ SET</literal>, <literal>COLLATION</literal>,
+ <literal>COMMENT</literal>, and the <literal>DEFAULT</literal>
+ clause.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10563 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 22 Apr |
