import sqlite3 conn = sqlite3.connect('testDB.db') cursor = conn.cursor() # cursor.execute('''CREATE TABLE test5 # (ID INT PRIMARY KEY NOT NULL, # NAME TEXT NOT NULL);''') with open('1mb.img') as f: readFile = f.read() i = 11 while i < 1000: cursor.execute('''INSERT INTO test5 VALUES (?, ?)''',(i, readFile)) conn.commit() i = i + 1 print(conn.total_changes)