mysql 定时运行
备份指定数据并清理
在mysql的安装目录下（D:\service\MySQL\MySQL Server 5.1\bin）运行
mysqldump -u root -pmysql -t lvshou-com? booking -w “is_index = 0 and status = 9 and neworderno is not null”? >> MeetAGeek_Orders12.txt
mysqldump -u root -pmysql-t lvshou-com? booking -w “is_index = 1 and status = 9 and ispayment = 1 and neworderno is not null”? >> MeetAGeek_Orders12.txt
mysql -u root -pmysql lvshou-com -e “;delete? FROM booking where is_index = 0 and status = 9 and neworderno is not null; delete FROM booking where is_index = 1 and status = 9 and ispayment = 1 and neworderno is not null; ”
注：为隐藏需要，可将备份的txt文件改为exe文件
【版权声明】
本站部分内容来源于互联网，本站不拥有所有权，不承担相关法律责任。如果发现本站有侵权的内容，欢迎发送邮件至masing@13sy.com 举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。
上一篇： MYSQL语法与MsSql的区别
下一篇： SqlServer连接mysql