Article View: cn.bbs.comp.database
Article #294Re: ����mysqlɾ���ظ���¼
From: Galaxy��VOLUNTEERS��Database
Date: Tue, 07 Jul 2009 02:38
Date: Tue, 07 Jul 2009 02:38
33 lines
1897 bytes
1897 bytes
�����Ļ���group byŪ�������ű�ȥ,Ȼ��drop��ԭ��,rename�±� ����ֻ����rowid��С�ļ�¼,��: delete from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1) �� delete from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1) �� �� chenwl (chenwl) �Ĵ������ᵽ: ��: ��Ҫ������ֶ��ظ���ɾ����ǵ����ֶΣ����±? : name publication : -------------------------------- : author1 paper1 : author1 paper2 : author1 paper1 : author2 paper3 : ���� : ��Ҫ����author1 paper1���ظ���ɾ��������һ���� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30][m
Technical Details
Message-ID:
<4gh42e$b8k@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: ����mysqlɾ���ظ���¼ Date: 07 Jul 2009 02:38:55 GMT Organization: ��ˮ˼Դ Message-ID: <4gh42e$b8k@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1246934152.A Lines: 33