刪除mysql數(shù)據(jù)庫(kù)中的重復(fù)數(shù)據(jù)記錄

mysql中select distinct * from text不能顯示不重復(fù)的記錄,而是直接全部顯示

采用的是下面的方法可刪除,假設(shè)重復(fù)的是test數(shù)據(jù)庫(kù)中的title字段
代碼如下:
create table bak as (select * from test group by title having count(*)=1);
insert into bak (select * from test group by title having count(*)>1);
truncate table test;
insert into test select * from bak;