What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  

---

What are the 'mysql' command line arguments?

0 Answers  

---

What can you do with mysql?

0 Answers  

---

How to write after insert event update trigger on the same table in mysql?

0 Answers  

---

What is difference between group by and order by clause?

0 Answers  

---

Why do we use pragma autonomous transaction?

0 Answers  

---

How to create table show example

0 Answers  

---

What is the use of mysqli_fetch_array?

0 Answers  

---

Explain the different types of constraints?

0 Answers  

---

What is mysql protocol?

0 Answers  

---

What is definer in mysql trigger?

0 Answers  

---

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  

---