how to delete duplicate rows in mysql

This post was written by admin on January 21, 2010
Posted Under: MySQL

create table newtable as
select * from oldtable where 1 group by [specific column];

Add a Comment

required, use real name
required, will not be published
optional, your blog address

Next Post: How to copy records back into original table
Previose Post: How to delete rows containing specific text string in a Mysql database