How to use for loops to do multiple SQL statements in python

Question

I have SQl statement List, when running the a single statement it work running the loop it gives:

pyodbc.ProgrammingError: ('42000', "[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Sql_2' at line 1 (1064) (SQLExecDirectW)")

SQl = """Select something"""
    SQl_2 = """Select something"""
    SQl_3 = """Select something"""


Sqls= ('Sql','Sql_2','Sql_3')

for x in Sqls:
    print x
    use = Sql_2  
    # use = x
    cxn = pyodbc.connect('DSN=MySQL;PWD=xxx') 
    csr = cxn.cursor()
    csr.execute(use)
    fetch = csr.fetchall()

Sven Marnach · Accepted Answer · 2011-02-10 16:49:19Z

6

Your tuple should be

Sqls = (Sql,Sql_2,Sql_3)

instead of

Sqls = ('Sql','Sql_2','Sql_3')

answered Feb 10, 2011 at 16:49

Sven Marnach

608k123 gold badges968 silver badges865 bronze badges

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

1 Comment

nesv Over a year ago

This could be made even simpler by creating the tuple in the for loop: for x in (Sql, Sql_2, Sql_3): ....

Michal Chruszcz · Accepted Answer · 2011-02-10 17:02:23Z

3

You should additionally move connecting to the database as well as creating a cursor out of the for-loop, since it's unneeded overhead.

SQl = """Select something"""
SQl_2 = """Select something"""
SQl_3 = """Select something"""

Sqls = (Sql, Sql_2, Sql_3)
cxn = pyodbc.connect('DSN=MySQL;PWD=xxx') 
csr = cxn.cursor()

for x in Sqls:
    print x
    use = Sql_2  
    # use = x    
    csr.execute(use)
    fetch = csr.fetchall()

answered Feb 10, 2011 at 17:02

Michal Chruszcz

2,50016 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to use for loops to do multiple SQL statements in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related