执行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);