Bingo. Yeah, that works very well. Really appreciated. BTW, still curious about the reason of duplicate.:) Any thoughts?
Monet --- Jim Grill <[EMAIL PROTECTED]> wrote: > > Hello there, > > > > I tried "REPAIR TABLE" to recovery the crushed > temp > > table and that works. Thanks a lot. > > > > But, after reparation, there are some duplicated > > records generated. Is that because the temp table > has > > no primary key? Or is because the table was > crushed in > > the middle of query? > > Anyway, I tried to delete the duplicated records. > BUT, > > I can't. if I just simply delete one of duplicate > > record, then another one is deleted as well. For > > instance, there are two duplicate record with qid > = > > 3170, I delete one of them from table, confirm the > > delete, refresh table, another one disappeared > too. > > Does anyone has any idea about what happened and > what > > should I do to delete duplicate records? > > > > Many thanks for any advise. > > Monet > > > Try: > > SELECT COUNT(*) FROM table WHERE id=[your duplicate > value]; > > This will show you how many dups there are... so > let's say there were 7... > > DELETE FROM table WHERE id=[your duplicate value] > LIMIT 6; > > Now you have one left. > > I hope that helps. > > Jim Grill > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Y! Messenger - Communicate in real time. Download now. http://messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]