LOAD DATA LOCAL INFILE 'hr.csv' INTO TABLE hr_analytics FIELDS TERMINATED BY '`' IGNORE 1 LINES(NO,SATISFACTION_LEVEL,LAST_EVALUATION,NUMBER_PROJECT,AVERAGE_MONTLY_HOURS,TIME_SPEND_COMPANY,WORK_ACCIDENT,LEFT,PROMOTION_LAST_5YEARS,SALES,SALARY)
LOAD DATA LOCAL INFILE 'hr.csv' INTO TABLE hr_
阅读背景：
无法从csv加载到mysql表？
来源：互联网
分享到：
