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

[paul]

Author: paul
Date: 2008-04-23 22:04:39 +0200 (Wed, 23 Apr 2008)
New Revision: 10571

Log:
 r30911@frost:  paul | 2008-04-23 14:36:06 -0500
 SHOW TRIGGERS LIKE <pat> matches table names, not trigger names. (dshrews)


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:30910
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30908
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:30911
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30908


Modified: trunk/it/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/it/refman-5.1/sql-syntax.xml	2008-04-23 20:04:27 UTC (rev 10570)
+++ trunk/it/refman-5.1/sql-syntax.xml	2008-04-23 20:04:39 UTC (rev 10571)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 837 bytes

@@ -23696,7 +23696,8 @@
           <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 trigger names to match. The
+          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-04-23 20:04:27 UTC (rev 10570)
+++ trunk/pt/refman-5.1/sql-syntax.xml	2008-04-23 20:04:39 UTC (rev 10571)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 837 bytes

@@ -23696,7 +23696,8 @@
           <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 trigger names to match. The
+          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-04-23 20:04:27 UTC (rev 10570)
+++ trunk/refman-5.0/sql-syntax.xml	2008-04-23 20:04:39 UTC (rev 10571)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 3; 1008 bytes

@@ -20918,9 +20918,10 @@
           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 trigger names to match.
-          The <literal>WHERE</literal> clause can be given to select
-          rows using more general conditions, as discussed in
+          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"/>.
         </para>
 


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2008-04-23 20:04:27 UTC (rev 10570)
+++ trunk/refman-5.1/sql-syntax.xml	2008-04-23 20:04:39 UTC (rev 10571)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 828 bytes

@@ -23832,7 +23832,8 @@
           <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 trigger names to match. The
+          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-04-23 20:04:27 UTC (rev 10570)
+++ trunk/refman-6.0/sql-syntax.xml	2008-04-23 20:04:39 UTC (rev 10571)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 809 bytes

@@ -24097,7 +24097,8 @@
           defined on the MySQL server. This statement requires the
           <literal>TRIGGER</literal> privilege. The
           <function role="sqlop">LIKE</function> clause, if present,
-          indicates which trigger names to match. The
+          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"/>.