mysql的烂语法！该如何处理

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' ;

解决了！

[解决办法]
恭喜。接分。
[解决办法]
每种数据库都有自己的语言限制。特别是免费的这种。
[解决办法]
习惯就好了
[解决办法]
尽量适应就好，过后天空一片晴朗。
[解决办法]
什么东西都得适应新的环境。

查看更多 下一篇