bat脚本操作数据库

bat文件

"D:\Program Files\mysql-8.0.19-winx64\bin\mysql.exe" -uroot -h 192.168.1.52 -p123456 gantrycranes_qqctn<"C:\Users\leohe\Desktop\deleteVesselInfo.sql">>D:\dblog.txt 2>&1
pause

 

sql文件

USE `gantrycranes_qqctn`;
delete from berth_plan where (TO_DAYS(NOW()) - TO_DAYS(create_time))>=15;
delete from vessel_listing where (TO_DAYS(NOW()) - TO_DAYS(create_time))>=15;
delete from vessel_crane where (TO_DAYS(NOW()) - TO_DAYS(create_time))>=15;