sql = "LOAD DATA LOCAL INFILE '%s' INTO TABLE %s FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\\r\\n' IGNORE 1 LINES" % (file_path, MYSQL_TABLE_NAME)
文件的字段由FIELD TERMINATED BY ','指示的逗号终止,
并由ENCLOSED BY '"'指定的双引号括起来。
因为文件第一行包含列标题,列标题不需要导入到表中,
因此通过指定IGNORE 1 ROWS选项来忽略第一行。