🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #1766

Re: ��һ������SQL���������

#1766
From: ����
Date: Tue, 06 Dec 2005 12:05
19 lines
1309 bytes
�����ַ���
(1)������
alter table table_name
add primarykey(a,b);
(2)��Ψһ����
create unique index index_name
on table_name(col1,col2);
����Ψһ�����ǿ���Ϊnull��,���Ǹ���������

�� �� rubing (���) �Ĵ������ᵽ: ��
: ����ͨ��SQL�������ݿ��н�����
: �뽫�����ֶ����ó�����������ݲ�Ψһ
: ���������



--

�� ��Դ:��BBS Ȫ������վ http://bbs.sdu.edu.cn��[FROM: 202.194.31.*]
Technical Details
Message-ID: <4LSZJF$f88@bbs.sdu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!SDU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,b73e2d3b523b5a5c,start
X-Google-Attributes: gid101948,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!SDU
From: marking@bbs.sdu.edu.cn-SPAM.no (����)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��һ������SQL���������
Date: 06 Dec 2005 12:05:51 GMT
Organization: Ȫ������_BBS
Message-ID: <4LSZJF$f88@bbs.sdu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Database/M.1133870751.r0