- 论坛徽章:
- 0
|
下面这句很简单的sql语句,但试了很多种方式,老是抛异常,而MySQLdb.Error的异常有很简单,
e.args[0]=0, e.args[1]=‘’ 。哪位高手帮忙看看怎么搞定?谢谢- count=cur.execute("select source_file, source_path, incident_id from sp_quarantine_info where id = %s", id)
复制代码 全部内容如下- try:
- cur=mysql_conn.cursor()
- count=cur.execute("select source_file, source_path, incident_id from sp_quarantine_info where id = %s", id)
- print "count = %s" % count
- result=cur.fetchone()
- srcfile, srcpath, iid = result
- mysql_conn.commit()
- cur.close()
- mysql_conn.close()
- except MySQLdb.Error,e:
- print "Mysql Error %d: %s" % (e.args[0], e.args[1])
- logging.error("Mysql Error %d: %s" % (e.args[0], e.args[1]))
复制代码 |
|