How to delete duplicate data/Entry in database using phpmyadmin

Software Development-Company in Udaipur
How to learn Software Development in Php?
April 9, 2018
How to install/setup wordpress
July 1, 2019
Show all
If you are facing a problem with duplicate data then you need follow the below instruction and delete duplicate data from the database using Phpmyadmin
1. Open Phpmyadmin
2. Go to your database
3. click on sql menu on top
4. run below query in sql
DELETE a FROM products a INNER JOIN products b WHERE a.id < b.id  AND  a.item_id = b.item_id
here a.item_id = b.item_id it means check your duplicate column name

#Web development company in udaipur #Software development company in udaipur #Web design company in Udaipur #Digital Marketing Company in Udaipur #Best SEO Company in Udaipur #Travel Management System Software Company in Udaipur #Online Exam Portal Software Company in Udaipur #Inventory Management Software Company in Udaipur #Hotel Management System Software Development Company in Udaipur

Open chat