select sum(num) from (select UNIX_TIMESTAMP(CONCAT('2015-01-19 ',playtime))-UNIX_TIMESTAMP(CONCAT('2015-01-19 ','00:00:00')) as num from video limit 7984) as hh;
转载于:https://www.cnblogs.com/joshua317/articles/4245259.html
select sum(num) from (select UNIX_TIMESTAMP(CONCAT('2015-01-19 ',playtime))-UNIX_TIMESTAMP(CONCAT('2015-01-19 ','00:00:00')) as num from video limit 7984) as hh;
转载于:https://www.cnblogs.com/joshua317/articles/4245259.html