备份指定数据并清理
在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文件
上一篇: MYSQL语法与MsSql的区别
下一篇: SqlServer连接mysql