方法1

将downloads目录下面的reviews.csv插入到reviews表. 并忽略第一行. 以\r\n为换行

LOAD DATA LOCAL INFILE
'Users/xiukun/Downloads/reviews.csv'INTO TABLE steam reviews
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\r\n"
IGNORE 1 LINES
(afield, bfield, cfield)

方法2

使用mysqlimport

mysqlimport --ignore-lines=1 \
            --fields-terminated-by=, \
            --local -u root \
            -p Database \
             TableName.csv