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 many triggers are possible in mysql?
What do we use to remove duplicate records while fetching a data in mysql ?
What are triggers mysql?
How to insert dynamic values in mysql using php?
How can you create and drop view in mysql?
What is cursor in mysql?
Explain about reporting services of MYSQL?
What is mysqladmin flush hosts?
How to dump a table from a database.
Why is it called mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What does "i_am_a_dummy flag" do in mysql?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
How to filter data from a mysql database table with php?
Is mysql query case sensitive?