+ 我來(lái)回答
回答最高可+2積分
已采納回答 / 慕用5162673
數(shù)據(jù)庫(kù)的函數(shù)
這個(gè)是不是在php等中分割字符然后比較有相同的就刪除掉然后再更新表好一點(diǎn)
2017-09-01
delete a from user1_test a join(select id, user_name,count(*) from user1_test group by user_name having count(*)>1) as b on a.user_name = b.user_name where a.id>b.id; 更容易看懂吧
2017-09-01