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

这个错误信息是由MySQL引擎生成的，意思是在FROM子句中不能指定目标表。这通常是由于在更新查询中使用了子查询，并且子查询引用了需要更新的表。解决这个问题的方法是使用临时表来存储子查询的结果，然后再更新目标表。

以下是一个解决方法的示例：

UPDATE p_user SET status = 1 WHERE id IN (SELECT * FROM (SELECT id FROM p_user WHERE status IS NULL) AS temp);

请注意，在这个示例中，我们使用了一个嵌套的子查询，并将其结果保存在一个临时表(temp)中。然后，我们在外部查询中使用了这个临时表来更新目标表(p_user)的数据。

希望这个解决方法对你有帮助。

相关问题

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

This error usually occurs when you try to perform an UPDATE query that references the table being updated in a subquery. To fix this, you can restructure your query to avoid referencing the table being updated in the subquery.

Here's an example of the error you mentioned:

UPDATE user
SET status = 'active'
WHERE user_id IN (
    SELECT user_id
    FROM user
    WHERE created_date < '2021-01-01'
);

To resolve this issue, you can rewrite the query using a JOIN:

UPDATE user
JOIN (
    SELECT user_id
    FROM user
    WHERE created_date < '2021-01-01'
) AS subquery ON user.user_id = subquery.user_id
SET user.status = 'active';

By using a JOIN, you can update the desired records without referencing the target table in the subquery.

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.