记一次python开发中遇到查询sql条件为in时,写法如下:
sql = "SELECT * FROM tb_attribute WHERE name in ({}) and is_delete = 0".format( ','.join(["'%s'" % item for item in names]))
记一次python开发中遇到查询sql条件为in时,写法如下:
sql = "SELECT * FROM tb_attribute WHERE name in ({}) and is_delete = 0".format( ','.join(["'%s'" % item for item in names]))