Article View: cn.bbs.comp.database
Article #9197Re: ����ʲ�����
From: ����~! ����
Date: Sun, 31 Aug 2003 04:47
Date: Sun, 31 Aug 2003 04:47
28 lines
2286 bytes
2286 bytes
���
���������֮������ù�ϵ��
���磺
�������?student��teacher
teacher�ṹ���£�teacher(id primary key,name,age,address)
student�ṹ���£�student(id primary key,name,class,teacherid)
alter table student create foreign key teacherid reference teacher.id
�����õı�ļ������Ψһ�ģ�student��teacherid�ض���teacher�����ж�Ӧ��ֵ��
����Ŀ����Ϊ�˱�֤���һ���ԡ�
�� �� tiancai (tiancai) �Ĵ������ᵽ: ��
: Ŷ������
: ����û��ѧ�á�������
: ���ڶ��Dz������ˡ�������
: �� �� handi. �Ĵ������ᵽ: ��
: : ת��վ: SJTU!news.neu.edu.cn!news.feeling.smth.org!maily.cic.tsinghua.edu...
: : ��һ��Ψһ,���Զ������⽡Լ��
: : �� �� hongliang.bbs@bbs.sjtu.edu.cn (����) �Ĵ������ᵽ: ��
--
�ӱ������ �Ӳ�ȥ������ �ٲ��˱���ûһ������
�������� ���ñ��� ���˵� ���˵� ������
Ҳ���� Ҳǣ�� Ҳ���ǰ취 ��Ҳ�� ��Ҳ�� ������
������ ���������� �ݺ�һ�������˰�
[m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.242.186.66][m
Technical Details
Message-ID:
<485TeA$amg@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!news.neu.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,6e499bc6b8fdcc9a,start X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-08-30 21:48:04 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!news.neu.edu.cn!SJTU From: poorboy.bbs@bbs.sjtu.edu.cn (����~! ��У��) Newsgroups: cn.bbs.comp.database Subject: Re: ����ʲ����� Date: 31 Aug 2003 04:47:20 GMT Organization: ��ˮ˼Դ Message-ID: <485TeA$amg@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1062304906.A Lines: 28