mysql除重复记录实用代码，只保留一条

create table tmp001 as select min(jid) as col1 from xiweb_xxx group by tname;
delete from xiweb_xxx where jid not in (select col1 from tmp001);
drop table tmp001;

min()为保留最小jid的记录

create table tmp001 as select min(jid) as col1 from xiweb_xxx group by tname;<br />delete from xiweb_xxx where jid not in (select col1 from tmp001); <br />drop table tmp001;<br /><br />min()为保留最小jid的记录