Navicat usage tutorial: how to delete duplicate lines with different ID in MySQL

Download the latest version of Navicat Premium

Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases simultaneously with a single program, making it more convenient to manage different types of databases.

Most duplicate records fall into two categories: repetitive meaning and non-unique keys. In the Navicat usage tutorial: how to locate and delete repeating values in MySQL, how to identify and delete repeating values involves repetitive meaning; in the Navicat usage tutorial: how to identify duplicates with non-unique keys, it involves how to identify non-unique keys. This means that two records in the same table have the same key, but may or may not have different values and meanings. This article describes how to delete rows that have duplicate data but have different keys.

Identify duplicates by type

Using the tutorial in Navicat: how to identify duplicates with non-unique keys the last query displayed in the duplicates lists all duplicates in a format that is easy to visually scan:

one