56,675
社区成员
发帖
与我相关
我的任务
分享
UPDATE weekreport_alluser a SET a.dayadd = (SELECT b.weekadd
FROM weekreport_alluser b
WHERE SUBSTR(a.weekname,3,4) = SUBSTR(b.weekname,3,4)+2)
WHERE a.weekname = 'WK13' ;
UPDATE weekreport_alluser a SET a.dayadd = (SELECT b.weekadd
FROM (SELECT weekname,weekadd FROM weekreport_alluser) b
WHERE SUBSTR(a.weekname,3,4) = SUBSTR(b.weekname,3,4)+2)
WHERE a.weekname = 'WK13' ;
UPDATE weekreport_alluser a,weekreport_alluser b
SET a.dayadd = b.weekadd
WHERE SUBSTR(a.weekname,3,4) = SUBSTR(b.weekname,3,4)+2
and a.weekname = 'WK13' ;
这种好点!