将变量（表名，数据）传递给python mysqld查询

I am trying to pass the name of the table and information to be inserted into the table as parameters. The query I have come up with is below:

我试图将表的名称和信息作为参数传递到表中。我提出的查询如下:

sql = """INSERT INTO `%s` (title,link,description) VALUES(%%s,%%s,%%s)""" % (feed,title_xml,link_xml,description_xml)
cursor.execute(sql)

However, I am getting the following error:

但是,我收到以下错误:

Traceback (most recent call last):
  File "slicer_1.py", line 41, in <module>
    sql = """INSERT INTO `%s` (title,link,description) VALUES(%%s,%%s,%%s)""" %(feed,title_xml,link_xml,description_xml)
TypeError: not all arguments converted during string formatting

What could be wrong here?

这可能有什么问题?

1 个解决方案

#1

You have double %% on the last three %s. This means that only the first %s will be substituted in the string substitution, which means you can only pass one value to be substituted. Perhaps you meant to pass the other three to the execute call to be handled by the SQL library's safe substitution? Either that or you need to make all four have just one % so they all get substituted in the first step. (I'm not sure if things like MySQLdb let you parameterize VALUES data.)

你在最后三个%s上有两倍的%%。这意味着只有第一个%s将在字符串替换中被替换,这意味着您只能传递一个要替换的值。也许你打算将其他三个传递给执行调用,由SQL库的安全替换处理?无论是那个还是你需要使所有四个只有一个百分点,所以他们都在第一步中被替换。 (我不确定像MySQLdb这样的东西是否允许你参数化VALUES数据。)

Edit: If you take the second suggestion, you probably want to do it like this:

编辑:如果你采取第二个建议,你可能想这样做:

"""INSERT INTO `%s` (title,link,description) VALUES("%s","%s","%s")""" % (feed,title_xml,link_xml,description_xml)

1 个解决方案

#1

更多相关文章

随机推荐