What is difference b/w composit key n primary key and
forigion key?

Answer Posted / reem

A primary key is a column which uniquely identifies the
records in a table.

A foreign key is a column (the child collumn) in a table
which has a corresponding relationship and a dependency on
another collumn (the parent collumn) that is usually in a
different table.

comosit key is more than one attribute can used as aprimary
key

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 'mysqlimport'?

522


How do I clear the screen in mysql?

523


How Switch (select or use) to a database.

538


What is a tinyint?

512


What is dblink?

483






Is mysql a backend?

521


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

1935


Write a query to retrieve a hundred books starting from 20th.

966


How do I quit mysql?

490


What does mysqli_fetch_assoc do?

487


Do while loop in mysql procedure?

494


What are the different data types in mysql?

473


What are the mysql database files stored in system ?

506


What is limit in mysql?

443


Is primary key auto increment?

526