You can't specify target table 't_bz_invalid_agree' for update in FROM clause
时间: 2024-03-08 15:41:36 浏览: 31
这个错误通常是由于在MySQL中更新语句中使用了FROM子句,而且在FROM子句中指定了要更新的表。这是不允许的,因为在更新期间,表可能会被锁定,从而导致查询失败。解决这个问题的方法有多种,其中一种是使用子查询来代替FROM子句中的表。例如,可以将要更新的表作为子查询的一部分,然后在外部查询中引用该子查询。具体的解决方法可以参考引用中提供的内容。
相关问题
You can't specify target table 'ed_user' for update in FROM clause
It seems that you are encountering an error message related to the SQL query. The error message "You can't specify target table 'ed_user' for update in FROM clause" typically occurs when you try to update a table that is also referenced in the FROM clause of the same query.
To resolve this issue, you can use a subquery to separate the update operation from the select operation. Here's an example of how you can rewrite the query:
```
UPDATE ed_user
SET column_name = new_value
WHERE user_id IN (
SELECT user_id
FROM ed_user
WHERE condition
);
```
In this example, replace `column_name` with the actual column you want to update, `new_value` with the desired new value, `ed_user` with the target table name, and `condition` with the appropriate condition for selecting the rows to update.
By using a subquery, you can avoid referencing the target table in the FROM clause and resolve the error.
You can t specify target table res_device_info for update in FROM clause
This error message usually occurs in SQL when you try to update a table that is also used in the FROM clause of the same query. To resolve this issue, you can use a subquery to update the table instead. Here's an example:
```sql
UPDATE res_device_info
SET column_name = new_value
WHERE device_id IN (
SELECT device_id
FROM res_device_info
WHERE condition
);
```
In this example, you can replace `column_name`, `new_value`, `condition` with the appropriate values for your scenario. Make sure to adjust the subquery's condition to match your requirements.
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)