You can't specify target table 'basedata_role_type' for update in FROM clause3

根据提供的引用内容，当在MySQL中出现"You can't specify target table 'basedata_role_type' for update in FROM clause"错误时，可以尝试以下解决方法：

方法一：多嵌套一层子查询

UPDATE basedata_role_type
SET column_name = value
WHERE id IN (
    SELECT id
    FROM (
        SELECT id
        FROM basedata_role_type
    ) AS t
);

方法二：使用临时表

CREATE TEMPORARY TABLE temp_table
SELECT id
FROM basedata_role_type;

UPDATE basedata_role_type
SET column_name = value
WHERE id IN (
    SELECT id
    FROM temp_table
);

DROP TEMPORARY TABLE temp_table;

方法三：使用JOIN语句

UPDATE basedata_role_type AS t1
JOIN (
    SELECT id
    FROM basedata_role_type
) AS t2 ON t1.id = t2.id
SET t1.column_name = value;

请注意，根据具体情况选择适合的解决方法。