Difference between CHAR and VARCHAR?

0 Answers  

---

In how many ways we can retrieve data in the result set of mysql using php?

0 Answers  

---

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

0 Answers  

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

0 Answers  

---

What is dbms in mysql?

0 Answers  

---

---

What is mysql protocol?

0 Answers  

---

What is clob in mysql

0 Answers  

---

Does mysql use t sql?

0 Answers  

---

What are the benefits of mysql?

0 Answers  

---

Is mysqli faster than mysql?

0 Answers  

---

Can we rollback truncate in mysql?

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  

---