batchnumbers = [1,2,3,4,5,6,7,8,9,10]
def update_batchnum():
try:
for num in range(len(batchnumbers)):
query = ("INSERT INTO tensilesummary(batchnumber) VALUES ('%s');")
cursor.execute(query,batchnumbers[num])
mariadb_connection.commit()
print("Batchnumber successfullt inserted into tensilesummary table")
except mysql.connector.Error as error:
print("Failed using updatebatchnum to insert into tensilesummary table:{}".format(error))
update_batchnum()
返回错误:使用updatebatchnum插入tensilesummary表失败:1366(22007):第1行的列materialdatabase
.tensilesummary
.batchnumber
的整数值不正确:'%s'
我试图更改my.ini中的sql_mode=“”,但无效
query = "INSERT INTO tensilesummary (batchnumber) VALUES (%s)"
(batchnumbers[num],)
相关问题 更多 >
编程相关推荐