[Python] Problemi in scrittura DB con executemany()

[Francesco Martino]

Chiedo scusa ma ho riportato il codice in modo errato.
Di seguito si trova quello corretto:


****************************************************************************************************************
import MySQLdb

db = MySQLdb.connect(host = 'localhost', db = 'nome_db', user = 'user', 
passwd = 'password')
cur = db.cursor()

def createTable(curs):
    curs.execute('SELECT tab1.valA, tab1.valB, tab2.valC, tab2.valD\
    FROM tab1 JOIN tab2 \
    ON tab1.valE = tab2.valE\
    WHERE tab1.valA>0')
    for data in cur.fetchall():
        dataList.append(data)  
    curs.execute('CREATE TABLE tab3 (\
      valA char(50),\
      valB char(50),\
      valC char(50),\
      valD char(50))')
    print 'tabella costruita...'
    curs.executemany("INSERT INTO tab3 (valA, valB, valC, valD) \
      VALUES (%s,%s,%s,%s)", dataList)
    print 'valori inseriti'

if __name__= '__main__':
    createTable(cur)
****************************************************************************************************************

Francesco