You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
334 B
Batchfile
18 lines
334 B
Batchfile
@ECHO OFF
|
|
|
|
SET dbhost=127.0.0.1
|
|
SET dbuser=root
|
|
SET dbpasswd=Leaper@123
|
|
SET dbName=test
|
|
set sqlfile=C:\Users\Peter\Desktop\lia_duoji.sql
|
|
|
|
cd D:\hzleaper_auto_install\mysql-5.7.33-winx64\bin
|
|
|
|
::执行SQL脚本
|
|
@ECHO Start!
|
|
mysql -h%dbhost% -u%dbuser% -p%dbpasswd% < %sqlfile% --default-character-set=utf8
|
|
|
|
ECHO OK!
|
|
PAUSE
|
|
|
|
@ECHO Done! |