ComputerGeek |
| MySQL delete duplicate rows from table using single query Posted: 24 Sep 2013 03:49 AM PDT MySQL delete duplicate rows from table using single query: In this article,I will show how to delete duplicate records from table using single MySQL Query. Example: I have a table contain departments (department_table). CREATE TABLE IF NOT EXISTS `department_table` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `department` VARCHAR(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MYISAM DEFAULT |
| You are subscribed to email updates from ComputerGeek To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
Post a Comment