On 3/29/2014 2:26 PM, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`icd10` char(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `icd9` (`icd9`,`id`),
UNIQUE KEY `icd10` (`icd10`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=ascii
id icd9 icd10
25 29182 F10182
26 29182 F10282
27 29182 F10982
I just can't think of a way to write a querey to delete the
duplicates. Does anyone have a suggestion ?
bill
Thanks for all the suggestions. I learned a lot, which is the
most important part of the exercise.
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql