6 messages in com.mysql.lists.javaDuplicate rows
FromSent OnAttachments
Eitan Pilipski15 May 2000 10:00 
Igor Fedulov15 May 2000 10:10 
Eitan Pilipski15 May 2000 10:15 
Igor Fedulov15 May 2000 10:42 
Eitan Pilipski15 May 2000 11:06 
Eitan Pilipski17 May 2000 09:15 
Subject:Duplicate rows
From:Eitan Pilipski (eit@qualcomm.com)
Date:05/17/2000 09:15:23 AM
List:com.mysql.lists.java

Hi All,

In the last days I was looking for an easy way to remove duplicate rows so here is the final optimization:

ALTER IGNORE TABLE <table name> ADD UNIQUE <index name> (<column 1>, <column 2>, ...)

Eitan P. Ext. 57327