python - 对于 INSERT，使用带有变量的 LIKE 语句

Question

如何使用 LIKE 正确编写以下 INSERT？

provider = provider
cursor.execute("""INSERT INTO raw_financials (provider, vendor_id) 
                  VALUES (%s, %s)""", 
                 ((SELECT provider FROM main_app_provider 
                   WHERE provider LIKE %s%, %provider), vendor_id)

例如，使用上面的 LIKE 语句，“Apple”将匹配“Apple Inc.”。

Answer 1

使用 INSERT ... SELECT ... FROM variant INSERT 命令:

sql = """
    INSERT INTO raw_financials (provider, vendor_id)
    SELECT provider, %s
    FROM main_app_provider
    WHERE provider LIKE %s
    """ 
args = (vendor_id, '%'+provider+'%')
cursor.execute(sql, args)