SQL语句如下:
LOAD DATA LOCAL INFILE 'D:\\文档\\175.csv' (文件路径)
INTO TABLE yang(表名)
CHARACTER SET utf8
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
ignore 1 rows:表示忽略第一行,这是由于第一行一般为表头
SQL语句如下:
LOAD DATA LOCAL INFILE 'D:\\文档\\175.csv' (文件路径)
INTO TABLE yang(表名)
CHARACTER SET utf8
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
ignore 1 rows:表示忽略第一行,这是由于第一行一般为表头