SQLite.py

import sqlite3
conn = sqlite3.connect("test.db")
c = conn.cursor()

def create_table():
    c.execute('CREATE TABLE roll_list(Name VARCHAR, Roll INT, Branch TEXT)')

#create_table()

def enter_data():
    name = input("Enter your name :  ")
    roll = int(input("Enter Roll no. : "))
    branch = input("Enter branch : ")
    c.execute("INSERT INTO roll_list(Name, Roll, Branch) VALUES (?, ?, ?)",(name, roll, branch))
    conn.commit()
enter_data()

def read_data():
    name = input("What name r u looking for? ")
    #roll = input("What roll no. r u looking for? ")

    sql = "SELECT * FROM roll_list WHERE name = ? "
    for row in c.execute(sql,[(name)]):
        print(row)

read_data()

def update():
    sql = "UPDATE roll_list SET Name = ? WHERE Name = 'Mukta'"
    #old = input("Enter name u want to change : ")
    new = input("Enter new name : ")
    c.execute(sql,[(new)])
    conn.commit()
update()