擅长:python、mysql、java
<p>查询参数应传递到<code>execute()</code>:</p>
<pre><code>query = """
select
ifname, usname, mtdesc, lobuilding
from
interface
left join
machine
on
ifmcid=mcid
left join
machine_type
on
mcmtid=mtid
left join
user
on
mcusid=usid
left join
location
on
mcloid=loid
WHERE
mccurrentosid = 32 AND
ifname = %s
"""
cur.execute(query, (args.machine,) )
</code></pre>