python mysql结果查询
def ShowDelData():
try:
conn=MySQLdb.Connect(host='localhost',user='po',passwd='password',db='test',charset = 'utf8',port = 3306)
cur=conn.cursor()
count = cur.execute('select * from testtable')
print '共有 %s 条记录'%count
results = cur.fetchall()
for r in results:
a=0
while a < len(r):
print r[a]
a=a+1
print " "
cur.execute('drop table testtable')
print'数据表删除完成（每次搜索结果都新建表，搜索结束删除)'
cur.close()
conn.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
try:
conn=MySQLdb.Connect(host='localhost',user='po',passwd='password',db='test',charset = 'utf8',port = 3306)
cur=conn.cursor()
count = cur.execute('select * from testtable')
print '共有 %s 条记录'%count
results = cur.fetchall()
for r in results:
a=0
while a < len(r):
print r[a]
a=a+1
print " "
cur.execute('drop table testtable')
print'数据表删除完成（每次搜索结果都新建表，搜索结束删除)'
cur.close()
conn.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
科大讯飞公司氛围 260人发布
投递亚信科技（中国）有限公司等公司7个岗位