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

这是一个错误提示，出现这个错误通常是因为在MySQL的UPDATE语句中，用到了更新与查询同一张表的语法，也就是所谓的子查询语法，在MySQL中子查询会暂时创建出一张临时表，而UPDATE语句不能直接更新临时表，所以就会出现这个错误。

解决方法可以采用两种方式：

1.使用临时表存储查询结果，再进行更新操作:

CREATE TEMPORARY TABLE tmp_table AS 
SELECT * FROM Nor_SmpTubeType WHERE {条件};

UPDATE Nor_SmpTubeType SET {更新字段} 
WHERE {条件} AND Id IN (SELECT Id FROM tmp_table);

2.使用多表连接语法：

UPDATE Nor_SmpTubeType SET {更新字段}  
WHERE {条件} AND Id IN (
    SELECT t1.Id FROM Nor_SmpTubeType AS t1, 
    (SELECT Id FROM Nor_SmpTubeType WHERE {条件}) AS t2 
    WHERE t1.Id = t2.Id
);

希望能够解决你的问题。

相关问题

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.

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

You can't specify target table 'p' for update in FROM clause 是一个MySQL错误，它的含义是在更新语句中不能将同一表作为查询表和更新表。为了解决这个错误，你可以使用临时表或子查询来避免在FROM子句中使用同一表。具体的解决方法如下：

1. 使用临时表：
创建一个临时表，将需要更新的数据查询到临时表中，然后再使用临时表进行更新操作。

2. 使用子查询：
将需要更新的数据查询到子查询中，然后在外层查询中使用子查询进行更新操作。

以下是示例代码：

1. 使用临时表：
CREATE TEMPORARY TABLE temp_table
SELECT * FROM your_table WHERE condition;

UPDATE your_table AS t
INNER JOIN temp_table AS temp
ON t.id = temp.id
SET t.column = temp.column;

2. 使用子查询：
UPDATE your_table AS t
SET t.column = (
SELECT temp.column FROM your_table AS temp
WHERE temp.id = t.id AND condition
);