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;