Page 1 of 1

Primary Foreign key relationship in mysql.

Posted: Sat Nov 19, 2011 10:07 am
by nadeem14375
Dear members,

I have the following tables with constraints:

create table test(
student_no numeric,
student_name varchar(50),
ad_date date);

alter table test
add constraint testpk primary key (student_no);

create table test2(
student_no numeric,
student_name varchar(50),
ad_date date);

ALTER TABLE test2
ADD CONSTRAINT FOREIGN KEY
(student_no)
REFERENCES test (student_no);
---------------------------------
but at the time of insertion in table test2 it don't validate from the parent table.
I am using mysql Server version: 5.1.41.

please guide me whats the problem.

Regards:

Re: Primary Foreign key relationship in mysql.

Posted: Sat Nov 19, 2011 10:46 am
by Celauran
Which engine are you using? MyISAM does not support foreign keys.

Re: Primary Foreign key relationship in mysql.

Posted: Sat Nov 19, 2011 12:47 pm
by califdon
It isn't clear what you are trying to accomplish. It doesn't make any sense to have 2 tables related in that manner. If you are trying to learn about relational tables, you will find it far more valuable to work with reasonable examples.