Sorry I jumped the gun, didn't realize it was a delete. The problem is that
GROUP BY does not work with DELETE. You can try this:
DELETE FROM where id IN (SELECT id from GROUP BY id HAVING
COUNT(*) > 1);
Not sure whether this will work though. You can always use a temp table for
this purpose
SELECT * from group by id having count = 1;
On May 9, 2011, at 5:45 PM, abhishek jain wrote:
> hi,
> If we have a following mysql table:
> Name - ids
> A 1
> B 1
> C 2
> D 3
>
> I want to remove all duplicate occurances and have a result like
> Name - ids
>
hi,
If we have a following mysql table:
Name - ids
A 1
B 1
C 2
D 3
I want to remove all duplicate occurances and have a result like
Name - ids
C 2
D 3
how can i do that with a query in mysql
Pl. help asap
--
Thanks and kind Regards,
Abhish