如何在Python中关闭多行变量/注释？

Question

我收到这个错误：

  File "/DateDbLoop.py", line 33  
    d.Id""" % (str(day), str(2840))"  
    ^  
SyntaxError: EOL while scanning single-quoted string  

这是剧本。有4个双引号打开这个，但我不确定如何正确结束这个？在

后续问题：

这个%（str（day），str（2840））是否需要同时在sql变量和操作系统（）打电话？在

^{pr2}$

Answer 1

你用三重引号。在

s = """
Python is awesome.
Python is cool.
I use Python.
And so should you.
"""

print s

Python is awesome.
Python is cool.
I use Python.
And so should you.

Answer 2

用三个引号打开和结束字符串

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))

也可以在字符串中间用\字符换行。在

^{pr2}$

Answer 3

sql=行有4个双引号，改为3个。同时删除%-替换值后的单引号。在

#!/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

在Python中，多行字符串值是用双引号的成对三元组完成的，而不是嵌套在常规的双引号中。在