python操作sqlite3数据库基础用法

import sqlite3
from itertools import chain

conn = sqlite3.connect('rongyi-db')  # 打开或创建一个新的sqlite3轻量级数据库
cur = conn.cursor()  # 游标对象，用于执行sql语句
# sql = "select CONTACT FROM SHOP where recordId= '%s'" % shop_id  # 查询电话
sql = "select recordId FROM SHOP"  # 查询电话
cur.execute(sql)

results = cur.fetchall()  # 一条一条执行
results = list(chain.from_iterable(results))  # 元祖转换成list
# results = str(results).replace("[", "").replace("]", "")  # 格式转换
print(results)
conn.commit()
cur.close()
conn.close()