37,720
社区成员
发帖
与我相关
我的任务
分享请教cursor.execute传两个相同参数如何解决
a = '2019-04-09'
sql = """
select *
from
table
where substr(created_at,1,10) = %s
and substr(updated_at,1,10) = %s
"""
cursor.execute(sql,a)
报错Unsupported param format: 2019-04-09
请问怎么改呢
...全文
请发表友善的回复…
发表回复
陈年椰子 2019-04-11
- 打赏
- 举报
a = '2019-04-09'
sql = """
select *
from
table
where substr(created_at,1,10) = '%s'
and substr(updated_at,1,10) = '%s'
"""
cursor.execute(sql,a)
a = '2019-04-09'
sql = """
select *
from
table
where substr(created_at,1,10) = '%s'
and substr(updated_at,1,10) = '%s'
"""
cursor.execute(sql,(a,a,))
