Question

query = "SELECT * FROM mytable WHERE time=%s", (mytime)

目前,我“这样做,但我想将其分成两处(我可以单独这样做)。

cursor.execute("SELECT * FROM mytable WHERE time=%s",(mytime))

然后,我想给它增加一个百分比。在我时代,我怎么能不夸大百分比?

Edit:我想混淆2号,它有“LIMIT %, %”

Answer 1

作为对卡片注入的警告,你可以动态地堆肥你的询问。 Ignacio 建议。

>>> qry =  SELECT t.mycol FROM mytable t WHERE t.mycol = %%s %s  %  LIMIT %s,%s

请:

How can I do that without messing up the %s in mytime?

Notice that you escape the first %s with an additional %.
That gives you this string (which of course looks lovely as far as the DB-API is concerned):

>>> qry
 SELECT * FROM mytable t WHERE t.mycol = %s LIMIT %s,%s

然后将这一条形和参数通过<代码>execute()方法:

curs.execute(qry, (mytime,1,2,))

HTH

Answer 2

cxn.execute("SELECT * FROM mytable WHERE time=%%s LIMIT %d" % (mylimit,), mytime)

或:

cxn.execute("SELECT * FROM mytable WHERE time=%s" + (" LIMIT %d" % (mylimit,)), mytime)

友情链接