bat程序如下,今天刚学的dos皮毛,不知道哪里错了,请各位大虾指教- @echo off
- set XLS2CSV_HOME=tools
- set DBUSER=root
- set DBPASSWORD=123456
- set DBNAME=wjjs
- set TBNAME=marry_new.csv
- set XLSFILEPATH=xlsNcsv
- set CSVFILEPATH=%cd%\%XLSFILEPATH%\%TBNAME%
- rem 这里是将xls转csv,已经成功生成csv文件
- for /r %XLSFILEPATH% %%i in (*.xls) do @%XLS2CSV_HOME%\xls2csv.exe %%i utf-8
- rem 这里是将生成的csv文件逐个重命名为表名,再用mysqlimport倒入mysql,最后删掉csv,就是这里出错了,但不知道哪里错,囧
- for /r %XLSFILEPATH% %%i in (*.csv) do ( ren %%i %TBNAME% && call mysqlimport.exe -u%DBUSER% -p%DBPASSWORD% --fields-enclosed-by=\" --fields-terminated-by=; --lines-terminated-by=\r\n %DBNAME% %CSVFILEPATH% && del %XLSFILEPATH%\%TBNAME% )
- pause
复制代码
|