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 convert character strings to numeric values?
What is the command used to create a database using php and mysql?
What is mysql in dbms?
How to validate email addresses in mysql?
Consider you have the following three tables which have to be linked together.
Is mysql free download?
What is difference between oracle and mysql?
What are the mysql database files stored in system ?
how to add a new column to an existing table?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
How do I start mysql in ubuntu?
How do you restart mysql?
How do I zip a file in mysql?
What are the 'mysql' command line options?
What is datatype in mysql?