擅长:python、mysql、java
<p>仅将<code>try...except</code>块包装在导致异常的代码周围,该异常位于<code>for</code>循环中。我不使用<code>MySQLdb</code>,但类似这样的方法应该有效:</p>
<pre><code> try:
insertstr= "INSERT INTO cdr_extended (duration,billsec,amaflags,start,end,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposition,accountcode,uniqueid) VALUES (%s,%s,0,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');" % (duration,billsec,start,end,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposition,accountcode,uniqueid)
cur.execute(insertstr)
con.commit()
except mdb.Error, e:
if e.args[0] == 1062:
print "Dupe key on uniqueid: %s" % (uniqueid)
else:
print "Error %d: %s" % (e.args[0],e.args[1])
sys.exit(1)
</code></pre>