你能帮我找出我做错了什么吗? 我试图将一个新的玩家插入到“players”表中。 这是Python代码:
def registerPlayer(name):
code for connecting to db and cursor
c.execute("INSERT INTO players(player_name) VALUES({name});".format(name=name))
code for committing to db and closing the connection
这是我的表结构:
CREATE TABLE players(
player_id serial PRIMARY KEY,
player_name varchar(50) NOT NULL
);
以下是错误信息:
psycopg2.ProgrammingError: syntax error at or near "Nalaar" LINE 1:
向 players 表中插入玩家名为 Chandra Nalaar 的记录。