AiDOPWarehouse/ai-dop-platform/docs/db/_show_cols.py

import pymysql
conn=pymysql.connect(host='106.14.73.46',port=3306,user='aidopremote',password='AidOp#Remote2026$Secure',database='aidopcore',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()