How to use sum function in where clause in mysql?

0 Answers  

---

What is the difference Delete and Drop ?

6 Answers  

---

all the queries used in sql

0 Answers   TCS,

---

Write a query to stop mysql in unix

0 Answers  

---

Is pdo more secure than mysqli?

0 Answers  

---

---

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

0 Answers  

---

How many columns is too many mysql?

0 Answers  

---

What is pdo connection?

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  

---

What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  

---

What is a transaction? Describe mysql transaction properties.

0 Answers  

---

What is session variable in mysql?

0 Answers  

---