我使用
LOAD DATA LOCAL INFILE 'c:/AA.CSV' INTO TABLE `biz_info` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '{|||}';来从csv文件向mysql导入数据,在该文件中,第一列是ID字段的,第一列的值为5,但是导入后却是0,其他行都正确,请问这是为什么?
LOAD DATA LOCAL INFILE 'c:/AA.CSV' INTO TABLE `biz_info` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '{|||}';来从csv文件向mysql导入数据,在该文件中,第一列是ID字段的,第一列的值为5,但是导入后却是0,其他行都正确,请问这是为什么?
`id` smallint(5) unsigned default NULL,
`color_name` varchar(20) default NULL,
`color_code` varchar(6) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;导入的语句为
LOAD DATA LOCAL INFILE 'D:/pro_color.csv' INTO TABLE `pro_color` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '{|||}';可是就是不正确啊