文件列表：
mytest.db
id timestamp 1 2022-6-17 17:59 2 2022-6-17 17:59 3 2022-6-17 17:59 4 2022-6-17 17:59 5 2022-6-17 17:59 6 2022-6-19 17:38 7 2022-6-19 17:38 8 2022-6-19 17:38 9 2022-6-19 17:38
SQLite3Test.py
# coding:utf-8
# @Time:2022-06-20 12:28
# @Author:Kevin
# @Software:PyCharm
import sqlite3 as sl
# 获取列名/字段名
db = sl.connect('mytest.db')
cur = db.cursor()
cur.execute("select * from table_data")
col_name_list = [tuple[0] for tuple in cur.description]
print(col_name_list)
# cur.execute("PRAGMA table_info(table_data)")
# print(cur.fetchall())
