junkone1(at)gmail(dot)com wrote:
> hI
> i have a bad situation that i did not have primary key. so i have a
> table like this
> colname1 colname2
> 1 apple
> 1 apple
> 2 orange
> 2 orange
>
> It is a very large table. how do i remove the duplctes quickly annd
> without much change.
Make a new table (with a primary key) and the same columns in order,
and do: INSERT INTO newtable SELECT DISTINCT * FROM oldtable;