List:Commits« Previous MessageNext Message »
From:paul Date:February 13 2008 5:25pm
Subject:svn commit - mysqldoc@docsrva: r9822 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0
View as plain text  
Author: paul
Date: 2008-02-13 18:25:22 +0100 (Wed, 13 Feb 2008)
New Revision: 9822

Log:
 r29156@frost:  paul | 2008-02-13 10:59:41 -0600
 CSV tables cannot store NULL, so update CREATE TABLE examples to add
 NOT NULL. (pcrews)


Modified:
   trunk/refman-4.1/storage-engines.xml
   trunk/refman-5.0/se-csv.xml
   trunk/refman-5.1/se-csv.xml
   trunk/refman-6.0/se-csv.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29155
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29195
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29156
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29195


Modified: trunk/refman-4.1/storage-engines.xml
===================================================================
--- trunk/refman-4.1/storage-engines.xml	2008-02-13 17:25:05 UTC (rev 9821)
+++ trunk/refman-4.1/storage-engines.xml	2008-02-13 17:25:22 UTC (rev 9822)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 663 bytes

@@ -3781,7 +3781,8 @@
     </para>
 
 <programlisting>
-mysql&gt; <userinput>CREATE TABLE test(i INT, c CHAR(10)) ENGINE = CSV;</userinput>
+mysql&gt; <userinput>CREATE TABLE test (i INT NOT NULL, c CHAR(10) NOT NULL)</userinput>
+    -&gt; <userinput>ENGINE = CSV;</userinput>
 Query OK, 0 rows affected (0.12 sec)
 
 mysql&gt; <userinput>INSERT INTO test VALUES(1,'record one'),(2,'record two');</userinput>


Modified: trunk/refman-5.0/se-csv.xml
===================================================================
--- trunk/refman-5.0/se-csv.xml	2008-02-13 17:25:05 UTC (rev 9821)
+++ trunk/refman-5.0/se-csv.xml	2008-02-13 17:25:22 UTC (rev 9822)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 630 bytes

@@ -48,7 +48,8 @@
   </para>
 
 <programlisting>
-mysql&gt; <userinput>CREATE TABLE test(i INT, c CHAR(10)) ENGINE = CSV;</userinput>
+mysql&gt; <userinput>CREATE TABLE test (i INT NOT NULL, c CHAR(10) NOT NULL)</userinput>
+    -&gt; <userinput>ENGINE = CSV;</userinput>
 Query OK, 0 rows affected (0.12 sec)
 
 mysql&gt; <userinput>INSERT INTO test VALUES(1,'record one'),(2,'record two');</userinput>


Modified: trunk/refman-5.1/se-csv.xml
===================================================================
--- trunk/refman-5.1/se-csv.xml	2008-02-13 17:25:05 UTC (rev 9821)
+++ trunk/refman-5.1/se-csv.xml	2008-02-13 17:25:22 UTC (rev 9822)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 630 bytes

@@ -45,7 +45,8 @@
   </para>
 
 <programlisting>
-mysql&gt; <userinput>CREATE TABLE test(i INT, c CHAR(10)) ENGINE = CSV;</userinput>
+mysql&gt; <userinput>CREATE TABLE test (i INT NOT NULL, c CHAR(10) NOT NULL)</userinput>
+    -&gt; <userinput>ENGINE = CSV;</userinput>
 Query OK, 0 rows affected (0.12 sec)
 
 mysql&gt; <userinput>INSERT INTO test VALUES(1,'record one'),(2,'record two');</userinput>


Modified: trunk/refman-6.0/se-csv.xml
===================================================================
--- trunk/refman-6.0/se-csv.xml	2008-02-13 17:25:05 UTC (rev 9821)
+++ trunk/refman-6.0/se-csv.xml	2008-02-13 17:25:22 UTC (rev 9822)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 630 bytes

@@ -45,7 +45,8 @@
   </para>
 
 <programlisting>
-mysql&gt; <userinput>CREATE TABLE test(i INT, c CHAR(10)) ENGINE = CSV;</userinput>
+mysql&gt; <userinput>CREATE TABLE test (i INT NOT NULL, c CHAR(10) NOT NULL)</userinput>
+    -&gt; <userinput>ENGINE = CSV;</userinput>
 Query OK, 0 rows affected (0.12 sec)
 
 mysql&gt; <userinput>INSERT INTO test VALUES(1,'record one'),(2,'record two');</userinput>
Thread
• svn commit - mysqldoc@docsrva: r9822 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0paul13 Feb