Python SQLite3读取数据库中的文件并获取列名/字段名

文件列表：

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())