最佳答案
试试这个
原文链接:https://www.f2er.com/mysql/433116.htmlDELETE FROM item WHERE GREATEST(0,@num := IF(NAME = @NAME,@num + 1,0),LEAST(0,LENGTH(@NAME := NAME)))>0