Advanced

My sql - How to remove duplicate entries in existing table?

by barkkathulla 2013-11-08 17:53:02


DELETE gr FROM cards gr, cards gr1 WHERE gr.id > gr1.id AND gr.title= gr1.title

Here,
title->table field to remove duplicate entries


932
like
0
dislike
0
mail
flag

You must LOGIN to add comments
Tags
More...
Comments