python操作mysql

from conn import conn,c
from draw import *
from config import *
import pyExcelerator

sql = "SELECT DISTINCT km FROM %s WHERE station != '李官' and  type = '变形' " %T_SENSOR
count = c.execute(sql)

print u'一共有%s行记录' %count

result=c.fetchone()
print result

results=c.fetchmany(5)
for r in results: print r

print '=='*10
c.scroll(0,mode='absolute')

kms = c.fetchall()