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?