1
626import MySQL. Connector
db2 = mysql.connector.connect(host="localhost", port="3306", user="root", database="DB9db");
db2cursor=db2.cursor()
#sql="INSERT INTO novatable3 (Nid,Namee,Gender,Age,Qualification,DoB) values (%s, %s, %s, %s, %s, %s)"
#var=("33","summeya","F","17","bsc","2005")
sql="INSERT INTO chktbl (name, salary) values (%s, %s)"
var=[("summeya",33),("summeya",33),("summeya",33),("summeya",33),("summeya",33),("summeya",33),("summeya",33),("summeya",33)]
db2cursor.executemany(sql, var)
#
print(db2cursor.rowcount,"records insertd")
db2cursor.commit()
commit() 不会将任何数据保存到我的 apache MySQL 数据库中。在Python代码中MySQL-connecter
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
在代码中，您已在游标对象上调用了
commit()方法，但您应该在数据库连接对象上调用它。