bat批量导出mysql

mysql -u username -p password -h hostname -P port -D database_name --default-character-set=utf8 -e "SELECT * INTO OUTFILE 'exported_data.csv' FIELDS TERMINATED BY ',' FROM table_name;"

setlocal enabledelayedexpansion
set "output_path=C:\path\to\exported_data.csv"
if not exist "%output_path%" (
    echo Creating file at %output_path%
    fsutil file createnew %output_path% 0
)
mysql -u username -p password -h hostname -P port -D database_name -e "SELECT * INTO OUTFILE '%output_path%' FIELDS TERMINATED BY ',' FROM table_name;"

GRANT SELECT, LOCK TABLES, SHOW VIEW ON database_name.* TO 'username'@'hostname';
FLUSH PRIVILEGES;

@echo off
setlocal

set "username=your_username"
set "password=your_password"
set "hostname=localhost"
set "port=3306"
set "database_name=your_database"
set "output_path=C:\path\to\exported_data.csv"

if not exist "%output_path%" (
    echo Creating file at %output_path%
    fsutil file createnew %output_path% 0
)

mysql -u %username% -p%password% -h %hostname% -P %port% -D %database_name% --default-character-set=utf8 -e "SELECT * INTO OUTFILE '%output_path%' FIELDS TERMINATED BY ',' FROM table_name;"

echo Data exported successfully to %output_path%

endlocal