MySQL: AttributeError: cursor

[Albert W. Hopkins]

On Sat, 2012-02-11 at 09:40 -0800, Kevin Murphy wrote:
> Hi All,
> I'm using Python 2.7 and having a problem creating the cursor below.
> Any suggestions would be appreciated!
> 
> import sys
> import _mysql
> 
> print "cursor test"
> 
> db =
> _mysql.connect(host="localhost",user="root",passwd="mypw",db="python-
> test")
> 
> cursor = db.cursor()
> 
> >>>
> cursor test
> 
> Traceback (most recent call last):
> File "C:\Python27\dbconnect.py", line 8, in <module>
> cursor = db.cursor()
> AttributeError: cursor

You are using the low-level C API wrapper (not sure why).  Most people,
I believe, would use the pythonic API:

>>> import MySQLdb
>>> db = MySQLdb.connect(host='localhost', user='root', passwd='mypw',
db='python-test')
>>> cursor = db.cursor()

The low-level API is... well.. for when you want to do low-level stuff.
You probably want the pythonic API.

-a