MySQL 1093 You can't specify target table for update in FROM c 的解决办法

执行SQL语句时出现这个错误。原因是在更新这个表和数据时又查询了它，而查询的数据又做了更新的条件。
以前ORACLE上面没有这个错误。

DELETE FROM comments 
WHERE
    id = (SELECT 
        t2.id
    FROM
        (SELECT 
            *
        FROM
            comments) t2
    ORDER BY t2.created DESC
    LIMIT 1);

update t_area t set t.parent_name = (select t2.name from (select * from t_area) t2 
where t.parent_id = t2.id);