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
_______________________________________________
Python mailing list
Python@lists.python.it
http://lists.python.it/mailman/listinfo/python
