Web Haunt

Web Development Tutorials & Web Developer Resources

Skip to content
Menu
  • Home
  • PHP
    • Installation and Configuration
  • Live Demos

Tag: delete duplicate data

How to delete duplicate rows in a MySQL Database

Posted onAugust 22, 2016January 3, 2021by WebHaunt Team
In this tutorial I am sharing the code how to delete duplicate entries from MySQL database based on a field_name. Below SQL script creating table in a MYSQL database: CREATE TABLE IF NOT EXISTS `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `item_code` varchar(255) NOT NULL, `cat_id` int [...]
Read More

Latest Posts

  • Create Pagination Using PHP and MySQL
  • To-Do List Application Using PHP, MySQL and AJAX
  • NodeJS Login and Registration Rest API with MongoDB
  • Build a Contact Form in CodeIgniter with Email
  • Compress Image Before Upload using PHP
Copyright © 2016 - 2025 WEBHAUNT.COM All rights reserved.