擅长:python、mysql、java
<p>sql=行有4个双引号,改为3个。同时删除%-替换值后的单引号。在</p>
<pre><code>#!/usr/bin/python
import datetime
import sys, os, time, string
a = datetime.date(2009, 1, 1)
b = datetime.date(2009, 2, 1)
one_day = datetime.timedelta(1)
day = a
while day <= b:
print "Running query for \"" + str(day) + "\""
sql="""SELECT
d.Date,
SUM(d.Revenue)
FROM Table d
WHERE d.Date = '%s'
AND d.Id = %s
GROUP BY d.Date
""" % (str(day), str(2840))
os.system('mysql -h -sN -u -p -e "%s" > FileName-%s.txt db' % (sql, str(day)))
day += one_day
</code></pre>
<p>在Python中,多行字符串值是用双引号的成对三元组完成的,而不是嵌套在常规的双引号中。在</p>