Python-sqlite3-02-创建数据库及工作表

import sqlite3
import oscurrent_address = os.path.abspath('.')
db_address = os.path.join(current_address, "测试.db")
tbl_name = "学生成绩"

if os.path.exists(db_address):
   os.remove(db_address)conn = sqlite3.connect(db_address)
cur = conn.cursor()
sql = "CREATE TABLE {0} (name CHAR(25) PRIMARY KEY, course CHAR(25), grade CHAR(25))".format(tbl_name)cur.execute(sql)
conn.commit()
conn.close()