No of triggers of one single table

Started by Harpreet Dhaliwalabout 19 years ago3 messagesgeneral
Jump to latest
#1Harpreet Dhaliwal
harpreet.dhaliwal01@gmail.com

Hi,
Can i have more than one trigger on one single table. Actually I want 2
different events to take place simultaneously and independently after
insert.

~Harpreet.

#2Michael Fuhr
mike@fuhr.org
In reply to: Harpreet Dhaliwal (#1)
Re: No of triggers of one single table

On Fri, Apr 06, 2007 at 01:10:13PM -0400, Harpreet Dhaliwal wrote:

Can i have more than one trigger on one single table. Actually I want 2
different events to take place simultaneously and independently after
insert.

What happened when you tried it?

--
Michael Fuhr

#3Alban Hertroys
alban@magproductions.nl
In reply to: Harpreet Dhaliwal (#1)
Re: No of triggers of one single table

Harpreet Dhaliwal wrote:

Hi,
Can i have more than one trigger on one single table. Actually I want 2
different events to take place simultaneously and independently after
insert.

You can, but they won't run simultaneously. They'll run in alphabetical
order.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //