svn commit - mysqldoc@docsrva: r10709 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-5.0 refman-5.1 refman-6.0

[paul]

Author: paul
Date: 2008-05-10 20:13:03 +0200 (Sat, 10 May 2008)
New Revision: 10709

Log:
 r31302@frost:  paul | 2008-05-10 13:12:33 -0500
 Correct misworded effect of SHOW TRIGGERS


Modified:
   trunk/it/refman-5.1/sql-syntax.xml
   trunk/pt/refman-5.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:31289
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31182
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31302
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31182


Modified: trunk/it/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/it/refman-5.1/sql-syntax.xml	2008-05-09 20:13:28 UTC (rev 10708)
+++ trunk/it/refman-5.1/sql-syntax.xml	2008-05-10 18:13:03 UTC (rev 10709)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 6; 1425 bytes

@@ -23872,12 +23872,13 @@
 
         <para>
           <literal>SHOW TRIGGERS</literal> lists the triggers currently
-          defined on the MySQL server. This statement requires the
-          <literal>TRIGGER</literal> privilege (prior to MySQL 5.1.22,
-          it requires the <literal>SUPER</literal> privilege). The
-          <function role="sqlop">LIKE</function> clause, if present,
-          indicates which table names to match and causes the statement
-          to display triggers for those tables. The
+          defined for tables in a database (the default database unless
+          a <literal>FROM</literal> clause is given). This statement
+          requires the <literal>TRIGGER</literal> privilege (prior to
+          MySQL 5.1.22, it requires the <literal>SUPER</literal>
+          privilege). The <function role="sqlop">LIKE</function> clause,
+          if present, indicates which table names to match and causes
+          the statement to display triggers for those tables. The
           <literal>WHERE</literal> clause can be given to select rows
           using more general conditions, as discussed in
           <xref linkend="extended-show"/>.


Modified: trunk/pt/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/pt/refman-5.1/sql-syntax.xml	2008-05-09 20:13:28 UTC (rev 10708)
+++ trunk/pt/refman-5.1/sql-syntax.xml	2008-05-10 18:13:03 UTC (rev 10709)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 6; 1425 bytes

@@ -23872,12 +23872,13 @@
 
         <para>
           <literal>SHOW TRIGGERS</literal> lists the triggers currently
-          defined on the MySQL server. This statement requires the
-          <literal>TRIGGER</literal> privilege (prior to MySQL 5.1.22,
-          it requires the <literal>SUPER</literal> privilege). The
-          <function role="sqlop">LIKE</function> clause, if present,
-          indicates which table names to match and causes the statement
-          to display triggers for those tables. The
+          defined for tables in a database (the default database unless
+          a <literal>FROM</literal> clause is given). This statement
+          requires the <literal>TRIGGER</literal> privilege (prior to
+          MySQL 5.1.22, it requires the <literal>SUPER</literal>
+          privilege). The <function role="sqlop">LIKE</function> clause,
+          if present, indicates which table names to match and causes
+          the statement to display triggers for those tables. The
           <literal>WHERE</literal> clause can be given to select rows
           using more general conditions, as discussed in
           <xref linkend="extended-show"/>.


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2008-05-09 20:13:28 UTC (rev 10708)
+++ trunk/refman-5.0/sql-syntax.xml	2008-05-10 18:13:03 UTC (rev 10709)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 5; 1322 bytes

@@ -20945,11 +20945,13 @@
 
         <para>
           <literal>SHOW TRIGGERS</literal> lists the triggers currently
-          defined on the MySQL server. This statement requires the
-          <literal>SUPER</literal> privilege. It was implemented in
-          MySQL 5.0.10. The <function role="sqlop">LIKE</function>
-          clause, if present, indicates which table names to match and
-          causes the statement to display triggers for those tables. The
+          defined for tables in a database (the default database unless
+          a <literal>FROM</literal> clause is given). This statement
+          requires the <literal>SUPER</literal> privilege. It was
+          implemented in MySQL 5.0.10. The
+          <function role="sqlop">LIKE</function> clause, if present,
+          indicates which table names to match and causes the statement
+          to display triggers for those tables. The
           <literal>WHERE</literal> clause can be given to select rows
           using more general conditions, as discussed in
           <xref linkend="extended-show"/>.


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2008-05-09 20:13:28 UTC (rev 10708)
+++ trunk/refman-5.1/sql-syntax.xml	2008-05-10 18:13:03 UTC (rev 10709)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 6; 1416 bytes

@@ -23872,12 +23872,13 @@
 
         <para>
           <literal>SHOW TRIGGERS</literal> lists the triggers currently
-          defined on the MySQL server. This statement requires the
-          <literal>TRIGGER</literal> privilege (prior to MySQL 5.1.22,
-          it requires the <literal>SUPER</literal> privilege). The
-          <function role="sqlop">LIKE</function> clause, if present,
-          indicates which table names to match and causes the statement
-          to display triggers for those tables. The
+          defined for tables in a database (the default database unless
+          a <literal>FROM</literal> clause is given). This statement
+          requires the <literal>TRIGGER</literal> privilege (prior to
+          MySQL 5.1.22, it requires the <literal>SUPER</literal>
+          privilege). The <function role="sqlop">LIKE</function> clause,
+          if present, indicates which table names to match and causes
+          the statement to display triggers for those tables. The
           <literal>WHERE</literal> clause can be given to select rows
           using more general conditions, as discussed in
           <xref linkend="extended-show"/>.


Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml	2008-05-09 20:13:28 UTC (rev 10708)
+++ trunk/refman-6.0/sql-syntax.xml	2008-05-10 18:13:03 UTC (rev 10709)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 2; 879 bytes

@@ -24146,8 +24146,9 @@
 
         <para>
           <literal>SHOW TRIGGERS</literal> lists the triggers currently
-          defined on the MySQL server. This statement requires the
-          <literal>TRIGGER</literal> privilege. The
+          defined for tables in a database (the default database unless
+          a <literal>FROM</literal> clause is given). This statement
+          requires the <literal>TRIGGER</literal> privilege. The
           <function role="sqlop">LIKE</function> clause, if present,
           indicates which table names to match and causes the statement
           to display triggers for those tables. The