执行 SQL 的更新(update)子句可以修改表的记录。例如：

import sqlite3 
db_filename = 'company.db' 
with sqlite3.connect(db_filename) as conn: 
    cursor = conn.cursor()
    #更新 name= 'Wang wei'记录
    cursor.execute(""" 
        update Employee set date='2016-01-02' 
        where name = 'Wang wei' 
        """) 
 
    conn.commit() #提交修改到数据库中 
 
    cursor.execute(""" 
        select id, name, date, salary from Employee 
        order by date 
        """)
    print('\nNext 5 employees:')
    for row in cursor.fetchmany(5): 
        Employee_id, name, date, salary = row 
        print('{:2d} {:<25} ({}) [{:<8}]'.format(Employee_id, name, date, salary)) 

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20

输出：

Next 5 employees: 
 2 Zhang ping (2008-01-05) [7000.5 ] 
 1 Wang wei (2016-01-02) [8000.5 ] 
 3 Zhao qiang (2018-11-05) [6000.5 ]

• 1
• 2
• 3
• 4