Query that fires when any operation is made on table.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • devathi
    New Member
    • Dec 2006
    • 17

    Query that fires when any operation is made on table.

    suggest My sql query that gives message when any insert or delete or select query is executed on a table.
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    From MySQL 5.1 you can insert a trigger as the result of an INSERT, UPDATE or DELETE on a table. But only from MySQL 5.1 and up.

    For detailed info, see the MySQL documentation on triggers at Triggers

    Ronald :cool:

    Comment

    Working...