MySQL批量删除数据脚本

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import os
import MySQLdb
import time
db=MySQLdb.connect(host="172.16.32.11",user="a",passwd="root1123",port=3307,charset='utf8')
cursor=db.cursor()
sql="select id from test.wqq where del_flag=0 limit 0,50000" ##根据条件找出需要删除的ID号
cursor.execute(sql)
data=cursor.fetchall()
counter=0
data_len=len(data)
for i in range(data_len):
    id=data[i][0]
    counter=counter+1
    sql2="delete from test.wqq where id="+str(id)
    cursor.execute(sql2)
    data_len=data_len-1
    if counter==10000:  ##多少事物提交一次
        db.commit()
        counter=0
        print "剩余多少%s条数据未删除" % data_len
    if data_len==1 or data_len==0: ##删除最后不满足1次事务数据
        db.commit()
        print "已经完成批量删除。。。。。"