python针对mysql长文本一分多行

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import MySQLdb
db = MySQLdb.connect("localhost","root","123456","job_5_9",charset='utf8')


cursor = db.cursor()

sql = "select id,name,sex from court_ktgg_towash7_3_1 where content like '%本院定于%本院定于%'"

cursor.execute(sql1)
data = cursor.fetchall()
print data
for line in data:
    a = line[0].split(u"一案。")  #按需要切分的关键字， 汉字要加转义符 
    b = line[1]
    c = line[2]
    for aa in a:
    print aa
sql="insertintocourt_ktgg_towash5_1(id,name,sex)values('%s,%s','%s')" % (a,b,c)
#sql   存入库中
        cursor.execute(sql3)  #提交执行
        db.commit()
        print "入库完毕"
        db.rollback()


db.close()