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 returns the columns and column information pertaining to the designated table.
What are the advantages/disadvantages of mysql and php?
How can you change the password of a mysql user?
What is schema in mysql?
Write a query to find duplicate rows in table?
What does mysql flush tables do?
What is a delimiter in mysql?
Write a query to retrieve a hundred books starting from 20th.
Explain the different types of constraints?
How to Join tables on common columns.
What are the method you will follow while sql installing
How do I save in mysql?
What is the function of myisamchk?
What are the ways in which you can retrieve data in the result set of mysql using php?
What is the use of mysql_close()?