MySQL query from Python

Question

MySQL query from Python

Navigation

#1 by (3 votes)

1

I'm looking for a way to make a query to MySQL from Python, for this I'm supporting the documentation official . The problem is that although I can connect and do the query without problems, I am unable to go through the results, look for the data that interests me by the name of the column in the table.

I'm using:

import MySQLdb
db=MySQLdb.connect(host="localhost",user="user",passwd="contra",db="basedatos")

c=db.cursor()
c.execute("SELECT * FROM tabla")
c.fetchall()

for juego in c:
    print(juego[26])
    pass

That is, I want to modify juego[26] by juego['Nombre'] , which would be the name of the column. This more than anything is because the structure of the table can change and force me to modify the code every time this happens. I tried with single quotes, double quotes and parentheses, and it has not served me any.

mysql python

asked by JetLagFox 01.01.2018 в 06:51

source

1 answer

Determine the destination of a generated PDF Incompatibility in the Android gradle

score 3 · Accepted Answer

You must use MySQLdb.cursors.DictCursor :

import MySQLdb
db=MySQLdb.connect(host="localhost",user="user",passwd="contra",db="basedatos")
c = db.cursor(MySQLdb.cursors.DictCursor)
c.execute("SELECT * FROM table")
result_set = c.fetchall()
for row in result_set:
    print(row["Nombre"])