Mysql - Triggers

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • crs27
    New Member
    • Jul 2007
    • 40

    Mysql - Triggers

    Hai All,

    How can i know if a table is associated with a trigger.Can i get the trigger name by any means?

    I would also like to know what is the syntax for creating a trigger,which comprises of a if condition.

    Is it something like an administrator only can create trigger or can he give permission for the root user to create one.

    Thank You.
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    Hi.

    It is all explained in the MySQL Reference Manual.

    (See this entry in the FAQ on that page for an idea how to solve your first question)

    Comment

    Working...