executemany inserts a list of Kenya rows in one call. Always commit on a file database.

Goal

Insert three cities and print them.

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE cities (name TEXT)")
con.execute("INSERT INTO cities VALUES ('Nairobi')")
print(con.execute("SELECT * FROM cities").fetchall())
con.close()

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE cities (name TEXT)")
con.executemany("INSERT INTO cities VALUES (?)", [("Nairobi",), ("Mombasa",), ("Kisumu",)])
print(con.execute("SELECT name FROM cities").fetchall())
con.close()

import sqlite3
con = sqlite3.connect("kiosk.db")
con.execute("CREATE TABLE IF NOT EXISTS cities (name TEXT UNIQUE)")
con.execute("INSERT OR IGNORE INTO cities VALUES ('Nakuru')")
con.commit()
print(con.execute("SELECT * FROM cities").fetchall())
con.close()

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE sales (city TEXT, units INTEGER)")
con.executemany("INSERT INTO sales VALUES (?, ?)", [("Nairobi", 12), ("Nairobi", 7)])
print(con.execute("SELECT COUNT(*) FROM sales").fetchone())
con.close()