• Post Reply Bookmark Topic Watch Topic
  • New Topic

Mysql Trigger  RSS feed

 
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: 3648
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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!