Window平台下,MYSQL定时执行SQL语句

1. 将下面SQL语句,保存为delete.sql;
use qdcomland;
delete from cdb_product where id=33;


2.将下面指令保存为批处理文件del.bat

@echo off
D:\AppServ\MySQL\bin\mysql -hlocalhost -uroot -proot < delete.sql

注意,delete.sql和del.bat保存在再一个目录下,如果不在同一目录下,最好用绝对路径,如:
@echo off
D:\AppServ\MySQL\bin\mysql -hlocalhost -uroot -proot < c:\delete.sql

3.建立windows 计划任务,定时执行del.bat