Re: mysql trigger ģ�� foreign key

Article View: cn.bbs.comp.database

Article #217

Back to cn.bbs.comp.database Previous Next

#217

From: Dem��ɫ�н��
Date: Mon, 14 Dec 2009 02:22

17 lines
1829 bytes

Ӧ������Ч��ô,��:
http://www.builder.com.cn/2006/0224/229663.shtml
�����������.
mysql> INSERT INTO zoo VALUES (1, 'Harry', 5);
ERROR 1216 (23000): Cannot add or update a child row: a foreign key 
constraint fails
��trigger�����϶���������,���ȼ��һ�²���Ч��ԭ���
 �� �� uglyCow (uglyCow) �Ĵ������ᵽ: ��
: mysql ��foreign key ò�Ʋ��������飬��������trigger ģ�⣬û����һ�о�ȥforeig
: n key ���ڱ������Ƿ���ڣ����������ȷ���ղ����ֵ�����߲�����triggerֻ�ܵ�Ӧ
: �ò�ȥ���ȼ���߼���


--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg

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

Technical Details

Message-ID: <4jO3WO$bGW@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!nx02.iad01.newshosting.com!newshosting.com!198.186.194.249.MISMATCH!transit3.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!teleglobe.net!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 4df683fd51,114da5874dac5970,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!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!nx02.iad01.newshosting.com!newshosting.com!198.186.194.249.MISMATCH!transit3.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!teleglobe.net!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����)
Newsgroups: cn.bbs.comp.database
Subject: Re: mysql trigger ģ��  foreign key
Date: 14 Dec 2009 02:22:07 GMT
Organization: ��ˮ˼Դ
Message-ID: <4jO3WO$bGW@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1260757272.A