Web Talk

If you are a webmaster you know pretty well how difficult is to constantly optimize, repair and check your website or blog database  in order to  have a fast, reliable and snappy site. One of the major concerns when it comes to thinking about databases is the issue related to duplicate records. So, let’s see how to delete them safely in your SQL database.

1. The first step is to locate duplicate records in the SQL table. In this case the table’s name will be Test while the duplicate content to search for will be Duplicate_Test.
2. Let’s access the Cpanel and let’s go to PhPMyAdmin.
3. Now, we will select and click the database called Test and from there we will execute the following query:

SELECT Email_Address, COUNT(*) FROM Test
Group BY Duplicate_Test  HAVING COUNT(*) > 1

4. This string will show you all the duplicate records in your SQL table.