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
How to include numeric values in sql statements?
How do I select a database in mysql workbench?
How do I change directories in mysql?
How would you enter characters as hex numbers?
What is mysql and why it is used?
Write a command to list all databases in mysql?
What is pdo :: fetch_assoc?
Can we store images in mysql database?
How do I view tables in mysql workbench?
How is mysql database stored?
How do you rename a table in mysql?
What is text in mysql?
What is clob in mysql
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
Can I use mysql for free?