Article View: cn.bbs.comp.database
Article #136Re: ����һ���ܻ������
From: �F��ħ��ɳ
Date: Tue, 17 Aug 2010 09:45
Date: Tue, 17 Aug 2010 09:45
22 lines
1939 bytes
1939 bytes
CONSTRAINT MyUniqueKey UNIQUE (Name) ��http://www.java2s.com/Code/SQL/Select-Clause/SettingaUniqueConstraint.htm �� �� dashun (��˳) �Ĵ������ᵽ: �� : ���붨������һ��Լ�� : һ��������2���ֶ�A��B��������B��ֵ��ͬ�ļ�¼�У�A��ֵ�������ظ� : �ٸ����ӣ�����������ݿ����������� : id A B : -------------------- : 1 'aaa' 1 : 2 'bbb' 1 : ��ʱ����Ҫ���루3, 'aaa', 2)�ǺϷ��ģ�����Ҫ���루3, 'aaa', 1)�ǷǷ��� : �������Լ������ݿ���Ӧ����ô���ð������õ���mysql : л���� -- ��ͨ���\ħ����Ů����ɫ�ޥ����`���ѩ`�� ����ޥ����`���ѩ`���� ħ�h���ե����ʥ륹�ѩ`���� ħ��ɳ ��������˽? �������ʡ�������Ρ���Ů������ [m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.31][m
Technical Details
Message-ID:
<51OOAJ$bKh@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news1.google.com!news.glorb.com!news2.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,d753ee85059fe3fc,start X-Google-NewGroupId: yes X-Google-Attributes: gid4df683fd51,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news1.google.com!news.glorb.com!news2.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Marisa.bbs@bbs.sjtu.edu.cn (�F��ħ��ɳ) Newsgroups: cn.bbs.comp.database Subject: Re: ����һ���ܻ������ Date: 17 Aug 2010 09:45:21 GMT Organization: ��ˮ˼Դ Message-ID: <51OOAJ$bKh@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1282038259.A