ylrz_saas_his_scrm/scripts/check_dict.py

import pymysql
conn = pymysql.connect(host='cq-cdb-8fjmemkb.sql.tencentcdb.com', port=27220, user='root', password='Ylrz_1q2w3e4r5t6y', database='ylrz_saas')
cur = conn.cursor()

cur.execute("SELECT * FROM sys_dict_data WHERE dict_type LIKE '%job%' LIMIT 1")
cols = [d[0] for d in cur.description]
print('Columns:', cols)
for r in cur.fetchall():
    for i, c in enumerate(cols):
        print('  %s = %s' % (c, r[i]))
cur.close()
conn.close()