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 sharding in mysql?

0 Answers  

---

What is the difference between char and varchar in mysql?

0 Answers  

---

What is heap table in mysql?

0 Answers  

---

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 Answers  

---

Why do we use preparedstatement?

0 Answers  

---

What is mysqlcommand?

0 Answers  

---

What is the default port number of mysql?

0 Answers  

---

What is mysql server?

0 Answers  

---

Can not connect to mysql server 10060?

0 Answers  

---

What is sql in mysql?

0 Answers  

---

ru compare the 2 null values?

2 Answers   ACC,

---