List:Commits« Previous MessageNext Message »
From:paul Date:May 3 2006 6:01pm
Subject:svn commit - mysqldoc@docsrva: r2019 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-05-03 20:01:36 +0200 (Wed, 03 May 2006)
New Revision: 2019

Log:
 r7229@polar:  paul | 2006-05-03 12:57:24 -0500
 INSERT required for ANALYZE/OPTIMIZE/REPAIR TABLE. (Bug#15520)


Modified:
   trunk/
   trunk/refman-4.1/database-administration.xml
   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/database-administration.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/database-administration.xml
   trunk/refman-5.1/sql-syntax.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7227
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10071
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7229
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10071
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886

Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml	2006-05-03 17:05:20 UTC (rev 2018)
+++ trunk/refman-4.1/database-administration.xml	2006-05-03 18:01:36 UTC (rev 2019)
@@ -13465,7 +13465,10 @@
         The <literal>SELECT</literal>, <literal>INSERT</literal>,
         <literal>UPDATE</literal>, and <literal>DELETE</literal>
         privileges allow you to perform operations on rows in existing
-        tables in a database.
+        tables in a database. <literal>INSERT</literal> is also required
+        for the <literal>ANALYZE TABLE</literal>, <literal>OPTIMIZE
+        TABLE</literal>, and <literal>REPAIR TABLE</literal>
+        table-maintenance statements.
       </para>
 
       <para>

Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-05-03 17:05:20 UTC (rev 2018)
+++ trunk/refman-4.1/sql-syntax.xml	2006-05-03 18:01:36 UTC (rev 2019)
@@ -11725,6 +11725,11 @@
           something other than a constant.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>
@@ -12234,6 +12239,11 @@
           unused space and to defragment the data file.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>
@@ -12388,6 +12398,11 @@
           <xref linkend="archive-storage-engine"/>.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>

Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml	2006-05-03 17:05:20 UTC (rev 2018)
+++ trunk/refman-5.0/database-administration.xml	2006-05-03 18:01:36 UTC (rev 2019)
@@ -16164,7 +16164,10 @@
         The <literal>SELECT</literal>, <literal>INSERT</literal>,
         <literal>UPDATE</literal>, and <literal>DELETE</literal>
         privileges allow you to perform operations on rows in existing
-        tables in a database.
+        tables in a database. <literal>INSERT</literal> is also required
+        for the <literal>ANALYZE TABLE</literal>, <literal>OPTIMIZE
+        TABLE</literal>, and <literal>REPAIR TABLE</literal>
+        table-maintenance statements.
       </para>
 
       <para>

Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-05-03 17:05:20 UTC (rev 2018)
+++ trunk/refman-5.0/sql-syntax.xml	2006-05-03 18:01:36 UTC (rev 2019)
@@ -13155,6 +13155,11 @@
           something other than a constant.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>
@@ -13711,6 +13716,11 @@
           unused space and to defragment the data file.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>
@@ -13863,6 +13873,11 @@
           <xref linkend="archive-storage-engine"/>.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>

Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml	2006-05-03 17:05:20 UTC (rev 2018)
+++ trunk/refman-5.1/database-administration.xml	2006-05-03 18:01:36 UTC (rev 2019)
@@ -16226,7 +16226,10 @@
         The <literal>SELECT</literal>, <literal>INSERT</literal>,
         <literal>UPDATE</literal>, and <literal>DELETE</literal>
         privileges allow you to perform operations on rows in existing
-        tables in a database.
+        tables in a database. <literal>INSERT</literal> is also required
+        for the <literal>ANALYZE TABLE</literal>, <literal>OPTIMIZE
+        TABLE</literal>, and <literal>REPAIR TABLE</literal>
+        table-maintenance statements.
       </para>
 
       <para>

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-05-03 17:05:20 UTC (rev 2018)
+++ trunk/refman-5.1/sql-syntax.xml	2006-05-03 18:01:36 UTC (rev 2019)
@@ -14263,6 +14263,11 @@
           something other than a constant.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>
@@ -14818,6 +14823,11 @@
           unused space and to defragment the data file.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>
@@ -14970,6 +14980,11 @@
           <xref linkend="archive-storage-engine"/>.
         </para>
 
+        <para>
+          This statement requires <literal>SELECT</literal> and
+          <literal>INSERT</literal> privileges for the table.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>

Thread
svn commit - mysqldoc@docsrva: r2019 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul3 May