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