I use mysql to store some time values (infact 2 at a time)
Startime & end time.... in two columns.
I have another column called duration which stores the diffrerce of the above two time values...
I want to fill that third column(duration) when I insert the values to the first 2 columns..
I think that can be done through a trigger.. how can I do that??
(I dnt knw how to write a trigger...or wat it reallly does is!!!!!!)
(I use java for the application. if this should be solved through java plz let me knw)