擅长:python、mysql、java
<p><code>"%% %s"%("Hello",)</code>两个%符号在应用%s后应该变成一个。。。在</p>
<p>但实际上你应该使用内置的查询工具</p>
<pre><code>QryString = """
select count(distinct user_id)
from dbo.tbl_case_details
where request like '%r_%'
and project_id in
(
select distinct project_id
from dbo.tbl_projects
where matter_number = '%s'
);
"""
cursor.execute(QryString,matter)
</code></pre>
<p>尽管您可能仍然需要对文本<code>%</code>执行<code>%%</code></p>