Python TypeError - MySQL executemany

Question

我正在使用 MySQLdb 模块插入到我的数据库中。我有以下代码

      sqlString = """INSERT INTO PERFORMER (PERFORMER)
                     VALUES (%s)
                     WHERE NOT EXISTS (SELECT * FROM PERFORMER P
                                       WHERE P.PERFORMER = %s)"""
      data = [(c, c) for c in self._performers]
      self._cursor.executemany(sqlString, data)

基本上，我想从 self._performers(这只是一个名称列表)中插入尚未在 PERFORMERS 表中的条目。但是我收到以下 TypeError

TypeError: not all arguments converted during string formatting

完整跟踪

Traceback (most recent call last):
File "tvGuide.py", line 437, in <module>
        processing.UpdatePerformers()
File "tvGuide.py", line 307, in UpdatePerformers
        self._cursor.executemany(sqlString, data)
File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 246, in executemany
        self.errorhandler(self, TypeError, msg)
File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
        raise errorclass, errorvalue TypeError: not all arguments converted during string formatting

self._performers 列表很长，但这里是前几个条目的示例

['Lucy Alexander', 'Martin Roberts', 'Alistair Appleton', 'Zak Bagans', 'Aaron Goodwin', 'Nick Groff', 'John Zaffis', 'Ellen Pompeo', 'Patrick Dempsey',

Answer 1

+1 给 Nacho，TypeError 有点让人误会，在 VALUES 子句中使用 WHERE 是非法的。