Question

python中的sql语句无法执行的原因

从mysql数据库中读取数据，出现sql语句查询错误，sql语句在终端下运行可以正确得出查询结果
源码
cur.execute("select hostid from hosts where host = %s",(remotehost)) #取出主机名
rows = cur.fetchone()
try :
hostid = rows[0]
except :
pass

cur.execute("select itemid from items where hostid = %s and key_='system.cpu.util[,idle]'",(hostid))
rows = cur.fetchone()
try:
itemid = int(rows[0])
except:
pass

cur.execute("select value from history where itemid = %s and clock>%s and clock <=%s",(itemid,t2,t1))
rows = cur.fetchone()
try :
cpu = str(rows[0])
except:
pass

cur.execute("select itemid from items where hostid = %s and key_='system.cpu.util[,softirq]'",(hostid))
rows = cur.fetchone()
try:
itemid = int(rows[0])
except:
pass

cur.execute("select value from history where itemid = %s and clock>%s and clock<=%s",(itemid,t2,t1))
rows = cur.fetchone()
try:
softirq = str(rows[0])
except:
pass

cur.execute("select itemid from items where hostid = %s and key_= %s",(hostid,item))
rows = cur.fetchone()
try:
itemid = int(rows[0])
except:
pass

cur.execute("select value from history where itemid = %s and clock>%s and clock<=%s",(itemid,t3,t1))
rows = cur.fetchone()
try:
outgoing =float(rows[0])
outgoing = outgoing/1000
outgoing = str("%.2f"%outgoing)
except :
print "select value from history where itemid =",itemid," and clock>",t3," and clock<=",t1 #把错误的sql语句打印出来
pass

Answer 1

1. 请给出具体的报错信息

2. 根据报错行号，给出其附近的代码
   

追问

报错就是rows为空，我把异常输出的结果  在mysql终端下运行，可以得出结果

追答

请给出具体的报错信息，包括在except中print的语句。

Answer 2

具体报啥错？

追问

麻烦您看看楼上的图片

追答

你的正常代码（try部分），并没有print代码，当然不会显示出来。