SyntaxError: invalid syntax in mysqlDb python

Question

I am trying to test the following with python but I get the invalid syntax error:

db = None

try:

db = mdb.connect("localhost","user","pass","dbName") 

with db:

    cur = db.cursor()                   
    cur.execute("SELECT * from product")

    rows = cur.fetchall()
    for row in rows:
        print row

except mdb.Error, e:

print "Error %d: %s" % (e.args[0],e.args[1])
sys.exit(1)

The error is the following:

  File "script.py", line 11
with db:
      ^
SyntaxError: invalid syntax

How do I fix this?

Can you please include the SyntaxError and format the first couple of lines of your code exactly as you have them in your script? — johnsyweb
– johnsyweb, Commented Feb 24, 2013 at 3:04
Except for the indentation everthing seems to be ok. Are you sure that you are using python 2.7? — razpeitia
– razpeitia, Commented Feb 24, 2013 at 3:34
Well the with statement is available from python 2.5+. That's pretty much why it will never work. python.org/dev/peps/pep-0343 — razpeitia
– razpeitia, Commented Feb 24, 2013 at 3:58

Patratacus · Accepted Answer · 2013-02-24 04:02:42Z

2

I'd be nice to see all your imports declarations too to see what could be missing from your code. I assume that you at least have the import MySQLdb somewhere. I made a dummy database with a couple of data rows to test this out. Not sure how python let you get away with the indentation blocks being all messed up, but maybe it's just your code indentation posting error on here.

This is the code I tried and seemed to have no issues:

import MySQLdb as mdb

db = None

try:

    db = mdb.connect("localhost","user", "password", "test_data")

    ## with db:  ## try taking this out for Python 2.4
    cur = db.cursor()
    cur.execute("SELECT * FROM PRODUCT")
    rows = cur.fetchall()
    for row in rows:
        print row

except mdb.Error, e:

    print "Error %d: %s" % (e.args[0],e.args[1])
    sys.exit(1)

edited Feb 24, 2013 at 4:02

answered Feb 24, 2013 at 3:51

Patratacus

1,8412 gold badges18 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Patratacus Over a year ago

Just saw your last comment. If you are using Python 2.4, try taking out the "with db:" line.

Collectives™ on Stack Overflow

SyntaxError: invalid syntax in mysqlDb python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related