[[Rn] 7s^2]

I have the following table:

Name Address
VCR Mumbai
VCR Mumbai

Now there are 2 rows and they are duplicate.

How can I delete the second row or first row so that only one row is present?

I tried:

Delete from stud where name = 'VCR' limit 1;

But it is giving me error. Please help.

[How bout using your brain]

Don't you have a primary key defined?

[stugz]

PHP Code


<?php 
delete from yourtable
where rowid not in
(select min(rowid)
from yourtable
group by name, address); 


[[Rn] 7s^2]

@SirRootALot No bro. Otherwise it would have been super simple.

@stugz Thanks. I'll check it out and edit the post.

EDIT: What is rowid in your code?

[stugz]

rowid is a pseudo-column which can be used to find the physical address of a row.

[martin_w35]

why not just create a new table using a select statement on the original but with a distinct action.

then delete original and rename copy back to original name.

[Ropeney]

why not just create a new table using a select statement on the original but with a distinct action.

then delete original and rename copy back to original name.

Because production, bad downtime, bad habbit.