Batch Processing MySQL commands

Note: to create a TXT fileCodeCopy, modify the extension TXT to bat, and copy the BAT file to the bin folder corresponding to MySQL.

@ Echo off
ECHO is updating. Please wait ......

Set errorlevel = 0

Set path_home_mysql = "database path"
Set path_bin_mysql = % path_home_mysql % bin \

Set database_mysql = dbname

Set user_mysql = Username
Set password_mysql = userpwd

% Path_bin_mysql % mysql-U % user_mysql %-P % password_mysql % database_mysql % <dropcreatedb. SQL
% Path_bin_mysql % mysql-U % user_mysql %-P % password_mysql % database_mysql % <Bd. SQL
% Path_bin_mysql % mysql-U % user_mysql %-P % password_mysql % database_mysql % <update. SQL

EchoProgramUpdate complete.
CMD