python-查询数据库中某一张表的列名

import pymysql
# 建立连接
connect_stat = pymysql.Connect(host='localhost', port=3306, user='root', passwd='123456', db='stats', charset='utf8')
cursor = connect_stat.cursor()
# 查询sql
cursor.execute("select mobile_phone, create_time from t_tel_user_stat")
# 查询sql中的列名集
description = cursor.description
# 取出列名集
column_list = [column[0] for column in description]
print('查询结果中的列名:', column_list)
# 查询表中所有列
cursor.execute("SHOW COLUMNS from t_tel_user_stat")
print('查询表中全部列名:', [column[0] for column in cursor.fetchall()])

结果:

查询结果中的列名: ['mobile_phone', 'create_time']
查询表中全部列名: ['mobile_phone', 'tel_count', 'create_time', 'update_time']