MYSQL ICD10 Tables

Question

Where can I find ready mysql for ICD-10 since I am developing a healthcare system. I found the lists from WHO, but is there any place that can give a ready-made table for faster implementation with the mysql database.

Answer 1

ICD10 code can be found at http://www.who.int/classifications/icd/en/ .

Here are the steps for loading ICD 10 code into the MySQl database. (credit must comply with http://fash7y.wordpress.com/2012/04/05/import-icd-10-to-mysql-database/ )

• Go to the Download Classification section from http://www.who.int/classifications/icd/en/ And yes, you need to log in first.

• Select 2010 ICD-10 with the Plain text tabular.

   CREATE TABLE IF NOT EXISTS `tb_data_icd` ( `col1` int(1) DEFAULT NULL, `col2` varchar(1) DEFAULT NULL, `col3` varchar(1) DEFAULT NULL, `col4` int(2) DEFAULT NULL, `col5` varchar(3) DEFAULT NULL, `col6` varchar(6) DEFAULT NULL, `col7` varchar(5) DEFAULT NULL, `col8` varchar(4) DEFAULT NULL, `col9` varchar(185) DEFAULT NULL, `col10` varchar(5) DEFAULT NULL, `col11` varchar(5) DEFAULT NULL, `col12` varchar(5) DEFAULT NULL, `col13` varchar(5) DEFAULT NULL, `col14` varchar(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; load data local infile 'D:/dev/ICD10/plain/codes.txt' into table tb_data_icd fields terminated by ';' enclosed by ';' lines terminated by '\n' (col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14);