Python 数据库之更新数据

执行 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)) 

输出：

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 ]