Mysql PHP MyAdmin Delete Duplicate Rows
A fast and easy way to Delete duplicate rows or records. Just build the new table, Check it and then delete the old one and rename the new one. Here is the code I used in the video just edit it to meet your needs.
To answer the comment below (where I cant put a link) to see how to combine two or more tables see my video here.
• PHP MYSQL Combine Two Tables into one
CREATE TABLE new_table as SELECT * FROM cities_extended_full WHERE 1 GROUP BY city,state_code
Visit my site at http://lenfarneth.com