<filename>classWork/lec4.py<gh_stars>0
import sqlite3

# where you want to save the database
# database location
database_name = '/home/akash/git_workspace/code_for_Kids/classWork/my_database.db'
# name = 'customer.db'    # .db is the extention of database

c = sqlite3.connect(database_name)

cur = c.cursor()    # similar to pygame, it has many buit in methods/functions

# update the value of database

cur.execute(" UPDATE customers SET last_name='Billy' where email='<EMAIL>' ")

c.commit()

cur.execute("SELECT * FROM customers")

print(cur.fetchall())

# saving the database
c.commit()

# closing the database
c.close()
<filename>classWork/lec4.py<gh_stars>0
import sqlite3

# where you want to save the database
# database location
database_name = '/home/akash/git_workspace/code_for_Kids/classWork/my_database.db'
# name = 'customer.db'    # .db is the extention of database

c = sqlite3.connect(database_name)

cur = c.cursor()    # similar to pygame, it has many buit in methods/functions

# update the value of database

cur.execute(" UPDATE customers SET last_name='Billy' where email='<EMAIL>' ")

c.commit()

cur.execute("SELECT * FROM customers")

print(cur.fetchall())

# saving the database
c.commit()

# closing the database
c.close()
# where you want to save the database # database location # name = 'customer.db'    # .db is the extention of database # similar to pygame, it has many buit in methods/functions # update the value of database # saving the database # closing the database