How to delete files with the same idduplicate data

In website operation and maintenance, multiple pieces of data with duplicate IDs sometimes appear in the database. I want to delete duplicate IDs, but no good solution has been found. This article records and describes it based on the actual situation. Please back up the data when operating the database to avoid irreversible operations and causing unexpected losses. See multiple deleting parties on the Internet