USE contest; LOAD DATA INFILE 'C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Uploads\\Repositories_with_label.csv' --当时导入数据所在的文件地址,注意更改 INTO TABLE lable CHARACTER SET UTF8MB4 FIELDS TERMINATED BY ',' -- 字段用逗号分隔 ENCLOSED BY '"' -- 如果字段值被双引号包围,则指定此选项 LINES TERMINATED BY '\n' -- 行用换行符分隔 IGNORE 1 ROWS -- 忽略第一行 (nameWithOwner, stargazerCount, createdAt, updatedAt, pushedAt, isArchived, isFork, archivedAt, isTemplate, licenseInfo, primaryLanguage, repositoryTopics, @var1, @var2, @var3) -- 指定要导入的列,与 CSV 文件中的列对应。 SET description = NULL;