Author: paul
Date: 2007-07-07 00:25:04 +0200 (Sat, 07 Jul 2007)
New Revision: 7037
Log:
r27401@polar: paul | 2007-07-06 17:24:38 -0500
Document SHOW CREATE TRIGGER.
Modified:
trunk/refman-5.1/sql-syntax.xml
trunk/refman-5.2/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27400
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22451
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18820
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27401
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22451
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18820
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-07-06 22:24:45 UTC (rev 7036)
+++ trunk/refman-5.1/sql-syntax.xml 2007-07-06 22:25:04 UTC (rev 7037)
Changed blocks: 4, Lines Added: 53, Lines Deleted: 1; 2894 bytes
@@ -18318,6 +18318,10 @@
</indexterm>
<indexterm>
+ <primary>SHOW CREATE TRIGGER</primary>
+ </indexterm>
+
+ <indexterm>
<primary>SHOW CREATE VIEW</primary>
</indexterm>
@@ -18440,7 +18444,7 @@
TABLES OPEN FROM INDEX INDEXES STATUS VARIABLES DATABASE SCHEMA
DATABASES SCHEMAS LOGS FULL PROCESSLIST FOR GRANTS TABLE CREATE
WARNINGS ERRORS TYPES FIELDS HOSTS KEYS ENGINE ENGINES INNODB
- FUNCTION PROCEDURE PLUGIN MUTEX
+ FUNCTION PROCEDURE PLUGIN MUTEX TRIGGER TRIGGERS
</remark>
<remark role="help-description-begin"/>
@@ -18462,6 +18466,7 @@
SHOW CREATE FUNCTION <replaceable>funcname</replaceable>
SHOW CREATE PROCEDURE <replaceable>procname</replaceable>
SHOW CREATE TABLE <replaceable>tbl_name</replaceable>
+SHOW CREATE TRIGGER <replaceable>trigger_name</replaceable>
SHOW CREATE VIEW <replaceable>view_name</replaceable>
SHOW DATABASES [LIKE '<replaceable>pattern</replaceable>']
SHOW ENGINE <replaceable>engine_name</replaceable> {LOGS | STATUS | MUTEX}
@@ -19047,6 +19052,53 @@
</section>
+ <section id="show-create-trigger">
+
+ <title><literal>SHOW CREATE TRIGGER</literal> Syntax</title>
+
+ <indexterm>
+ <primary>SHOW CREATE TRIGGER</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW CREATE TRIGGER"/>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW CREATE TRIGGER <replaceable>trigger_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement shows a <literal>CREATE TRIGGER</literal>
+ statement that creates the given trigger.
+ </para>
+
+ <remark role="help-description-end"/>
+
+<programlisting>
+mysql> <userinput>SHOW CREATE TRIGGER ins_sum</userinput>\G
+*************************** 1. row ***************************
+ Trigger: ins_sum
+ sql_mode:
+SQL Original Statement: CREATE DEFINER=`bob`@`localhost` TRIGGER ins_sum
+ BEFORE INSERT ON account
+ FOR EACH ROW SET @sum = @sum + NEW.amount
+ character_set_client: latin1
+ collation_connection: latin1_swedish_ci
+ Database Collation: latin1_swedish_ci
+</programlisting>
+
+ <para>
+ You can also obtain information about trigger objects from
+ <literal>INFORMATION_SCHEMA</literal>, which contains a
+ <literal>TRIGGERS</literal> table. See
+ <xref linkend="triggers-table"/>.
+ </para>
+
+ </section>
+
<section id="show-create-view">
<title><literal>SHOW CREATE VIEW</literal> Syntax</title>
Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml 2007-07-06 22:24:45 UTC (rev 7036)
+++ trunk/refman-5.2/sql-syntax.xml 2007-07-06 22:25:04 UTC (rev 7037)
Changed blocks: 4, Lines Added: 53, Lines Deleted: 1; 2894 bytes
@@ -18318,6 +18318,10 @@
</indexterm>
<indexterm>
+ <primary>SHOW CREATE TRIGGER</primary>
+ </indexterm>
+
+ <indexterm>
<primary>SHOW CREATE VIEW</primary>
</indexterm>
@@ -18440,7 +18444,7 @@
TABLES OPEN FROM INDEX INDEXES STATUS VARIABLES DATABASE SCHEMA
DATABASES SCHEMAS LOGS FULL PROCESSLIST FOR GRANTS TABLE CREATE
WARNINGS ERRORS TYPES FIELDS HOSTS KEYS ENGINE ENGINES INNODB
- FUNCTION PROCEDURE PLUGIN MUTEX
+ FUNCTION PROCEDURE PLUGIN MUTEX TRIGGER TRIGGERS
</remark>
<remark role="help-description-begin"/>
@@ -18462,6 +18466,7 @@
SHOW CREATE FUNCTION <replaceable>funcname</replaceable>
SHOW CREATE PROCEDURE <replaceable>procname</replaceable>
SHOW CREATE TABLE <replaceable>tbl_name</replaceable>
+SHOW CREATE TRIGGER <replaceable>trigger_name</replaceable>
SHOW CREATE VIEW <replaceable>view_name</replaceable>
SHOW DATABASES [LIKE '<replaceable>pattern</replaceable>']
SHOW ENGINE <replaceable>engine_name</replaceable> {LOGS | STATUS | MUTEX}
@@ -19047,6 +19052,53 @@
</section>
+ <section id="show-create-trigger">
+
+ <title><literal>SHOW CREATE TRIGGER</literal> Syntax</title>
+
+ <indexterm>
+ <primary>SHOW CREATE TRIGGER</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW CREATE TRIGGER"/>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW CREATE TRIGGER <replaceable>trigger_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement shows a <literal>CREATE TRIGGER</literal>
+ statement that creates the given trigger.
+ </para>
+
+ <remark role="help-description-end"/>
+
+<programlisting>
+mysql> <userinput>SHOW CREATE TRIGGER ins_sum</userinput>\G
+*************************** 1. row ***************************
+ Trigger: ins_sum
+ sql_mode:
+SQL Original Statement: CREATE DEFINER=`bob`@`localhost` TRIGGER ins_sum
+ BEFORE INSERT ON account
+ FOR EACH ROW SET @sum = @sum + NEW.amount
+ character_set_client: latin1
+ collation_connection: latin1_swedish_ci
+ Database Collation: latin1_swedish_ci
+</programlisting>
+
+ <para>
+ You can also obtain information about trigger objects from
+ <literal>INFORMATION_SCHEMA</literal>, which contains a
+ <literal>TRIGGERS</literal> table. See
+ <xref linkend="triggers-table"/>.
+ </para>
+
+ </section>
+
<section id="show-create-view">
<title><literal>SHOW CREATE VIEW</literal> Syntax</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7037 - in trunk: . refman-5.1 refman-5.2 | paul | 7 Jul |
