mysql delete rows with duplicate data

8
Jul
0

DELETE
FROM table1
USING table1, table1 AS vtable
WHERE vtable.id > table1.id
AND table1.field_name = vtable.field_name

Comments (0) Trackbacks (0)

No comments yet.

Sorry, the comment form is closed at this time.