擅长:python、mysql、java
<p>只是为了完整。我发现pypika库非常方便(如果允许的话):</p>
<p><a href="https://pypika.readthedocs.io/en/latest/index.html" rel="nofollow noreferrer">https://pypika.readthedocs.io/en/latest/index.html</a></p>
<p>它允许构造如下sql查询:</p>
<pre><code>from pypika import Query
q = Query._from('daily').select('*')
if host:
q = q.where('host' == host)
if day:
q = q.where('day' == day)
sql = str(q)
</code></pre>