about foregine

Answers were Sorted based on User's Feedback



about foregine..

Answer / 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

about foregine..

Answer / malli

foregine key is normal key of first(base) table. in
second(child)table it is primary key which is referenced by
the first(base) table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I connect to a mysql database?

0 Answers  


Explain the difference between FLOAT, DOUBLE and REAL.

14 Answers   Yahoo,


What language is mysql written in?

0 Answers  


What is difference between mysql and mariadb?

0 Answers  


what is database black box testing? : Mysql dba

0 Answers  






How to set mysql variable in php?

0 Answers  


what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

0 Answers  


What sql does mysql use?

0 Answers  


What is the datatype of image in mysql?

0 Answers  


What are the three types of queries?

0 Answers  


Where is mysql password stored?

0 Answers  


How to use in conditions?

0 Answers  


Categories