What is datadir?

0 Answers  

---

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,

---

What are numeric 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  

---

what is the difrence between sql and pl/sql

21 Answers   Wipro,

---

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

0 Answers  

---

What is mysql optimization?

0 Answers  

---

What storage engines are used in MySQL?

0 Answers  

---

What is mysqlcommand?

0 Answers  

---

What are the different mysql database engines?

0 Answers  

---

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 Answers  

---

What language is used in mysql?

0 Answers  

---