Hi, On Thu, 2002-03-07 at 08:20, bin cai wrote: > 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
http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- 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
