យើងអាច update ទិន្នន័យផ្សេងៗ នៅក្នុងតារាងទិន្នន័យ ដោយធ្វើដូចខាងក្រោមនេះ៖
import sqlite3
conn = sqlite3.connect('mydb.db')
cursor = conn.cursor()
sql = '''UPDATE EMPLOYEE SET AGE=AGE+1 WHERE SEX = 'M' '''
cursor.execute(sql)
print("Table updated...... ")
cursor.execute('''SELECT * from EMPLOYEE''')
result = cursor.fetchall()
for x in result:
print(x)
conn.commit()
conn.close()