0

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')

Edited by jrosh: n/a

3
Contributors
5
Replies
6
Views
7 Years
Discussion Span
Last Post by pritaeas
0

Isn't this the complication of the simple thing and a duplicate thread.
somebody just wrote solution in php for this.

0

Isn't this the complication of the simple thing and a duplicate thread. somebody just wrote solution in php for this.

His question was to add dates to columns automatically. Ergo, the use of triggers. Please clarify how php would solve this.

0

His question was to add dates to columns automatically. Ergo, the use of triggers. Please clarify how php would solve this.

yeh...can any 1 help please....

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.