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
What are date and time data types in mysql?
How to start mysql server?
Does mysql support nosql?
What is the latest version of mysql?
What are the different column comparison operators in mysql?
Can I use mysql for free?
How do I install mysql on windows 7?
What is blob datatype in mysql?
Does mysql automatically index foreign keys?
What is mysql common?
What is the role of a limit in a mysql query?
What is the use of innodb in mysql?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is user in mysql?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?