I stored two time values in mysql data as 'starttime' & 'endtime'.
I have another column to store the' duration '(which will contain 'endtime-starttime')
Is there a way to add values to ' duration ' automatically when I insert values to 'start time' & 'end time'.
I use WAMP ..I wanna do it through Mysql....rather than through application...
Is it possible.... how?
thankx in advance.
(All the columns contain datatype 'time')