Article View: cn.bbs.comp.database
Article #284Re: ���һ��SQL��������
From: Galaxy��VOLUNTEERS��Database
Date: Thu, 25 Jun 2009 08:33
Date: Thu, 25 Jun 2009 08:33
16 lines
1461 bytes
1461 bytes
order by��Ϊʲô��Ҫ�ظ�һ��in������ �� �� gnujava. �Ĵ������ᵽ: �� : �Ҽǵ�ԭ���ù�һ�����������SQL�����mysql�С� : select * from table where id in (29, 17, 19) order by id in (29,17,19) : id����������Ľ��������Ϊ17,19,29����������ݣ����Ұ��� 29,17,19��˳ : ���ź����� : ���Ҳ�̫�ǵ�order ... ������ôдȥ�ˣ������������䲢����ȷ�� : ��֪������λ֪��������ôд�� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.27][m
Technical Details
Message-ID:
<4gXhGk$buY@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: ���һ��SQL�������� Date: 25 Jun 2009 08:33:20 GMT Organization: ��ˮ˼Դ Message-ID: <4gXhGk$buY@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1245918766.A Lines: 15