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  

---

Explain what is mysql?

0 Answers  

---

Explain federated tables?

3 Answers   Tech Mahindra,

---

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,

---

What is the difference between char and varchar data types?

6 Answers  

---

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

0 Answers  

---

How do I setup mysql?

0 Answers  

---

What is an index? How can an index be declared in mysql?

0 Answers  

---

what are the different tables present in mysql? : Mysql dba

0 Answers  

---

What is the diff. bwt. primary key and unique key?

4 Answers  

---

How to dump a table to a file with 'mysqldump'?

0 Answers  

---

How to enter numeric values as hex numbers?

0 Answers  

---