from sqlite3 import *
from prettytable import printTable

with connect("schule.db") as con:
    cursor = con.cursor()
    sql = """UPDATE person SET wohnort = 'Zollikofen'
             WHERE familienname = 'Meier' and vorname = 'Nina'"""
    cursor.execute(sql)
    cursor.execute("SELECT familienname, vorname, wohnort FROM person")
    printTable(cursor)
