Difference between revisions of "Insert data into mysql from csv file"

    import MySQLdb, csv, sys
    conn = MySQLdb.connect (host = "localhost",user = "usr", passwd = "pass",db = "databasename")
    c = conn.cursor()
    csv_data=csv.reader(file("a.txt"))
    for row in csv_data:
    	print row
    	c.execute("INSERT INTO a (first, last) VALUES (%s, %s), row")
    c.commit()
    c.close()