python 批量操作数据

import pymysql

connect = pymysql.connect(
    host = "127.0.0.1",
    port = 3306,
    user = "root",
    password = "123456",
    db ="t1",
    charset = "utf8"
)

cursor = connect.cursor()

for a in range(1,100): #制造100个数据
    sql_insert = "insert into tb1 values("+ str(a) + ",'Jack',10000);"
    try:
        cursor.execute(sql_insert)
        connect.commit() #插入数据后，保存
    except Exception as e:
        print(e)
        connect.rollback() #出现异常进行回滚

cursor.close()
connect.close()