about foregine

Question Posted / guest

2 Answers
4094 Views
I also Faced
E-Mail Answers

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

What is the difference between primary and unique key

5 Answers CSC,

What is the use of mysqli_fetch_array?

0 Answers

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers

How triggers can be used in mysql?

0 Answers

How to see table's field formats or description of table .

0 Answers

What is database engine in mysql?

0 Answers

What is mysql and mysqli?

0 Answers

What is the use of mysqli_fetch_assoc?

0 Answers

What is mysql default database?