mysql中You can't specify target table for update in FROM clause错误
来源:互联网 发布:女生下体有味道 知乎 编辑:程序博客网 时间:2024/05/18 02:02
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错误
- 追踪mysql操作记录实践2
- IIS 设置了Session的超时时间
- [ExtJS5学习笔记]第三十五节 sencha extjs 5 组件查询方法总结
- UIEventKit EKCalender EKEventStore EKSource
- ORACLE数值类型的性能优化技巧number,Int,float
- mysql中You can't specify target table for update in FROM clause错误
- 39999961853你的线上店铺被我们承包了丨阿里巴巴全行业&u8226;优质班开课嘞!
- Android技术——列表呈现,AdapterView及其子类(下)
- 淘金昌龙:阿里巴巴缘何在美遭空头狙击
- 关于frameset的用法
- android 项目优化之toast提示优化
- android——WindowManager
- 修改mysql提示符
- Uva227.Puzzle