mysql_fetch_array or mysql_fetch_object for python? [closed]

Question

I'm using MySQLdb in python to connect to a mysql database (duh) and am really missing the functionality that's built into PHP, namely:

mysql_fetch_array and mysql_fetch_object

What is the equivalent in Python so that I can start getting my scripts ported?

First result of googling (is this officially a verb now!?) "python mysql" - mysql-python.sourceforge.net - is a DBAPI 2.0 compliant interface, so .fetch() and .fetchall() on cursor objects... — Jon Clements
– Jon Clements, Commented Jul 24, 2012 at 9:37
I ask this because perhaps there's a "specific way" that everyone's doing it and that's why I'm the only one pulling out hair? — AO_
– AO_, Commented Jul 24, 2012 at 9:40
As always: mysql_*() is outdated and should be used anymore. Use MySQLi or PDO_MySQL instead. — KingCrunch
– KingCrunch, Commented Jul 24, 2012 at 9:48
Not really - Create a connection object, create a cursor, execute a query on the cursor, then iterate over the cursor object and you get the equiv of mysql_fetch_array — Jon Clements
– Jon Clements, Commented Jul 24, 2012 at 9:48
So using PDO would probably be that "preferred method" or once not quite? — AO_
– AO_, Commented Jul 24, 2012 at 10:06

AO_ · Accepted Answer · 2012-07-24 10:34:28Z

0

What I was looking for was the DictCursor:

cur = con.cursor(MySQLdb.cursors.DictCursor)

answered Jul 24, 2012 at 10:34

AO_

2,9043 gold badges32 silver badges33 bronze badges

1 Answer 1