fin = open("dati.csv","r")
L = fin.readlines()
L = L[1:]
L2 =[]

for i in L:
    L2.append(i.split(','))

import MySQLdb

db = MySQLdb.connect("localhost","user","passw","DB" )
cursor = db.cursor()
#cursor.execute('create database if not exists NOME') # non e' richiesto
#cursor.execute('use NOME') #non e' richiesto

tab = "CREATE TABLE Persone (eta int, Nome char(50), Residenza varchar(50), stipendio int, PrimaryKey (Nome), ForeignKey(Residenza) REFERENCES citta(id) ) "
cursor.execute(tab)
insert_stmt = ("INSERT INTO Persone (eta, Nome, Residenza, stipendio) " "VALUES (%s,%s,%s,%s)")

for i in L2:
    data = (i[0], i[1], i[2],i[3]) # data = (i)?
    cursor.execute(insert_stmt, data)
    db.commit()

db.close()