import sqlite3
con = sqlite3.connect(':memory:')

import sqlite3
con = sqlite3.connect('./test.db')

cur = con.cursor()
cur.execute("CREATE TABLE PhoneBook(Name text, PhoneNum text);")

cur = con.cursor()
cur.execute("INSERT INTO PhoneBook Values('Derick', '010-1234-5678');")

name = 'SangJung'
phoneNumber = '010-5670-2343'
cur = con.cursor()
cur.execute('INSERT INTO PhoneBook VALUES(?, ?);', (name, phoneNumber))

name = 'SangJung'
phoneNumber = '010-5670-2343'
cur = con.cursor()
cur.execute('INSERT INTO PhoneBook VALUES(:name, :phoneNumber);', {"name":name, "phoneNumber":phoneNumber})

dataList = (('Tom', '010-543-5432'), ('DSP', '010-123-1234'))
cur = con.cursor()
cur.executemany("INSERT INTO PhoneBook VALUES(?, ?);", dataList)

cur.execute('SELECT * FROM PhoneBook')
for row in cur:
    print(row)

('Derick', '010-1234-5678')
('SangJung', '010-5670-2343')
('Tom', '010-543-5432')
('DSP', '010-123-1234')

cur.execute('SELECT * FROM PhoneBook')
cur.fetchone()

('Derick', '010-1234-5678')

cur.fetchmany(2)

[('SangJung', '010-5670-2343'), ('SangJung', '010-5670-2343')]

cur.fetchall()

[('Tom', '010-543-5432'), ('DSP', '010-123-1234')]

[출처] https://www.daleseo.com/python-sqlite3/