Answer / sunil kumar

Foreign key represents the relationship between two tables.
A foreign key in a table whose value is derived from the
primary key from some other table.The table in which foreign
key is defined is called a foreign table or detailed table.
The table that defines the primary key and is referenced by
the foreign table is called primary table or master table.
Difference between primary key and foreign key is that
primary key must contain a value,must not contain null
value,redundant value and foreign key can contain redundant
value.
Foreign key is defined as= create table employee(empno int
not null,empname char(40)not null,dept char(20),foreign
key(dept)references department(deptno))
Yes Foreign key is used t join two or more tables.

Answer / amol kharat

Sunil is absolutely right.

foreign key may be null but primary key is not null, foeign
key is the reference to other table.

Foreign key is a primary key of reference table.

Answer / balaji ganesh doddi

Foreign key is establish the relationship between two
tables.
Primary key is used to uniqly identified by the data into a
table.
The major differences are
Primary key should not contain null values and redundant
value.
Foreign key can contain redundant value.

Foreign key is a primary key of reference table.

Foreign key is defined as= create table employee(empno int
not null,empname char(40)not null,dept char(20),foreign
key(dept)references department(deptno))
Yes Foreign key is used t join two or more tables.

Answer / guest

yes

What is a table schema?

0 Answers  

---

How do you backup a database in mysql?

0 Answers  

---

How can we convert between Unix & MySQL timestamps?

0 Answers  

---

What are the non-standard sql commands supported by 'mysql'?

0 Answers  

---

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

0 Answers  

---

List data types in mysql? Explain

0 Answers  

---

How to check server status with 'mysqladmin'?

0 Answers  

---

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 Answers  

---

Can you tell the difference between ereg_replace() and eregi_replace()?

0 Answers  

---

How to return query output in xml format?

0 Answers  

---

What is the datatype for password in mysql?

0 Answers  

---

What is mysql data directory?

0 Answers  

---