mysql删除语句遇到问题

我现在库里有着两条数据 我只想删除第一条 但用 delete form nameinfo where did = 517836 and d1 = 2;
他把两条数据都删除了 这该怎么办 我只想删除第一条啊 保留第二条。

id did d1 d2 d3
44154511 517836 2
44154521 517836 2 4

img


就这个数据 我想保留第二条 只删除第一条

delete form nameinfo where id=(select id from nameinfo where did = 517836 and d1 = 2 order by id desc limit 1 ) 这样试试？？

delete form nameinfo where did = 517836 and d1 = 2 and d2 is null