Article View: cn.bbs.comp.database
Article #384Re: mysql order by ..limit �Ż�
From: Galaxy��VOLUNTEERS��Database
Date: Sun, 22 Mar 2009 10:33
Date: Sun, 22 Mar 2009 10:33
30 lines
2004 bytes
2004 bytes
1.�������ʵ����� 2.����SGA�� 3.���������� 4.ȡ����� ���һ��:���ӻ�������������... Ҳ���Բμ�: http://space.danawa.com.cn/article/35912.html ����...���Ǿ�������Դ���order by��... �� �� thatnight (��һҹ) �Ĵ������ᵽ: �� : �Աȿ��Է���ʱ�䶼������order by�ϣ����ǵ�����postings��11w����¼ʱ����ġ� : ������Ż����أ� : mysql> SELECT p.id ID, p.job_desc_title Title, p.url URL, substr(p.posting_dat : e, 1, 10) Date, : -> p.job_city_name City, : -> p.job_state_name State, : -> b.screen_name Name, b.type Type,f.name : Company,0 Online : -> FROM postings p : -> LEFT JOIN accounts b on p.account_id=b.id : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.156.69][m
Technical Details
Message-ID:
<4f7ZkQ$bmg@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,3b70826e42f7e182,start X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!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: mysql order by ..limit �Ż� Date: 22 Mar 2009 10:33:11 GMT Organization: ��ˮ˼Դ Message-ID: <4f7ZkQ$bmg@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1237717946.A