You can't specify target table 'table_name' for update in FROM clause
来源:互联网 发布:自动折弯机如何编程 编辑:程序博客网 时间:2024/06/05 07:28
连表查询后进行update|delete操作,会报错
sql:
delete from feed where id in (select f.id from comment as c, feed as f where f.column1 =c.id);
You can't specify target table 'feed' for update in FROM clause
只要修改成:
delete from feed where id in (select a.id from (select f.id from comment as c, feed as f where f.column1 =c.id) a);
也就是说将select出的结果再通过中间表select一遍,就可以了。
0 0
- You can't specify target table 'table_name' for update in FROM clause
- mysql update语句问题:You can't specify target table 'user' for update in FROM clause
- You can't specify target table 'table name' for update in FROM clause
- MySql报错: You can't specify target table 'table name' for update in FROM clause
- 【MySQL】1093 You can't specify target table 'table name' for update in FROM clause
- [Err] 1093 - You can't specify target table 'table' for update in FROM clause处理
- You can't specify target table 't' for update in FROM clause
- Mysql - You can't specify target table 'dataproduct' for update in FROM clause
- You can't specify target table 'wms_cabinet_form' for update in FROM clause
- MySQL报错“ you can't specify the target table for ‘update’ in from clause”
- You can't specify target table 'sc1' for update in FROM clause
- [Err] 1093 - You can't specify target table 's' for update in FROM clause
- mysql中You can't specify target table for update in FROM clause错误
- You can't specify target table 'sdb_goods' for update in FROM clause
- You can't specify target table 'A' for update in FROM clause
- MYSQL 临时表 #1093 - You can't specify target table 'dealer_admin' 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
- vs2015打开VS2010的工程时,无法解析的外部符号 __imp___vsnprintf
- 欢迎使用CSDN-markdown编辑器
- K-based Numbers(Ural_1009)
- Java 通过HttpURLConnection Post方式提交xml,并从服务端返回数据
- ubuntu14.04 下编译vlc Android
- You can't specify target table 'table_name' for update in FROM clause
- iOS知识小集 第三期
- ios 怎么添加pch预编译文件
- CentOS下rpm安装C/C++环境
- eclipse中注释的设置
- 如何能够获得Extjs.grid.panel总的Columns的列数
- Fiddler(一) - Fiddler简介
- delphi 域名转ip并判断ip是否可以联通
- C# 使用Sentech相机sdk 获取图像,转换为halcon HImage的两种方法