mysql复制栏位名称_pymysql 单独获取表的栏位名称

有时需要获取表的栏位+数值，请参考

https://www.cnblogs.com/xibuhaohao/p/9996571.html

有时只需要栏位名称，那么可以使用

col=self.cursor.description

脚本如下：

[dba@wanliu-jx-db-218 monitor]$ cat mysql_ccpay.py

#coding=utf-8

import sys

import pymysql

import os

#from prometheus_client import Gauge,start_http_server

import time

#v_host=os.popen('echo $HOSTNAME')

#hostname=v_host.read()

#hstname="".join(hostname)

#print(hostname.strip())

class MySQL_Status_Output:

def __init__(self,host,port,user,password):

try:

self.db = pymysql.connect(host=host,port=port,user=user,password=password)

self.cursor = self.db.cursor()

except Exception as e:

print('Wrong')

print(e)

def mysql_select_sql(self,sql):

try:

self.cursor.execute(sql)

col=self.cursor.description

v_result=self.cursor.fetchall()

return v_result,col

except Exception as e:

print(e)

def close(self):

self.db.close()

if __name__ == "__main__":

#start_http_server(9500)

#ccpayGauge = Gauge('ccpayGauge','Description of gauge', ['mylabelname'])

while True:

time.sleep(10)

try:

pro_db = MySQL_Status_Output('127.0.0.1',3306,'dbadmin','dbadmin')

ccpay_machine_enable,col_name = pro_db.mysql_select_sql(" select id '序号',name '姓名',age '年龄' from test.test ")

pro_db.close()

col_name_list=[]

ccpay_machine_enable_name=[]

for i in range(len(col_name)):

col_name_list.append(col_name[i][0])

print(tuple(col_name_list))

col_name_tuple=tuple(col_name_list)

for j in range(len(ccpay_machine_enable)):

ccpay_machine_enable_name=ccpay_machine_enable[j]

print(ccpay_machine_enable_name)

me = dict(zip(col_name_tuple,ccpay_machine_enable_name))

print(me)

except Exception as e:

print('Is Wrong')

print(e)

输出结果如下：