2015年4月2日

Mysql: Table 'name' is specified twice, both as a target for 'UPDATE' and as a separate source for data

摘要: mysql在执行删除、更新的时候,可能会出现这样的错误,比如你写了类似下面的sql:UPDATE MYTABLE SET COL=COL+1 WHERE ID IN (SELECT ID FROM MYTABLE WHERE OTHERCOL=0)orDELETE FROM MYTABLE WHER... 阅读全文

posted @ 2015-04-02 17:09 paul liu 阅读(9161) 评论(0) 推荐(1) 编辑

导航