python SQLite

#创建
​CREATE TABLE Ages ( 
  name VARCHAR(128), 
  age INTEGER
)

#增加
INSERT INTO Users(name,email) VALUES('Bill','380451035@qq.com')

#删除
DELETE FROM Users WHERE email='380451035@qq.com'

#改
UPDATE Users set name='Bill' WHERE email='380451035@qq.com'

#查
SELECT * FROM Users 
SELECT * FROM Users WHERE email='380451035@qq.com'
SELECT * FROM Users ORDER BY email

​

用python操作：

import sqlite3
#数据库文件
db_file='XXX.db'   
#建立与数据库连接
conn=sqlite3.connect(db_file)
#编写sql语句
sql='select * from scores'
#执行sql语句
cur=conn.cursor() #设定打开光标
cur.execute(sql)
#打印结果
print(cur.fetchall())
#关闭连接
conn.close()

添加：

import sqlite3
db_file='scores.db'
#插入数据
def insert_score_data():
    #获取连接
    conn=sqlite3.connect(db_file)
    #