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 mysql data types?
What is “i_am_a_dump” flag in mysql?
How many ways we can retrieve the date in result set of mysql using php?
Why is the basic difference between left join, right join and inner join?
How to create a trigger in mysql?
How to get help information from the server?
What do we use to remove duplicate records while fetching a data in mysql ?
what is the procedure to configure the application of mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
What is prepared statement in mysql?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
Write a query to fetch common records between two tables using mysql?
What are queries used for?
How to include comments in sql statements?
What is the difference between truncate and delete?