系统:Windows 7
语言版本:Anaconda3-4.3.0.1-Windows-x86_64
编辑器:pycharm-community-2016.3.2
修改前
import sqlite3
import oscurrent_address = os.path.abspath('.')
db_address = os.path.join(current_address, "测试.db")conn = sqlite3.connect(db_address)
cur = conn.cursor()table_name = "gradeTable"
fields_name = "name, course, grade"
sql = "Update {0} Set grade='{1}' Where name='张三'".format(table_name, 95)cur.execute(sql)
conn.commit()
conn.close()
代码截图
1. 数据库操作一般套路
2. 修改记录:Update 表名 Set 字段=新值 Where 条件
3. 其实与上一节示例的核心区别,就在于sql语句