What do you mean by % and _ in the LIKE statement?

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  

---

Can a table have multiple primary keys?

0 Answers  

---

How to convert dates to character strings?

0 Answers  

---

What are the advantages and disadvantages of MySQL?

0 Answers   Satyam,

---

How can we change the name and data type of a column of a table?

9 Answers   Google,

---

Is mysqli faster than mysql?

0 Answers  

---

Can foreign key have duplicate values?

0 Answers  

---

What are date and time data types in mysql?

0 Answers  

---

How does limit work in mysql?

0 Answers  

---

Which storage engine is best in mysql?

0 Answers  

---

What is the difference between sql and mysql and oracle?

0 Answers  

---