1

Sorry if this has already been answered but I cannot find the solution I am looking for.

I am not great with coding but know a bit but cannot figure this out

I have an opencart database and sometimes get duplicate records/products imported and what I am trying to do is schedule a task to delete any duplicates records leaving the original/first record in the database. So delete any new records that are duplicates.

Is this possible? any help is appreciated.

Kirk Beard
  • 9,569
  • 12
  • 43
  • 47
gmozzer
  • 11
  • 1
  • 3
    Tag your question with the database you are using. Also show examples of the records and what you mean by duplicated. – Gordon Linoff Feb 27 '17 at 12:24

1 Answers1

0

Opencart is an online store management system. It is PHP-based, using a MySQL database and HTML components.

In MySQL you have a specific topic regarding duplicate rows removal:

Delete all Duplicate Rows except for One in MySQL?

Community
  • 1
  • 1
UltraCommit
  • 2,236
  • 7
  • 43
  • 61