[Cialug] MySQL Trigger

[Kevin C. Smith]

I'm not much of a DB person, and need help with the new trigger functionality
in MySQL 5.0.22.

Is is possible and how do I create a trigger that takes two time fields and
inserts into another field the time difference (time passed)?

Columns = end_time, start_time, and time

Need something that does this:
end_time - start_time = time

Would like to be able to do this on update and insert. Never done this
before.

CREATE TRIGGER trigger_time AFTER INSERT ON case_notes
FOR EACH ROW ????



P.S. I can't make the meeting tonight.

-- 
Kevin C. Smith