respected sir/madam,
herein are two create statements...
1) create table key1(id integer(2) primary key ,name char(8));
2) create table key2(id integer(2),age integer(2),foreign key(id) references key1(id));
so we have two tables named key1,key2
now since i have declared id as a foreign key which references the id of key1
(primary key) , no data should be allowed to be entered if that particular id
is not on the records of key1.this happens in case of oracle ,but is not the case
in case of mysql.
now my question is ,is there anything wrong with my create statements or
it can be done in another way.
please help me out of this trouble at the earliest.
hitesh
