我的代码:import pymysql
db = pymysql.Connect(
host='127.0.0.1',
port=3306,
user='root',
passwd='111111',
db='student',
charset='utf8'
)
cursor=db.cursor()
sql = "INSERT INTO student(Sno,Sname,Ssex,Sdept,Sage) VALUES(%s,%s,%s,%s,%s) "
cursor.execute(sql,("2008005","李刚","男","IS",20))
db.commit()
print('成功插入', cursor.rowcount, '条数据')
cursor.close()
connect.close()
结果:
Unknown column 'Sno' in 'field list
🙏🙏🙏求解答
数据库没有Sno这个字段