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
What is a trigger? How you can create a trigger 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
Write a command to list all databases in mysql?
What is the innodb in mysql?
How do I tune a mysql query?
How will you export tables as an xml file in mysql?
What are procedures in mysql? Explain
Why myisam is faster than innodb?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
What is the date format in mysql?
Is mysql a dbms?
What is max connection in mysql?
How do we delete a row in a table?
How do I disable mysql?
Why we use mysql database?