Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Delete duplicate row in table

    @dinesh.singh
    Recommendations Offline Message

    • 0
    • 2
    • 3
    • 1
    • 0
    • 0
    • 0
    • 0
    • 332
    Comment on it

    You can delete the duplicate row without using the temporary table. You can use the self join concept.

    Suppose we have person table contain 3 columns named id, name, and city. INSERT INTO person(id,name,city) VALUES (1,'a', 'aa'), (2,'b','bb'), (3,'d','dd'), (4,'d','dd'), (3,'a','aa');

    Now we have to delete the duplicate row from table. You can see the duplicate record from following query: 

    select * from person  p1, person p2 where  p1.id >  p2.id;

    Now you can delete duplicate recored using the following query.

    delete from person  p1, person p2 where  p1.id >  p2.id;

    Hope this will help you.

    mysql delete query self join
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: