mysql的烂语法!
-
SQL code
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' ;
You can’t specify target table ‘a’ for update in FROM clause
-
SQL code
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' ;
解决了!
恭喜。接分。
每种数据库都有自己的语言限制。特别是免费的这种。
习惯就好了
尽量适应就好,过后天空一片晴朗。
什么东西都得适应新的环境。