MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: why the trigger is not working while refering other tables?
Posted by: Jay Pipes
Date: July 04, 2005 12:33PM

dude. I tried your code and got similar results. I tried a number of different variations, with your table structures and got same results.

Then, I tried a similar structure (three tables, with auto-increment keys and two chained triggers, and it worked, though the auto-increment keys were off by one. As this was a bug, I reported it to MySQL promptly via the bug interface.

I suggest you do the same, though I would clean up your code and make it simpler and more generic first.

Cheers dude.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
why the trigger is not working while refering other tables?
7210
junjie_1982
June 28, 2005 09:16AM
Re: why the trigger is not working while refering other tables?
3715
Jay Pipes
June 28, 2005 02:13PM
Re: why the trigger is not working while refering other tables?
3004
junjie_1982
June 29, 2005 09:53AM
Re: why the trigger is not working while refering other tables?
2838
Jay Pipes
June 29, 2005 11:52AM
Re: why the trigger is not working while refering other tables?
2476
Gniontas Gniontas
October 02, 2008 05:26PM
Re: why the trigger is not working while refering other tables?
2250
Andrew Gilfrin
June 29, 2005 03:43PM
Re: why the trigger is not working while refering other tables?
2735
Jay Pipes
June 29, 2005 08:28PM
Re: why the trigger is not working while refering other tables?
3056
Andrew Gilfrin
June 30, 2005 06:35AM
Re: why the trigger is not working while refering other tables?
2481
Jay Pipes
June 30, 2005 10:26AM
Re: why the trigger is not working while refering other tables?
2395
Andrew Gilfrin
July 01, 2005 03:33AM
Re: why the trigger is not working while refering other tables?
3293
junjie_1982
July 02, 2005 10:18AM
Re: why the trigger is not working while refering other tables?
2396
junjie_1982
July 04, 2005 10:07AM
Re: why the trigger is not working while refering other tables?
2454
Jay Pipes
July 04, 2005 12:33PM
Re: why the trigger is not working while refering other tables?
2455
Jay Pipes
July 04, 2005 12:39PM
Re: why the trigger is not working while refering other tables?
2193
junjie_1982
July 04, 2005 01:23PM
Re: why the trigger is not working while refering other tables?
2292
Jay Pipes
July 04, 2005 02:10PM
Re: why the trigger is not working while refering other tables?
2453
Jay Pipes
July 04, 2005 02:16PM
Re: why the trigger is not working while refering other tables?
2018
junjie_1982
July 04, 2005 02:35PM
Re: why the trigger is not working while refering other tables?
2211
junjie_1982
July 07, 2005 10:37AM
Re: why the trigger is not working while refering other tables?
2346
Jay Pipes
July 07, 2005 11:02AM
Re: why the trigger is not working while refering other tables?
4319
junjie_1982
July 08, 2005 03:46PM
Re: why the trigger is not working while refering other tables?
2097
junjie_1982
July 04, 2005 02:00PM
Re: why the trigger is not working while refering other tables?
3567
junjie_1982
July 04, 2005 04:57PM
Re: why the trigger is not working while refering other tables?
2323
junjie_1982
July 09, 2005 04:43AM
Re: why the trigger is not working while refering other tables?
2295
junjie_1982
July 14, 2005 08:52AM
Re: why the trigger is not working while refering other tables?
2505
Jay Pipes
July 14, 2005 09:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.