Calculate a Sum of Time using MySQL

We have Following Table Structure of myvideos

CREATE TABLE IF NOT EXISTS `myvideos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `time` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='3' AUTO_INCREMENT=5 ;


INSERT INTO `myvideos` (`id`, `name`, `time`) VALUES
(1, 'Video 1', '02:02:00'),
(2, 'Video  2', '02:02:00'),
(3, 'Video  3', '02:02:00'),
(4, 'Video  4', '02:04:00');

Problem: How to calculate the sum of time of video?


Solution:

select sec_to_time(sum(time_to_sec(time))) as total_time from myvideos 

Best Related Posts are Following:

1. PHP Mysql Interview Questions and Answers for fresher and experienced.
2. Differences between Stored Procedures and Functions in MYSQL.
3. PHP MySQL interview questions and answers for experienced.
4. MySQL Interview Questions and Answers for Experienced.
5. Advanced MySQL Interview Questions and Answers for Experienced.
6. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
7. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
8. Calculate a Sum of Time using MySQL.
9. Mysql Interview Questions And Answers - Atomicity, Dedlock, Client Program, Mysql Mode, Mysql Sensitivity Of Identifiers And Mysql Errors.
10. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
11. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation - Multilingual Website.
12. MySQL Interview Questions and Answers.
13. MySQL Functions - MySQL tutorial for beginners.
14. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
15. Stored Procedure - Advantage of Stored Procedure - Disadvantage of Stored Procedure.
16. Pending Interview Questions and Answers.
17. MySQL Indexing.
18. Mysql Update Statement.
19. MySQL Constraint Example.
20. MySQL Cascade Example.
21. MySQL Expressions.
22. MySQL Delete Table Example.
23. Replace Table - Update Field, Move Records to another table MySQL.
24. Mysql Update Syntax - Update Multiple Records.
25. What is Mysql.
26. MySQL interview Questions and Answers For Experienced.