23 Led
MySQL – Remove Duplicate Data or Rows
DELETE FROM mytable
USING mytable, mytable as virtualtable
WHERE (NOT mytable.id=virtualtable.id)
AND (mytable.fieldname=virtualtable.fieldname)
Simple isn’t it?
DELETE FROM mytable
USING mytable, mytable as virtualtable
WHERE (NOT mytable.id=virtualtable.id)
AND (mytable.fieldname=virtualtable.fieldname)
Simple isn’t it?