3万条的CSV文件,只导入了7000多条,怎么回事
LOAD DATA
INFILE '/home/applprd/migration/ss.csv'
APPEND INTO TABLE cmcc_hr_oa_salary_0611
FIELDS TERMINATED BY ","
(emp_number,sal_date,sal_type,segment10,segment11,segment12,segment13,segment14,segment15,segment16,segment17,segment18)
LOAD DATA
INFILE '/home/applprd/migration/ss.csv'
APPEND INTO TABLE cmcc_hr_oa_salary_0611
FIELDS TERMINATED BY ","
(emp_number,sal_date,sal_type,segment10,segment11,segment12,segment13,segment14,segment15,segment16,segment17,segment18)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货