Difference between revisions of "Insert data into mysql from csv file"
From MyWiki
(Created page with "<source lang="python"> import MySQLdb, csv, sys conn = MySQLdb.connect (host = "localhost",user = "usr", passwd = "pass",db = "databasename") c = conn.cursor()...") |
|||
| Line 6: | Line 6: | ||
for row in csv_data: | for row in csv_data: | ||
print row | print row | ||
| − | c.execute("INSERT INTO a (first, last) VALUES (%s, %s), row | + | c.execute("INSERT INTO a (first, last) VALUES (%s, %s)", row) |
| − | + | conn.commit() | |
c.close() | c.close() | ||
</source> | </source> | ||
Latest revision as of 15:57, 24 June 2020
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) conn.commit() c.close()
