mysql的1093错误You can't specify target table 't' for update in FROM clause 简单解决
来源:互联网 发布:淘宝双十二承接页装修 编辑:程序博客网 时间:2024/05/31 19:08
mysql>delete from twhere idin (select idfrom twhere id < 5);
ERROR1093 (HY000): You can't specify target table 't' for update in FROM clause
改为下面就OK
deletefrom t where id in(select * from ((select idfrom twhere id <5) tmp);
主句(select * from (从句 temp)
删除重复,但保留最小id项。
DELETE
FROM
file
WHERE
fileaddress IN (
select * from ((
SELECT
fileaddress
FROM
file
GROUP BY
fileaddress
HAVING
count(fileaddress) > 1
) a)
)
AND id NOT IN (
select * from ((
SELECT
min(id)
FROM
file
GROUP BY
fileaddress
HAVING
count(fileaddress) > 1
) b)
)
0 0
- mysql的1093错误You can't specify target table 't' for update in FROM clause 简单解决
- mysql错误:1093-You can’t specify target table for update in FROM clause的解决方法
- 关于mysql "You can't specify target table 'test_zb_scene' for update in FROM clause"的错误
- mysql 出现You can't specify target table for update in FROM clause错误的解决方法
- MySQL 错误码: 1093 You can't specify target table 'jc_user' for update in FROM clause
- mysql中错误:1093-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 'X' for update in FROM clause" 错误解决方法
- Mysql 错误 Code: 1093. 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 错误解决方法
- PAT A1120 friend numbers (20)
- 支持向量机通俗导论(理解SVM的三层境界)(3)以及参考文献
- Ubuntu12.04如何修改窗口背景色为眼睛保护色来保护眼睛,强力推荐!!
- 05.计算属性
- 实战项目商城(第一天)
- mysql的1093错误You can't specify target table 't' for update in FROM clause 简单解决
- TabLayout使用setupWithViewPager()方法绑定Viewpager后不显示文字
- Mysql开发—— 事务
- 如何在centOS等一些linux系统下安装oracle sqldeveloper图形化数据库操作界面
- Linux下打包运行MR程序
- localStorage和sessionStorage详解
- oracle合并列的wm_concat函数
- Sphinx命令行工具
- hashmap碰撞 造成的死循环