sqlite3有问题，语法错误？

Question

使用sqlite3的数据库时，会出现如下错误：

    File '..\database.py', line 131, in load_player_abilities
      (player.id, ability.id)):

sqlite3.OperationalError: near '=': syntax error

我得到的错误来自以下代码：

for ability in player.abilities:
    for level in cursor.execute(
            "SELECT level FROM abilities"
            "WHERE player_id=? AND ability_id=?",
            (player.id, ability.id)):
        ability.level = level

Answer 1

似乎在abilities和WHERE之间缺少一个空格

for ability in player.abilities:
    for level in cursor.execute(
        "SELECT level FROM abilities "
        "WHERE player_id=? AND ability_id=?",
        (player.id, ability.id)):
        ability.level = level