22,209
社区成员
发帖
与我相关
我的任务
分享
UPDATE chinaepgmenunameott t1
SET t1. HOUR = CAST(
floor(
(
SELECT
t.playtime - t1.playtime
FROM
(
SELECT
*
FROM
chinaepgmenunameott
) t
WHERE
t.startdate = t1.startdate
AND t1.sequencecode + 1 = t.sequencecode
) / 60
) AS SIGNED
),
t1.minutes = MOD (
(
SELECT
t3.playtime - t1.playtime
FROM
(
SELECT
*
FROM
chinaepgmenunameott
) t3
WHERE
t1.startdate = t3.startdate
AND t1.sequencecode + 1 = t3.sequencecode
),
60
)