i have a table data like this
(int) (time) [mySQL datatype]
Id Duration
------------------
1 00:10:00
2 10:10:00
3 03:00:00
4 04:13:00
i want to calculate the total duration from this table, how can we do it. like 17:33:00. Could anybody please provide mysql query to calculate this.