foreign key doesn't work with mysql

2002-03-06 Thread bin cai
> > Hello, > I am encountering one problem. I am using mysql as > the > dabase for my application. > I create a table like takeexam as following:create > table takelabexam( sid varchar(10) not null, > cid varchar(20) not null, > marks integer >

foreign key doesn't work with mysql

2002-03-06 Thread bin cai
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign

foreign key doesn't work

2002-03-06 Thread bin cai
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign