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
How to represent ENUMs and SETs internally?
Where is mysql used?
What is table level locking in mysql?
How do I run a query in mysql?
What is dump in mysql?
Can mysql handle big data?
How triggers can be used in mysql?
How to use triggers to track changes in mysql?
What is row locking in mysql?
How do I setup a mysql database?
What is the default port for mysql and how it can change?
Is mysql better than oracle?
What is the use of mysqli_fetch_assoc?
How to see table's field formats or description of table .
What is triggers and how it can be used in mysql?