Adding a row to SQLite.jl database

Specific Domains Data
2 
using DBInterface, SQLite

stmt = DBInterface.prepare(db, "INSERT INTO Primes (index, prime) VALUES (?, ?)")
row = (index=1, prime=2)
DBInterface.execute(stmt, (row.index, row.prime))

FYI, there are lots of great tutorials on the web for working w/ sqlite, like this one: SQLite Insert Into - Inserting New Rows Into a Table.

3 Likes