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 (cid) references course on Update
cascade ,
primary key (sid, cid,labsection,year));
cid in takelabexam references cid in table courses.
so if i update the cid in courses table. the records
in table takelabexam which references to courses
should be updated automatically. but it doesn't work.
Could any one can help me out. i will appreciate very
much
bin
______________________________________________________________________
Find, Connect, Date! http://personals.yahoo.ca
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
