What is difference b/w composit key n primary key and
forigion key?
Answer Posted / sathish
Assume a table contains columns
book name
author name
price
>>composite key
Having multi column primary key for a single table is known as composite key.
ex: primary composite key is book name and author name
>>primary Key
Primary key is the unique key, do not accept null value and used as a id to fetch the record from the table.
>> Foreign Key
A primary key of a table which is used as a reference key of another table..
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Write a query to find duplicate rows in table?
How to enable or disable a row of a table using MySQL in struts?
What is mysql_connect?
What language is used in mysql?
What is the use of procedure in mysql?
What is mysql installer?
What is triggers?
What is the full form of mysql?
How to set mysql variable in php?
What do you need to connect php to mysql?
How triggers can be used in mysql?
How would you get the current date in mysql?
Is oracle better than mysql?
How is data stored in mysql?
What are date and time intervals?