[python] mysql db 연결 row 컬럼명으로

파이썬으로 select 할경우 row[0] 말고 row['컬럼명'] 으로 가져오기

 

result = [dict((mycursor.description[i][0], value) for i, value in enumerate(row)) for row in mycursor.fetchall()]

 

예제

# requirements
# pip3 install mysql-connector-python

import sys
import mysql.connector

# =====================
def main(argv):

  mydb = mysql.connector.connect(
    host="localhost",
    port=3306,
    user="root",
    password="root",
    database="데이터베이스명"
  )

  mycursor = mydb.cursor()

  sql = """
    SELECT DISTINCT cate_1 FROM category
  """
  mycursor.execute(sql)

  result = [dict((mycursor.description[i][0], value) for i, value in enumerate(row)) for row in mycursor.fetchall()]

  for row in result:
    print(row['cate_1'])

if __name__ == '__main__':
  main(sys.argv)