mysql文件导入总结

最新推荐文章于 2023-08-19 09:02:45 发布

原创最新推荐文章于 2023-08-19 09:02:45 发布 · 661 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #table

Mysql 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一种使用Notepad进行正则替换的方法，以批量生成用于将CSV文件导入MySQL数据库的SQL语句。通过这种方式可以有效地提高数据导入效率，并讨论了LOAD DATA INFILE与LOAD DATA LOCAL INFILE的区别。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. 执行dir /S /W 得到此目录的文件名，只有文件名

2. notepad 正则替换^ $得到如下

LOAD DATA INFILE 'D:/_263_201110180000_201110190000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_263_201110190000_201110200000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_264_201110180000_201110190000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_264_201110190000_201110200000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_265_201110180000_201110190000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_265_201110190000_201110200000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_266_201110180000_201110190000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_266_201110190000_201110200000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_267_201110180000_201110190000.csv' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;
LOAD DATA INFILE 'D:/_267_201110190000_201110200000.csv ' INTO TABLE TESTTABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES ;

3. LOAD DATA INFILE 和LOAD DATA LOCAL INFILE 区别是文件一个在服务端一个在客户端