Answer Posted / prakash.matte

If we have table 'temp' with columns: id(primary key),
field1, field2, field3, to remove the duplicate (field1,
field2, field3) data we can use either of the below queries

1. delete t1.* from temp t1, temp t2
where t1.id>t2.id and t1.field1=t2.field1 and
t1.field2=t2.field2 and t1.field3=t2.field3;

2. alter ignore table temp ADD UNIQUE INDEX
duprows(field1,field2,field3);

> here we can remove the duprows index by using the
following query:

alter table temp drop index duprows;

we can apply index on the columns as we don't require the
duplicate data, so we don't need to execute the query to
delete the index

What is difference between session and cookies in php?

971

---

What is the purpose of basename() function in PHP?

1042

---

What is a base url?

941

---

What is the Pipe Symbol represented?

1105

---

In php, how to redirect from one page to another page?

945

---

Is php harder than javascript?

1025

---

How does html form submit work?

929

---

What is the use of final class in php?

946

---

What exactly is PHP?

1026

---

What is the difference between include and require?

1016

---

What is variable function php?

1069

---

What are the uses of explode() function?

1065

---

Can php replace javascript?

1010

---

How to replace a text in a string with another text in php?

985

---

How stop the execution of a php scrip?

1026

---