about foregine

Answer Posted / vishal

foreign key is the key reference of primary key in first
table suppose u have two table emp and dept in both there is
deptid than we make deptid in dept table as foreign key and
on we add dept in the dept table only when there is entry in
emp table and delete from emp only when there is no
corresponding entry in dept table

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clob datatype?

488


Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

505


Who developed mysql?

572


How to get current MySQL version?

591


What is back end and front end?

470






Which is better mysql or microsoft sql?

441


How do I stop a mysql service?

515


What is bdb (berkeleydb)?

539


How can I see mysql database?

484


Can I install mysql on mac?

526


What is delimiter in mysql stored procedure?

485


How does mysql clustering work?

485


How to get data from mysql in php?

438


How to change the database engine in mysql?

455


What are the advantages of mysql?

542