import pymysql
conn=pymysql.connect(host='123.60.180.165',port=3306,user='aidopremote',password='1234567890aiDOP#',database='aidopdev',charset='utf8mb4',autocommit=True)
try:
  with conn.cursor() as cur:
    for t in ['ado_s9_kpi_value_l1_day','ado_s8_alert_record','ado_s1_sales_order']:
      cur.execute("SHOW COLUMNS FROM `"+t+"`")
      print("\n"+t)
      for r in cur.fetchall():
        print(r[0],r[1])
finally:
  conn.close()