Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference b/w composit key n primary key and
forigion key?
- 4 Answers
- 7790 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
What is the purpose of using ifnull() function?
What is the datatype of image in mysql?
What is difference between mysql and mysql server?
How do I zip a file in mysql?
What is memory table in mysql?
What is inner join in mysql?
Which software is used for mysql?
What is default password for mysql?
What is a blob datatype?
What is an example of a delimiter?
How do I switch users in mysql?
How many rows we can insert in a mysql table?
What is the hostname for mysql database?
What is triggers?
What is mysql and how it works?
