svn commit - mysqldoc@docsrva: r9978 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0

[paul]

Author: paul
Date: 2008-02-22 19:49:56 +0100 (Fri, 22 Feb 2008)
New Revision: 9978

Log:
 r29577@arctic:  paul | 2008-02-22 11:52:13 -0600
 Add some statements that are allowed for SQLPS (Noticed by PeterG, confirmed
 by Konstantin)
 Remove RENAME DATABASE from the list (PeterG)


Modified:
   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:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29435
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29561
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29435
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29577


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2008-02-22 15:27:18 UTC (rev 9977)
+++ trunk/refman-4.1/sql-syntax.xml	2008-02-22 18:49:56 UTC (rev 9978)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 2; 996 bytes

@@ -20728,8 +20728,11 @@
 
     <para>
       The following SQL statements can be used in prepared statements:
-      <literal>CREATE TABLE</literal>, <literal>DELETE</literal>,
-      <literal>DO</literal>, <literal>INSERT</literal>,
+      <literal>ALTER TABLE</literal> <literal>COMMIT</literal>
+      <literal>CREATE INDEX</literal> <literal>CREATE
TABLE</literal>,
+      <literal>DELETE</literal>, <literal>DO</literal>,
<literal>DROP
+      INDEX</literal> <literal>DROP TABLE</literal>
+      <literal>INSERT</literal>, <literal>RENAME TABLE</literal>
       <literal>REPLACE</literal>, <literal>SELECT</literal>,
       <literal>SET</literal>, <literal>UPDATE</literal>, and most
       <literal>SHOW</literal> statements. Other statements are not yet


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2008-02-22 15:27:18 UTC (rev 9977)
+++ trunk/refman-5.0/sql-syntax.xml	2008-02-22 18:49:56 UTC (rev 9978)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 2; 983 bytes

@@ -23771,8 +23771,11 @@
 
     <para>
       The following SQL statements can be used in prepared statements:
-      <literal>CREATE TABLE</literal>, <literal>DELETE</literal>,
-      <literal>DO</literal>, <literal>INSERT</literal>,
+      <literal>ALTER TABLE</literal> <literal>COMMIT</literal>
+      <literal>CREATE INDEX</literal> <literal>CREATE
TABLE</literal>,
+      <literal>DELETE</literal>, <literal>DO</literal>,
<literal>DROP
+      INDEX</literal> <literal>DROP TABLE</literal>
+      <literal>INSERT</literal>, <literal>RENAME TABLE</literal>
       <literal>REPLACE</literal>, <literal>SELECT</literal>,
       <literal>SET</literal>, <literal>UPDATE</literal>, and most
       <literal>SHOW</literal> statements <literal>ANALYZE


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2008-02-22 15:27:18 UTC (rev 9977)
+++ trunk/refman-5.1/sql-syntax.xml	2008-02-22 18:49:56 UTC (rev 9978)
Changed blocks: 2, Lines Added: 6, Lines Deleted: 3; 1266 bytes

@@ -26658,8 +26658,11 @@
 
     <para>
       The following SQL statements can be used in prepared statements:
-      <literal>CREATE TABLE</literal>, <literal>DELETE</literal>,
-      <literal>DO</literal>, <literal>INSERT</literal>,
+      <literal>ALTER TABLE</literal> <literal>COMMIT</literal>
+      <literal>CREATE INDEX</literal> <literal>CREATE
TABLE</literal>,
+      <literal>DELETE</literal>, <literal>DO</literal>,
<literal>DROP
+      INDEX</literal> <literal>DROP TABLE</literal>
+      <literal>INSERT</literal>, <literal>RENAME TABLE</literal>
       <literal>REPLACE</literal>, <literal>SELECT</literal>,
       <literal>SET</literal>, <literal>UPDATE</literal>, and most
       <literal>SHOW</literal> statements.

@@ -26685,7 +26688,7 @@
 CACHE INDEX
 CHANGE MASTER
 CHECKSUM {TABLE | TABLES}
-{CREATE | RENAME | DROP} DATABASE
+{CREATE | DROP} DATABASE
 {CREATE | RENAME | DROP} USER
 FLUSH {TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES
   | LOGS | STATUS | MASTER | SLAVE | DES_KEY_FILE | USER_RESOURCES}


Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml	2008-02-22 15:27:18 UTC (rev 9977)
+++ trunk/refman-6.0/sql-syntax.xml	2008-02-22 18:49:56 UTC (rev 9978)
Changed blocks: 2, Lines Added: 7, Lines Deleted: 1; 871 bytes

@@ -26477,15 +26477,20 @@
       The following SQL statements can be used in prepared statements:
 
 <programlisting>
+ALTER TABLE
 ANALYZE TABLE
 CACHE INDEX
 CHANGE MASTER
 CHECKSUM {TABLE | TABLES}
-{CREATE | RENAME | DROP} DATABASE
+COMMIT
+{CREATE | DROP} DATABASE
 {CREATE | RENAME | DROP} USER
+CREATE INDEX
 CREATE TABLE
 DELETE
 DO
+DROP INDEX
+DROP TABLE
 FLUSH {TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES
   | LOGS | STATUS | MASTER | SLAVE | DES_KEY_FILE | USER_RESOURCES}
 GRANT

@@ -26494,6 +26499,7 @@
 KILL
 LOAD INDEX INTO CACHE
 OPTIMIZE TABLE
+RENAME TABLE
 REPAIR TABLE
 REPLACE
 RESET {MASTER | SLAVE | QUERY CACHE}