【MySQL】1093 You can't specify target table 'table name' for update in FROM clause
来源:互联网 发布:史记的地位 知乎 编辑:程序博客网 时间:2024/04/30 19:59
错误 :1093 You can’t specify target table ‘table name’ for update in FROM clause
中文意思:不能先select出同一表中的某些值,再update这个表(在同一语句中)
解决:
注:把同一个table重新包一遍,重命名
原句
update person_level_test set currentStatus=0where id=(select max(m.id) from person_level_test)
修改后
update person_level_test set currentStatus=0where id=(select max(m.id) from (select * from person_level_test) m)
转自http://www.cnblogs.com/lteal/archive/2013/05/06/3062709.html
0 0
- 【MySQL】1093 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
- You can't specify target table 'table name' for update in FROM clause
- MYSQL 临时表 #1093 - You can't specify target table 'dealer_admin' for update in FROM clause
- MYSQL 1093 - 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 'table name' for update in FROM clause解决办法
- mysql update语句问题:You can't specify target table 'user' for update in FROM clause
- [Err] 1093 - You can't specify target table 'table' for update in FROM clause处理
- Mysql - You can't specify target table 'dataproduct' for update in FROM clause
- MySQL报错“ you can't specify the 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错误
- Swift中的NSNumber
- MySQL存储过程
- Web开发人员应当知道的15个开源项目
- Android驱动开发
- Ubuntu15 交叉编译器的配置
- 【MySQL】1093 You can't specify target table 'table name' for update in FROM clause
- 郑大第九届校赛正式赛(1819: 加加加!(油))
- registerNib: 与 registerClass: 的区别
- 哪些JavaScript IDE最好用?
- linux shell mysql 数据库主从同步状态检查告警
- OpenCV -- VideoCapture
- 高端技巧:如何使用#define定义变量
- Android-Androidstudio集成git开发环境
- Struts2学习——(九)Struts2标签III