Re: mysql�е�key��ʲô��˼��

Article View: cn.bbs.comp.database

Article #232

Back to cn.bbs.comp.database Previous Next

#232

From: Galaxy��VOLUNTEERS��Database
Date: Tue, 29 Dec 2009 08:18

24 lines
1998 bytes

��ѡ��
�����˵,
KEYͨ����INDEXͬ��ʡ����ؼ�������PRIMARY   KEY���ж������Ѹ���PRIMARY 
  KEYҲ����ָֻ��ΪKEY����ô����Ŀ������������ݿ�ϵͳ���ݡ� 

PRIMARY   KEY��һ��ΨһKEY����ʱ�����еĹؼ����б��붨��ΪNOT   NULL�������
Щ��û�б���ȷ�ض���ΪNOT   NULL��MySQLӦ�����ض�����Щ�С�һ����ֻ��һ��PRI
MARY   KEY�������û��PRIMARY   KEY����һ��Ӧ�ó���Ҫ���ڱ���ʹ��PRIMARY   K
EY����MySQL���ص�һ��UNIQUE���������û����ΪPRIMARY   KEY��NULL�С�

�� �� 
yangyangsss 
(yangyang) �Ĵ������ᵽ: ��: ������testʱ ����create table����������
:     PRIMARY KEY(trade_seq_num),
:     KEY (stock_code)
: �������keyֻ������ô  ����unique key.


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

[m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.97.175][m

Technical Details

Message-ID: <4jZlMC$bSh@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 4df683fd51,b3d9a5553e8c9fe9,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.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�е�key��ʲô��˼��
Date: 29 Dec 2009 08:18:46 GMT
Organization: ��ˮ˼Դ
Message-ID: <4jZlMC$bSh@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1262074668.A