How many primary keys can be there in a table?

0 Answers  

---

What is the latest mysql?

0 Answers  

---

What is difference between unix timestamp and mysql timestamp?

0 Answers  

---

How can we know the number of days between two given dates using MySQL?

2 Answers   Base2 Infotech, Webworks,

---

What is definer in mysql?

0 Answers  

---

---

Can you tell how many values can set the function of mysql to consider?

0 Answers  

---

What is meant by decimal (5,2)?

0 Answers  

---

What is prepare statement in mysql?

0 Answers  

---

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  

---

What are date and time data types?

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  

---

How to do login in mysql with unix shell.

0 Answers  

---