យើងអាច 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()
('Vinay', 'KUNG', 22, 'M', 6000.0)
('Sarika', 'VONG', 27, 'M', 8300.0)
('Thirit', 'KANN', 24, 'F', 6000.0)
