What is difference b/w composit key n primary key and
forigion key?
- 4 Answers
- 6519 Views
- I also Faced
- E-Mail Answers
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
Is mysql owned by oracle?
Can you tell how to find the number of rows in a resultset using php?
What is use of mysql?
In which language mysql has been written?
How to get a list of all tables in a database?
What are the 3 main types of search queries?
Where is mysql installed on linux?
How do I uninstall mysql connector?
What is mysql server?
How to change the database engine in mysql?
Is mysql running ubuntu?
What is the use of mysql_close()?
How to run 'mysql' commands from a batch file?
How to use mysqldump to create a copy of the database?
What is the datatype for password in mysql?
