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 ???
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
