创建了一个表shiyanyong
。之后,当我试图将csv file data
加载到shiyanyong
时,我得到了Error Code: 1265.Data trancated forcolumn'income' at row 1
。
csv数据有问题吗?或者SQL代码的其他问题
同时,它与一起工作
INSERT INTO shiyanyong VALUES('AA', 0.22);
1( 表
CREATE TABLE shiyanyong(
company_name VARCHAR(40),
income DOUBLE
);
2( 加载数据:
LOAD DATA INFILE 'D:2018.csv'
INTO TABLE shiyanyong
FIELDS TERMINATED BY ','
LINES TERMINATED BY 'n'
IGNORE 1 LINES;
3(2018.csv
的数据例如:
company_name income
A 0.60
B 1.80
C 8.00
当我用LINES TERMINATED BY 'rn'
替换LINES TERMINATED BY 'n'
时,它就起作用了。