Re: mysql trigger ģ�� foreign key

Thread View: cn.bbs.comp.database

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Dem��ɫ�н�� Mon, 14 Dec 2009 02:22

#217

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads