LOAD DATA LOCAL INFILE 'C:\\Users\\900004\\Desktop\\test_1.csv'
INTO TABLE test_from
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(ID, STR01, STR02, STR03, STR04, STR05, STR06, STR07, STR08, STR09);
MySQL大批量快速从文件导入数据库
最新推荐文章于 2024-09-27 17:00:01 发布