from connect_db import DB val = [{"id": 1, "xh": 1001, "name": "a"}, {"id": 2, "xh": 2002, "name": "b"}, {"id": 3, "xh": 3003, "name": "c"}] with DB(db="test") as db: db.execute("DROP TABLE IF EXISTS test1") db.execute("CREATE TABLE test1 (id INT AUTO_INCREMENT PRIMARY KEY,xh INT, name VARCHAR(20))") try: for i in range(99999999999999): sql = "insert into test1 values(%s, %s, %s)" insert_val = [int(val[i]["id"]), int(val[i]["xh"]), val[i]["name"]] db.execute(sql, insert_val) except IndexError: print("导入结束,共有%d条数据" % i)