无法指定目标表进行更新，在mysql中删除查询

I want to do what seems like a simple delete in mysql but am having some trouble. I want to do this:

我想在mysql中做一个简单的删除但是遇到麻烦。我想做这个：

delete from table where col_name not in (select distinct col_name from table);

This table does not have a unique key. When I try this, I get the error:

此表没有唯一键。当我尝试这个时，我得到错误：

You can't specify target table for update in from clause; ErrorNr. 1093

您不能在from子句中指定update的目标表; ErrorNr。 1093

mysql community 5.1

mysql社区5.1

Is there a way i can save the output from this query ->

有没有办法可以保存此查询的输出 - >

select distinct col_name from table;

into temp. table and use it in the delete query?

进入临时表并在删除查询中使用它？

2 个解决方案

#1

You must use an alias.

您必须使用别名。

delete from table where col_name not in (select a.col_name from (select distinct col_name from table) a);

It should work.

它应该工作。

Edit : sorry, I misunderstood the question, and only focus on the SQL Error. The probleme to delete duplicate line with no unique key isn't answered by the above request.

编辑：抱歉，我误解了这个问题，只关注SQL错误。上述请求无法回答删除没有唯一键的重复行的问题。

2 个解决方案

#1

更多相关文章

随机推荐