• Post Reply Bookmark Topic Watch Topic
  • New Topic

Mysql Trigger

 
Sudhir Kumar Ojha
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Every One


I am student and today i am practicing mysql.

My qusetion is how to learn mysql trigger mostly updatable trigger.

Can anyone help me out here.Please post easy and short mysql trigger queries don't post advance trigger example because i am beginer in mysql.


Thank You
 
K. Tsang
Bartender
Posts: 3610
16
Firefox Browser Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you consulted the MySQL site here for v5.5?

Say there are 2 tables A and B. Triggers "can be" used when you insert/update/delete data for A, do something in B or vice versa.

Another example is columns can filled in/updated within the same table when data is inserted/updated.

Have a look at the link above or google a bit.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!