If that works for MySQL, the official documentation doesn't show it: http://dev.mysql.com/doc/mysql/en/create-trigger.html
I don't have a copy of the 5.0+ source or I could check the sql/sql_yacc.yy file to see if the syntax is supported. Anyone else able to help out here? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Ruben Oliveira <[EMAIL PROTECTED]> wrote on 06/17/2005 09:14:48 AM: > yes there is : > http://www.postgresql.org/docs/7.4/interactive/sql-createtrigger.html > FOR EACH ROW > FOR EACH STATEMENT > This specifies whether the trigger procedure should be fired once > for every row affected by the trigger event, or just once per SQL > statement. If neither is specified, FOR EACH STATEMENT is the default. > > Philippe Poelvoorde wrote: > > Hi, > > > > the syntax for creating a triggers is : > > CREATE TRIGGER trigger_name trigger_time trigger_event > > ON tbl_name FOR EACH ROW trigger_stmt > > > > Is there any other possibilities than "FOR EACH ROW" ? > > If I do : > > CREATE TABLE test(foo varchar(5)); > > CREATE TRIGGER trigger_name AFTER INSERT > > ON test FOR EACH ROW do_something; > > INSERT INTO test(foo) VALUES ('a'),('b'),('c'); > > it would trigger trigger_name for the 3 inserts, right ? Any chance to > > trigger trigger_name only once at the end ??? > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
