MySQL Tutorial 1 – Remove Duplicate Rows from MySQL Table d4mer MySQL September 23rd, 2017 8 Comments 47 views How to remove duplicate rows from a MySQL database table. The process should be similar for other kinds of databases I imagine. Have a wonderful day and … Original source Link to this post! Tags mysql tutorial, remove duplicate rows Share : tweet Previous Next About the : d4mer Related Posts MySQL Tutorial- 23강 제약조건(Constraint) October 21st, 2017 MYSQL VERBINDUNG IN EUREM PLUGIN AUFBAUEN | TUTORIAL October 21st, 2017 JDBC Tutorials – 4 – How Insert Row into MySQL table using Java JDBC October 20th, 2017 MySQL Tutorial- 12강 문자열 함수(String function) October 20th, 2017 Login and Registration page in PHP and MySQL – Part 3 October 20th, 2017 PHP Calendar Script Tutorial October 19th, 2017 8 Comments Daniel Bachmann September 23, 2017 at 10:43Log in to Reply Thanks for giving me the right idea. However I had a table with one column that I needed unique/primary and really many additional columns. I copied the structure to a new table, made the one column primary and used:INSERT IGNORE INTO <new_table> SELECT * FROM <old_table>to not have to declare the whole columns (159 total, this wasn't my design). Maybee someone can use this. Quy Nguyen September 23, 2017 at 10:43Log in to Reply Perfect! Thank u so much !!! Pourya Da September 23, 2017 at 10:43Log in to Reply This is exactly what I was looking for. Thank you test September 23, 2017 at 10:43Log in to Reply It doesn't delete duplicate rows!!!!! It deletes rows based on distinct port_code!!!! The distinct function takes only the first attribute from the list which in your case is the port_code and it does not check for the rest of the columns. wieszcpj September 23, 2017 at 10:43Log in to Reply of course you are only going to get that 45454 or what ever number it was. you failed to open the original table back up but instead went to port codes2 table and copied that right over. so you might want to redo your video so at least you are showing the right thing on the screen when you do this. thanks Anthony Vipond September 23, 2017 at 10:43Log in to Reply of course it gets rid of them bud, once you have a table with unique rows, you can drop the other tables 🙂 stevedawg85 September 23, 2017 at 10:43Log in to Reply so this doesn't actually delete them? it just moves them to a dummy unused table by taking them out? robert johnson September 23, 2017 at 10:43Log in to Reply rock onnnnnnnnnnn Leave A Comment Click here to cancel reply. You must be logged in to post a comment.