import pymssql
# 打开数据库连接
db = pymssql.connect(host='root',
user='len',
password='12345',
database='Python_database',
charset='cp936')
# 使用cursor()方法创建一个游标对象cursor
cursor = db.cursor()
try:
# 执行SQL语句
cursor.execute('INSERT INTO books VALUES(2101, "零基础学Py", "Python", 79.82, "2021-10-9")')
# 提交数据
db.commit()
cursor.execute("select * from books")
result = cursor.fetchall()
print(result)
except:
# 发生错误时回滚
print(5)
db.rollback()
# 关闭数据库连接
db.close()
这是表的列名
id int NOT NULL,
name varchar(30) NOT NULL,
category varchar(30) NOT NULL,
price float NOT NULL,
publish_time date NOT NULL,
PRIMARY KEY (id)
数据库连接正确,但数据就是一直插入不进去,求解!