IF %1.==. GOTO No1 
  
IF %2.==. GOTO No2

set dbname=%1

set root_passwd=%2

set a=.\sql\create_db_000_create_db.sql

echo create database if not exists %dbname% ; >%a

mysql --user=root --password=%root_passwd%  <%a 

for %%a in (.\sql\*.sql) do mysql --user=root --password=%root_passwd% --database=%dbname%  <%%a

GOTO End1   

:No1  
ECHO Use create_db <db name> <root password>  
GOTO End1   

:No2 
ECHO Use create_db <db name> <root password>  
GOTO End1   

:End1