bat 处理mysql入库

@echo off
echo.
set dbUser=root
set dbPasswd=admin123
set host=localhost
set port=3306

echo please input the sql file.
set /p sqlFile=

rem 定义数据库名称。默认格式：test20190326_150501
rem set dbName=test%date:_0,4%%date:5,2%%date:_{8,2%_%time:}0,2%%time:_3,2%%time:6,2%
set dbName=test_%time:_0,2%%time:3,2%%time:~6,2%

set startTime=%time:_0,2%%time:3,2%%time:~6,2%

rem 创建数据库
mysqladmin -u%dbUser% -p%dbPasswd% -h%host% -P%port% create %dbName%

rem 导入数据
mysql -u%dbUser% -p%dbPasswd% -h%host% -P%port% --default-character-set=utf8 %dbName% < %sqlFile%

set endTime=%time:_0,2%%time:3,2%%time:~6,2%

rem 统计执行时间
set /a times=%endTime%-%startTime%

rem 打印生成的新数据库
echo The new Database:%dbName%
rem 打印消耗时间
echo the ^time for input:%times% seconds

pause