Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Creating Tables and Manipulating Data with SQL Inserting, Updating and Deleting Rows

igsm '
igsm '
10,440 Points
Posted by igsm '
igsm '
10,440 Points

Delete duplicates in MySQL

Hey! I've created duplicates while following instructions of the lecture. We covered 'delete' function. How to use this function in order to delete duplicates and leave unique values (one version of data entry)? Thanks

2 Answers

shawn stokes
shawn stokes
5,651 Points
shawn stokes
shawn stokes
5,651 Points

DELETE FROM your-table WHERE id = number-here LIMIT 1; this is basically how you set it up.

shawn stokes
shawn stokes
5,651 Points
shawn stokes
shawn stokes
5,651 Points

duplicate columns row or database? DROP or DELETE is what you will want to use but as to how you will want to do it that will be based on what you want to remove http://dev.mysql.com/doc/refman/5.6/en/drop-table.html https://dev.mysql.com/doc/refman/5.0/en/delete.html

igsm '
igsm '
10,440 Points
igsm '
igsm '
10,440 Points

I meant data entries (rows)