level 1
1031020391
楼主
想把字典里的东西存入数据库里 可是在插入的时候发生了错误
插入语句
def insert(conn,data):
cursor=conn.cursor()
for i in data:
sql="INSERT INTO tushuxinxi VALUES ('i['name']','i['introduction']','i['price']','i['autor']')".encode('gb18030')
cursor.execute(sql)
conn.commit()
错误语句
Traceback (most recent call last):
File "E:/python 代码/tushuguan/chuli.py", line 120, in <module>
shujuku.insert(shujuku.createconnection(),book_dict)
File "E:\python 代码\tushuguan\shujuku.py", line 29, in insert
cursor.execute(sql)
File "pymssql.pyx", line 464, in pymssql.Cursor.execute (pymssql.c:7491)
pymssql.ProgrammingError: (102, b"Incorrect syntax near 'name'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")
2018年07月10日 09点07分
1
插入语句
def insert(conn,data):
cursor=conn.cursor()
for i in data:
sql="INSERT INTO tushuxinxi VALUES ('i['name']','i['introduction']','i['price']','i['autor']')".encode('gb18030')
cursor.execute(sql)
conn.commit()
错误语句
Traceback (most recent call last):
File "E:/python 代码/tushuguan/chuli.py", line 120, in <module>
shujuku.insert(shujuku.createconnection(),book_dict)
File "E:\python 代码\tushuguan\shujuku.py", line 29, in insert
cursor.execute(sql)
File "pymssql.pyx", line 464, in pymssql.Cursor.execute (pymssql.c:7491)
pymssql.ProgrammingError: (102, b"Incorrect syntax near 'name'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")