mysql导入单列数据

SET NAMES 'utf8mb4';
ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
LOAD DATA INFILE 'your_file.csv' INTO TABLE your_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS (your_column);

LOAD DATA INFILE '/path/to/your_file.csv' INTO TABLE your_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS (your_column);

ALTER TABLE your_table MODIFY your_column INT;
LOAD DATA INFILE 'your_file.csv' INTO TABLE your_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS (your_column);

id
1
2
3

CREATE TABLE your_table (
    id INT
);

SET NAMES 'utf8mb4';
LOAD DATA INFILE '/path/to/data.csv' INTO TABLE your_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS (id);