Question

python连接数据库后进行操作时出现错误

sql = "insert into wenzhang(title,conten) values(title,content)";

cursor.execute(sql)

psycopg2.errors.UndefinedColumn: column "title" does not exist
LINE 1: insert into wenzhang(title,conten) values(title,content)
^
HINT: There is a column named "title" in table "wenzhang", but it cannot be referenced from this part of the query.

请问应当如何处理

Answer 1

conn = pymssql.connect(host=r"localhost",user=r"sa",password=r"pwd",database=r"production")

stack overflow 上有个类似的问题 有个答案是这样的 你试试 没用过mssql

追问

不是连接出错 是在往表里插入数据的时候报错