Python到SQL IN参数的字符串列表 [英] Python list of String to SQL IN parameter

问题描述

我在python中有此查询:

I have this query in python:

ssim_group = [S1200,S1300]

query = '''select WIPMessageCnt from waferdata where recipename in (%s) and equipment = ?
                             and runtype = ? order by  stopts desc limit 1''' % (','.join(ssim_grp))

打印查询

当前结果

从晶圆数据中选择WIPMessageCnt，其中(S1200，S1460)中的配方名称和设备=? 和runtype =?按止损顺序1限制

select WIPMessageCnt from waferdata where recipename in (S1200,S1460) and equipment = ? and runtype = ? order by stopts desc limit 1

预期结果应该是这样

从晶圆数据中选择WIPMessageCnt，其中配方名称('S1200'，'S1460')和设备=? 和runtype =?按止损顺序1限制

select WIPMessageCnt from waferdata where recipename in ('S1200','S1460') and equipment = ? and runtype = ? order by stopts desc limit 1

当我尝试将它们放在SQL的IN参数中时，该列表应在每个元素上具有单个qoutation.我怎样才能做到这一点?

The list should have single qoutation on each element when I try to put them inside the IN parameter on SQL. How can I achieve this?

推荐答案

ssim_group = ['S1200', 'S1300']
query = '''select WIPMessageCnt from waferdata where recipename in ('%s') and equipment = ? and runtype = ? order by  stopts desc limit 1''' % ("','".join(ssim_group))

这篇关于Python到SQL IN参数的字符串列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！