I use Mysql Connection in Python script.
How can I get results from table by names?
cursor = conn.cursor()
cursor.execute("SELECT * FROM local")
Now I do this by index:
results = cursor.fetchall()
for row in results:
print row[0] //
Instead that I wanna get fields by names like as: print row["name"]
If you are using mysql-connector, Try this
cursor = conn.cursor(dictionary=True)
cursor.execute("SELECT * FROM myTable")
results = cursor.fetchall()
for row in results:
print( row )
If dictionary is True, the cursor returns rows as dictionaries.
Instead you can use pandas library
import pandas as pd
sql = "SELECT * FROM local"
df = pd.read_sql(sql,conn)
for index,row in df.iterrows():
print(row['name'])
I hope this helps
pandas in Cent OS?
If you are using the MySQLdb for python you can transmit to your cursor instance a DictCursor.
Here is a full example using MySQLdb:
>>> import MySQLdb
>>> db = MySQLdb.connect(host="localhost",user="test",passwd="test",db="test")
>>> cursor = db.cursor(MySQLdb.cursors.DictCursor)
>>> cursor.execute("SELECT * FROM test_user")
2
>>> results = cursor.fetchall()
>>> for result in results:
... print(result["username"])
test1
test2
Hope it's useful.
Also, you can find answers here suitable for your tuple situation. python mysql.connector DictCursor?
import mysql.connector