为矩阵创建sql表，并将csv文件插入到表中

CREATE TABLE matrix_table (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    value1 FLOAT,
    value2 FLOAT
);

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

COPY matrix_table FROM '/path/to/your/file.csv'
DELIMITER ',' CSV HEADER;

.mode csv
.import /path/to/your/file.csv matrix_table

-- 创建表
CREATE TABLE matrix_table (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    value1 FLOAT,
    value2 FLOAT
);

-- 导入CSV文件
LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE matrix_table
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;