mysql文件导入总结

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