mysql中You can't specify target table for update in FROM clause错误
来源:互联网 发布:花生壳免费域名使用 编辑:程序博客网 时间:2024/05/22 15:45
MySQL中You can't specify target table <tbl> for update in FROM clause错误的意思是说,不能先select出同一表中的某些值,再update这个表(在同一语句中)。 例如下面这个sql:
delete from tbl where id in
(
select max(id) from tbl a where EXISTS
(
select 1 from tbl b where a.tac=b.tac group by tac HAVING count(1)>1
)
group by tac
)
改写成下面就行了:
delete from tbl where id in
(
select a.id from
(
select max(id) id from tbl a where EXISTS
(
select 1 from tbl b where a.tac=b.tac group by tac HAVING count(1)>1
)
group by tac
) a
)
也就是说将select出的结果再通过中间表select一遍,这样就规避了错误。注意,这个问题只出现于mysql,mssql和Oracle不会出现此问题。
0 0
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误 转
- mysql中You can’t specify target table for update in FROM clause错误解决方法
- mysql中You can\'t specify target table for update in FROM clause错误
- mysql中You can’t specify target table for update in FROM clause错误解决方法
- mysql中You can't specify target table for update in FROM clause错误
- mysql 中 You can't specify target table <tbl> for update in FROM clause 错误解决方法
- mysql中You can’t specify target table for update in FROM clause错误解决方法
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can’t specify target table for update in FROM clause错误解决方法
- mysql中You can’t specify target table for update in FROM clause错误解决方法
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误
- mysql中You can't specify target table for update in FROM clause错误
- RegisterWindowMessage与BroadcastSystemMessage
- 生成"登录验证码"的方法步骤
- 修饰类成员函数的几个关键字:inline, const, explicit, static, virtual
- Android-MessageQueue类
- 类与类之间的关系图(Class Diagram,UML图)
- mysql中You can't specify target table for update in FROM clause错误
- CSS3 如何实现标签宽度按权等分
- 浅谈StrictMode
- Linux面试必备
- Ecelipse用GIT中从服务器上更新代码
- 高效CSS属性简写总结
- 每日积累(20161220-day-20)(ubuntu 远程登录ssh安装使用 创建ubuntu用户)
- 使用curl进行模拟登录
- collectionview写的新手引导