ru compare the 2 null values?

2 Answers   ACC,

---

Define REGEXP?

0 Answers  

---

How many sql ddl commands are supported by 'mysql'?

0 Answers  

---

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

0 Answers  

---

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  

---

how many fields can be updated using set in a mysql query?

1 Answers  

---

How to find second highest salary from a table?

0 Answers  

---

Does adding an index lock a table?

0 Answers  

---

Restore database (or database table) from backup.

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 do I save in mysql?

0 Answers  

---

How to make a column bigger and delete unique from table.

0 Answers  

---