Answer / vishal

foreign key is the key reference of primary key in first
table suppose u have two table emp and dept in both there is
deptid than we make deptid in dept table as foreign key and
on we add dept in the dept table only when there is entry in
emp table and delete from emp only when there is no
corresponding entry in dept table

Answer / malli

foregine key is normal key of first(base) table. in
second(child)table it is primary key which is referenced by
the first(base) table.

What command is used to delete the data from the table without deleting the table structure?

0 Answers  

---

Explain Normalization concept?

2 Answers   Inuva,

---

Write a command to view mysql database table structure?

0 Answers  

---

What is the use of mysqli_fetch_array?

0 Answers  

---

What is 'mysqlimport'?

0 Answers  

---

---

Is mysqli secure?

0 Answers  

---

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,

---

What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?

1 Answers  

---

How to include numeric values in sql statements?

0 Answers  

---

What is database clustering in mysql?

0 Answers  

---

What is the hostname for mysql database?

0 Answers  

---

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?

0 Answers  

---