語法

tuples = cursor.description

這個唯讀屬性會傳回一個元組列表，描述結果集中的欄位。 列表中的每個元組包含以下值

(column_name,
 type,
 None,
 None,
 None,
 None,
 null_ok,
 column_flags)

以下範例示範如何解讀 description 元組

import mysql.connector
from mysql.connector import FieldType

...

cursor.execute("SELECT emp_no, last_name, hire_date "
               "FROM employees WHERE emp_no = %s", (123,))
for i in range(len(cursor.description)):
  print("Column {}:".format(i+1))
  desc = cursor.description[i]
  print("  column_name = {}".format(desc[0]))
  print("  type = {} ({})".format(desc[1], FieldType.get_info(desc[1])))
  print("  null_ok = {}".format(desc[6]))
  print("  column_flags = {}".format(desc[7]))

輸出看起來像這樣

Column 1:
  column_name = emp_no
  type = 3 (LONG)
  null_ok = 0
  column_flags = 20483
Column 2:
  column_name = last_name
  type = 253 (VAR_STRING)
  null_ok = 0
  column_flags = 4097
Column 3:
  column_name = hire_date
  type = 10 (DATE)
  null_ok = 0
  column_flags = 4225

column_flags 值是 constants.FieldFlag 類別的實例。 若要了解如何解讀它，請執行下列操作

>>> from mysql.connector import FieldFlag
>>> FieldFlag.desc