Querying MariaDB from python

Tony van der Hoff lists at vanderhoff.org
Tue Oct 2 12:07:38 EDT 2018


On 02/10/18 16:47, Ervin Hegedüs wrote:
> hi,
> 
> now rows will looks like this:
> ({'id':...,...},{'id':...,}...)

Thanks Ervin, but:

   cursor = cnx.cursor(pymysql.cursors.DictCursor)
NameError: name 'pymysql' is not defined

I have been using the mysql.connector module, which seems to be the
"official" python interface. I hadn't spotted the pymysql module. Is the
consensus here that pymysql is the preferred connector?

Cheers,

-- 
Tony van der Hoff        | mailto:tony at vanderhoff.org
Buckinghamshire, England |



More information about the Python-list mailing list