用pymysql来获取数据

# -*-coding:utf-8-*-
import pymysql
import pandas as pd
import time

def execude_sql(sql):
    # 创建连接
    try:
        db = pymysql.connect(
            host='10.100.155.19',
            port=3308,
            name='usm',
            passwd='passwd',
            db='usmdb',
            charset='utf8')
    except:
        print('数据库连接失败，10s后重试')
        time.sleep(10)
    # 创建游标
    cursor = db.cursor()
    cursor.execute(sql)
    col = cursor.description
    result = cursor.fetchall()
    # 将结果转化为DateFrame
    df = pd.DataFrame(list(result))
    # 关闭游标
    db.close()
    # 返回dateframe
    return result, col

sql = """SELECT * FROM cmdb_hostinformation WHERE prov_id = 100;"""

resu,co = execude_sql(sql)
for (test,) in resu:
    result,col = execude_sql(test)


list = []
for i in range(len(col)):
    list.append(col[i][0])
print(list)  # 获取字段
print(result) # 获取内容
print(col[1][0]) # 这是字段
print(col)