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  

---

What is triggers?

0 Answers  

---

How to get last inserted id after insert data from a table in mysql?

0 Answers  

---

Which command is used to view the content of the table in mysql?

0 Answers  

---

What is the function of myisamchk?

0 Answers  

---

---

In mysql, what is the default storage engine?

0 Answers  

---

In which year mysql created?

0 Answers  

---

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

---

What is a user defined variable?

0 Answers  

---

How can you calculate the sum of any column of a table?

0 Answers  

---

What are procedures in mysql?

0 Answers  

---

What you can use regular expression for in mysql?

0 Answers  

---