HOW TO DELETE DUPLICATE RECORDS FROM A MYSQL TABLE BY KEEPING ONLY ONE RECORD WITH HIGHEST OR LOWEST ID VALUE
HOW TO DELETE DUPLICATE RECORDS FROM A MYSQL TABLE BY KEEPING ONLY RECORD WITH HIGHEST OR LOWEST ID VALUE Deleting duplicate records from a mysql table by keeping only record with highest or lowest id value. Here I am explaining this with an example table. Let the table name be "tbl_films" . The table has fields "fId" and "fName" tbl_films fId | fName ------------ 1 | Film1 2 | Film2 3 | Film1 4 | Film1 5 | Film3