monitor changes in mysql table and respond accordingly

I want to know how to monitor a particular mysql table for changes. Suppose there is an insert comman开发者_Python百科d and I want to get the values of all the columns corresponding to that insert command and then use those values to do something.

---

An insert trigger will handle detecting the insert for you:

CREATE TRIGGER my_on_before_trigger BEFORE INSERT ON the_table_you_want_to_monitor
    ...