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:
Primary Foreign key relationship in mysql.
Moderator: General Moderators
-
nadeem14375
- Forum Newbie
- Posts: 23
- Joined: Sat Oct 30, 2010 2:11 am
Re: Primary Foreign key relationship in mysql.
Which engine are you using? MyISAM does not support foreign keys.
Re: Primary Foreign key relationship in mysql.
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.