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
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is csrf token and why it is required?
How to check if a string contains a character or word in php?
What type of headers have to be added in the mail function to attach a file?
What is cms php?
Why delimiter is used in mysql?
What do you mean by core php?
Why php is used with mysql?
What are the differences between echo and print?
Define metaphone()?
How can you retrieve a cookie value?
Inside a php function, what param needs to be set in order to access a global variable?
Can I learn laravel without php?
What is global array in php?
Tell me what is htaccess?
What is the use of return in php?