中英词典 mysql_英汉字典(含音标)csv导入MySQL

创建数据表:

CREATE TABLE `tb_words_dict` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`word` varchar(164) COLLATE utf8_bin NOT NULL,

`sw` varchar(64) COLLATE utf8_bin NOT NULL,

`phonetic` varchar(64) COLLATE utf8_bin DEFAULT NULL,

`definition` text COLLATE utf8_bin,

`translation` text COLLATE utf8_bin,

`pos` varchar(16) COLLATE utf8_bin DEFAULT NULL,

`collins` varchar(11) COLLATE utf8_bin DEFAULT '0',

`oxford` varchar(11) COLLATE utf8_bin DEFAULT '0',

`tag` varchar(64) COLLATE utf8_bin DEFAULT NULL,

`bnc` varchar(11) COLLATE utf8_bin DEFAULT NULL,

`frq` varchar(11) COLLATE utf8_bin DEFAULT NULL,

`exchange` text COLLATE utf8_bin,

`detail` text COLLATE utf8_bin,

`audio` text COLLA