George2 at 15:57, 24 June 2020

2020-06-24T15:57:56Z

George2: Created page with " import MySQLdb, csv, sys conn = MySQLdb.connect (host = "localhost",user = "usr", passwd = "pass",db = "databasename") c = conn.cursor()..."

2019-01-24T17:07:38Z

Created page with "<source lang="python"> import MySQLdb, csv, sys conn = MySQLdb.connect (host = "localhost",user = "usr", passwd = "pass",db = "databasename") c = conn.cursor()..."

New page

<source lang="python">
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()

</source>

@@ Line 6: / Line 6: @@
      for row in csv_data:
      	print row
-     	c.execute("INSERT INTO a (first, last) VALUES (%s, %s), row")
+     	c.execute("INSERT INTO a (first, last) VALUES (%s, %s)", row)
-     c.commit()
+     conn.commit()
      c.close()
 </source>

Insert data into mysql from csv file - Revision history

George2 at 15:57, 24 June 2020

George2: Created page with " import MySQLdb, csv, sys conn = MySQLdb.connect (host = "localhost",user = "usr", passwd = "pass",db = "databasename") c = conn.cursor()..."