Breaking News: Grepper is joining You.com. Read the official announcement!

python sqlite insert many

Jerome Scott answered on August 13, 2022 Popularity 9/10 Helpfulness 5/10

answer python sqlite insert many

python sqlite insert many

Comment

import sqlite3

conn = sqlite3.connect('mysqlite.db')
c = conn.cursor()

#records or rows in a list
records = [(1, 'Glen', 8),
			(2, 'Elliot', 9),
			(3, 'Bob', 7)]

#insert multiple records in a single query
c.executemany('INSERT INTO students VALUES(?,?,?);',records);

print('We have inserted', c.rowcount, 'records to the table.')

#commit the changes to db			
conn.commit()
#close the connection
conn.close()

Popularity 9/10 Helpfulness 5/10 Language python

Source: pythonexamples.org

Tags: insert python sqlite

Link to this answer
Share Copy Link