首页 文章

＃1093 - 您可以't specify target table ' comments'进行FROM子句中的更新

提问于
浏览 次
1

我想从我的数据库中删除重复的注释

Delete FROM `comments` WHERE id IN 
(
  SELECT id
  FROM comments
  GROUP BY 
  COMMENT , course_id
  HAVING COUNT( * ) >1
)

我收到错误＃1093 -

您无法在FROM子句中为更新指定目标表'comments' .

如何修改我的查询以正常工作

mysql duplicates

1 回答

  • 1

    尝试别名子查询：

    Delete FROM `comments` WHERE id IN 
(
  select * from (
      SELECT id
      FROM comments GROUP BY  COMMENT , course_id
      HAVING COUNT( * ) >1
  ) as comm
)
    回复于

相关问题