mysql -uxx -pyyy

    select count(id) from lottery.mop_bet_order_history where created_at < '2015-11-01' and created_at > '2015-10-01';

    delete from lottery.mop_hot_history where created_at < '2015-11-01' and created_at > '2015-10-01';



先查询表中指定条件的数据有多少条，再delete删除。