mysql文件导入总结

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

bruce_wang_janet

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

阅读量660

点赞数

CC 4.0 BY-SA版权

分类专栏： Mysql 文章标签： mysql table

本文链接：https://blog.youkuaiyun.com/bruce_wang_janet/article/details/7976969

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 区别是文件一个在服务端一个在客户端