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  

---

How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,

---

What is 'mysqlimport'?

0 Answers  

---

What is the datatype of image in mysql?

0 Answers  

---

How many rows can mysql hold?

0 Answers  

---

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

0 Answers  

---

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  

---

What is the date format in mysql?

0 Answers  

---

How do I install mysql on windows 10?

0 Answers  

---

What is mysql command line?

0 Answers  

---

Can mysql scale horizontally?

0 Answers  

---

How to present a past time in hours, minutes and seconds?

0 Answers  

---