You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
9 lines
692 B
9 lines
692 B
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; |