16 lines
482 B
Batchfile
16 lines
482 B
Batchfile
@echo off
|
|
set MYSQL_PATH="C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe"
|
|
set SQL_FILE="D:\klp-oa\engineering-management-ruoyi\RuoYi-Vue\sql\ry_engineering.sql"
|
|
set DB_NAME=engineering
|
|
set DB_USER=root
|
|
set DB_PASS=147123369A
|
|
|
|
echo Executing SQL script...
|
|
%MYSQL_PATH% -u %DB_USER% -p%DB_PASS% --default-character-set=utf8mb4 %DB_NAME% < %SQL_FILE%
|
|
|
|
if %ERRORLEVEL% equ 0 (
|
|
echo SQL script executed successfully!
|
|
) else (
|
|
echo Failed to execute SQL script.
|
|
pause
|
|
) |