How to delete duplicate data/Entry in database using phpmyadmin
How to learn Software Development in Php?
April 9, 2018
How to install/setup wordpress
July 1, 2019If 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
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
Related posts
September 12, 2023