Saju, ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, January 21, 2003 4:27 PM Subject: re: foreign key problem
> On Tuesday 21 January 2003 09:56, Saju Pappachen wrote: > > In my MySQL I have 3 tables like this and I have a pblm. in setting the > > foreign key.Pls. help > > [skip] > > > create table employee_skill_details(EMP_ID int(10) not null references > > employee_details(EMP_ID), SKILL_ID varchar(5) not null references > > skill_master(SKILL_ID),primary key(EMP_ID,SKILL_ID)); > > > > > > Now based on this I should not be able to add an element to > > employee_skill_details table if the curresponding EMP_ID is not present in > > employee_details and SKILL_ID is not present in skill_master, because I > > have set references for it.i.e. foreign key. But still I am able to add > > data in employee_skill_details directly eventhough those data is not > > present in the other two tables. > > > > What is the problem? > > FOREIGN KEY is supported only on InnoDB tables: > http://www.mysql.com/doc/en/SEC449.html > > In your case REFERENCES do nothing, so MySQL doesn't check if corresponding > rows are existing in the parent table: > http://www.mysql.com/doc/en/example-Foreign_keys.html please look the foreign key syntax and its usage from: http://www.innodb.com/ibman.html#InnoDB_foreign_keys > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- 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
