bat文件中查询mysql

@echo off
setlocal

REM 设置MySQL连接参数
set MYSQL_HOST=localhost
set MYSQL_USER=root
set MYSQL_PASS=password
set MYSQL_DB=mydatabase

REM 执行SQL查询
mysql -h%MYSQL_HOST% -u%MYSQL_USER% -p%MYSQL_PASS% %MYSQL_DB% -e "SELECT * FROM mytable"

endlocal

@echo off
setlocal

REM 设置MySQL连接参数
set MYSQL_HOST=localhost
set MYSQL_USER=root
set MYSQL_PASS=password
set MYSQL_DB=mydatabase

REM 执行SQL查询
mysql -h%MYSQL_HOST% -u%MYSQL_USER% -p%MYSQL_PASS% %MYSQL_DB% -e "SELECT * FROM mytable" 2>error.log

REM 检查是否有错误
if %errorlevel% neq 0 (
    echo 查询失败，请查看 error.log 文件
) else (
    echo 查询成功
)

endlocal