You can't specify target table 't_product_sup_cost' for update in FROM clause

这个错误通常是由于在MySQL中更新语句中使用了子查询，而子查询中又涉及到了要更新的表，导致MySQL无法确定要更新的表。解决这个问题的方法是使用临时表来存储子查询的结果，然后再进行更新操作。以下是一个示例代码：

CREATE TEMPORARY TABLE temp_table
SELECT * FROM t_product_sup_cost WHERE ...
UPDATE t_product_sup_cost
SET ...
WHERE id IN (SELECT id FROM temp_table)

其中，`temp_table`是一个临时表，用于存储子查询的结果。在更新操作中，我们使用`IN`关键字来指定要更新的行，这样就可以避免在子查询中使用要更新的表了。

相关问题

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:

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.