Answer Posted / vipul dalwala

For emample we have table called DUPtable.

DESCRIBE DUPtable;

+--------+-----------------+
| Field | Type |
+--------+-----------------+
| id | Auto Increament |
| field1 | varchar(20) |
| field2 | varchar(20) |
| field3 | varchar(20) |
+--------+-----------------+

And we want to delete duplicate rows from DUPtable (Same
combination of field1, field2 and field3) .

Solution:

Step 1: Create a Temporary table;

CREATE TEMPORARY TABLE tmpDUPtable
SELECT id FROM DUPtable GROUP BY field1, field2, field3;


Step 2: Delete query to remove Rows not in 'tmpDUPtable'
table.

DELETE from DUPtable WHERE id NOT IN (SELECT id FROM
tmpDUPtable);

Step 3 DROP tmpDUPtable

DROP TABLE tmpDUPtable;


I hope this will help.

How can you make a connection with mysql server using php?

973

---

How variables are passed through arguments?

940

---

Explain object-oriented methodology in php?

993

---

What is singleton pattern in php?

888

---

What is htaccess? Why do we use this and where?

981

---

Is salary fixed or variable cost?

996

---

Tell me how to find the length of a string?

1069

---

What is the role of the .htaccess file in php?

955

---

Can php run without server?

1035

---

Explain me what are the 3 scope levels available in php and how would you define them?

1200

---

What is the string concatenation operator in php?

1102

---

How to read one character from a file?

1089

---

How to enable cURL in PHP?

1134

---

Is php faster than python?

1027

---

What is array filter php?

920

---