创建表:
CREATE TABLE `kfinfo` (
`Name` varchar(100) DEFAULT NULL,
`CardNo` varchar(50) DEFAULT NULL,
`Descriot` varchar(150) DEFAULT NULL,
`CtfTp` varchar(50) DEFAULT NULL,
`CtfId` varchar(50) DEFAULT NULL,
`Gender` varchar(50) DEFAULT NULL,
`Birthday` varchar(50) DEFAULT NULL,
`Address` varchar(200) DEFAULT NULL,
`Zip` varchar(50) DEFAULT NULL,
`Dirty` varchar(50) DEFAULT NULL,
`District1` varchar(50) DEFAULT NULL,
`District2` varchar(50) DEFAULT NULL,
`District3` varchar(50) DEFAULT NULL,
`District4` varchar(50) DEFAULT NULL,
`District5` varchar(50) DEFAULT NULL,
`District6` varchar(50) DEFAULT NULL,
`FirstNm` varchar(50) DEFAULT NULL,
`LastNm` varchar(50) DEFAULT NULL,
`Duty` varchar(50) DEFAULT NULL,
`Mobile` varchar(50) DEFAULT NULL,
`Tel` varchar(50) DEFAULT NULL,
`Fax` varchar(50) DEFAULT NULL,
`EMail` varchar(50) DEFAULT NULL,
`Nation` varchar(50) DEFAULT NULL,
`Taste` varchar(150) DEFAULT NULL,
`Education` varchar(50) DEFAULT NULL,
`Company` varchar(50) DEFAULT NULL,
`CTel` varchar(50) DEFAULT NULL,
`CAddress` varchar(50) DEFAULT NULL,
`CZip` varchar(50) DEFAULT NULL,
`Family` varchar(50) DEFAULT NULL,
`Version` varchar(50) DEFAULT NULL,
`id` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
windows下进入DOS界面,
#cd C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin
#mysql -u root -p(进入命令模式)
#输入密码
#use luc(选择数据库)
#LOAD DATA INFILE 'E:\\2000W\\1-200W.csv' INTO TABLE kfinfo FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '\r\n' ignore 1 lines;