mysql - How to delete duplicate records but except one for Int? -


under table records mysql, have these:

select * dbo.online; +-------+ | id    | +-------+ | 10128 | | 10240 | |  6576 | |    32 | | 10240 | | 10128 | | 10128 | | 12352 | +-------+ 8 rows in set (0.00 sec) 

how make to:

 select * dbo.online; +-------+ | id    | +-------+ | 10128 | | 10240 | |  6576 | |    32 | | 12352 | +-------+ 8 rows in set (0.00 sec) 

in other words, want is, using delete command instead of select * dbo.online group id.. so, idea how?

copy data table distinct, steop eliminates duplicates

create table backup_online select distinct *  online; 

clear source table

truncate table online 

copy data source table without duplicates

   insert online    select *    backup_online 

Comments

Popular posts from this blog

image - ClassNotFoundException when add a prebuilt apk into system.img in android -

I need to import mysql 5.1 to 5.5? -

Java, Hibernate, MySQL - store UTC date-time -