2 - connecting to sqlite3 from IDLE

import sqlite3

db = sqlite3.connect('g:/learn-flask/flask-intro/second.db')
db.execute('''CREATE TABLE scoop(name text, scoop text)''')
db.execute("insert into scoop values('asma', 'nam-nam-nam')")
db.commit()
del db