如何从mysql表中删除具有相同列值的行?

I have a problem with my queries in MySQL. My table has 4 columns and it looks something like this:

我的MySQL查询有问题。我的表格有4列，看起来是这样的:

id_users    id_product    quantity    date
 1              2              1       2013
 1              2              1       2013
 2              2              1       2013
 1              3              1       2013

id_users and id_product are foreign keys from different tables.

id_users和id_product是来自不同表的外键。

What I want is to delete just one row:

我想要的是删除一行:

1     2     1    2013

Which appears twice, so I just want to delete it.

它出现了两次，所以我想删除它。

I've tried this query:

我试着这个查询:

delete from orders where id_users = 1 and id_product = 2

But it will delete both of them (since they are duplicated). Any hints on solving this problem?

但是它会删除它们(因为它们是重复的)。有什么解决这个问题的建议吗?

6 个解决方案

#1

177

Add a limit to the delete query

向删除查询添加限制

delete from orders 
where id_users = 1 and id_product = 2
limit 1

6 个解决方案

#1

更多相关文章

随机推荐