Page 1 of 1

Primary Foreign key relationship in mysql

Posted: Sat Nov 19, 2011 12:09 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: Mon Nov 21, 2011 9:00 am
by maxx99
What storage engine do you use for your db/tables?

You can check it by executing this query:

Code: Select all

SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES

Re: Primary Foreign key relationship in mysql

Posted: Mon Nov 21, 2011 10:01 am
by Benjamin
:arrow: Duplicate = Locked