这个错误是说从t表select出来的无法又更新t表。
可以在select的时候先取个别名，弄个临时表即可。
相关文章
- 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中执行sql语句错误 Error Code: 1093. You can't specify target table 'car' for update in FROM clause
- MySql报错： You can't specify target table 'table name' for update in FROM clause解决办法
- MYSQL之You can't specify target table for update in FROM clause解决办法
- [Django](1093, "You can't specify target table 'fee_details_invoices' for update in FROM clause") 错误
- MYSQL之You can't specify target table for update in FROM clause解决办法（在Delete子句中嵌套Select语句）
- mysql中You can’t specify target table for update in FROM clause错误解决方法
- You can't specify target table 'charge' for update in FROM clause