MySQL Tutorial 1 – Remove Duplicate Rows from MySQL Table




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


8 responses to “MySQL Tutorial 1 – Remove Duplicate Rows from MySQL Table”

  1. 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.

  2. 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.

  3. 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

Leave a Reply