mysql 怎么导入gdb

CREATE TABLE my_table (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    age INT,
    -- 其他列...
);

LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE my_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS; -- 如果 CSV 文件包含标题行，则使用此选项

SELECT * FROM my_table;

id,name,age
1,Alice,30
2,Bob,25
3,Charlie,35

CREATE TABLE my_table (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    age INT
);

LOAD DATA INFILE '/path/to/data.csv'
INTO TABLE my_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;