Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a bug in the CREATE TRIGGER documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
2f8b2b9ead267ad6d7608da25e441347 |
| User & Date: | drh 2008-09-24 17:49:08 |
Context
|
2008-09-24
| ||
| 18:52 | Trying for improvements in the appearance of the syntax in lang*.html. check-in: 4bae4cc5b7 user: drh tags: trunk | |
| 17:49 | Fix a bug in the CREATE TRIGGER documentation. check-in: 2f8b2b9ead user: drh tags: trunk | |
|
2008-09-23
| ||
| 18:06 | Add some more to fileio.html. check-in: 3a3fd02722 user: dan tags: trunk | |
Changes
Changes to pages/lang.in.
595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 |
statement. </p>
<tcl>
##############################################################################
Section {CREATE TRIGGER} createtrigger {{CREATE TRIGGER}}
Syntax {sql-statement} {
CREATE [TEMP | TEMPORARY] TRIGGER [IF NOT EXISTS] <trigger-name> [ BEFORE | AFTER ]
<database-event> ON [<database-name> .] <table-name>
<trigger-action>
}
Syntax {sql-statement} {
CREATE [TEMP | TEMPORARY] TRIGGER [IF NOT EXISTS] <trigger-name> INSTEAD OF
<database-event> ON [<database-name> .] <view-name>
<trigger-action>
}
Syntax {database-event} {
DELETE |
INSERT |
UPDATE |
|
| | | | |
595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 |
statement. </p>
<tcl>
##############################################################################
Section {CREATE TRIGGER} createtrigger {{CREATE TRIGGER}}
Syntax {sql-statement} {
CREATE [TEMP | TEMPORARY] TRIGGER [IF NOT EXISTS] [<database-name> .] <trigger-name>
[ BEFORE | AFTER ] <database-event> ON <table-name>
<trigger-action>
}
Syntax {sql-statement} {
CREATE [TEMP | TEMPORARY] TRIGGER [IF NOT EXISTS] [<database-name .] <trigger-name>
INSTEAD OF <database-event> ON <view-name>
<trigger-action>
}
Syntax {database-event} {
DELETE |
INSERT |
UPDATE |
|