MySQL insert from a csv file

Question

I have a csv file I want to load into a database, but can't seem to have a row as a value for the insert function

for row in readCSV:

    cur.execute("INSERT INTO IPaddresses(Start) VALUES(row[0])")

I use the module pymysql

score 1 · Accepted Answer · edited May 23 '17 at 12:06

1

Not sure why you're not using "load data [local] infile". It'd be much easier. Check out the command here: http://dev.mysql.com/doc/refman/5.0/en/load-data.html and someone with a similar problem here Python/MySQL - LOAD DATA LOCAL INFILE

edited May 23 '17 at 12:06

Community

answered Jan 30 '15 at 19:11

user2301506

is it still possible to do it the other way ? – Jesper Petersen Jan 30 '15 at 19:23
@JesperPetersen If you're using MySQLDb, see http://stackoverflow.com/questions/18128870/python-mysqldb-insert-with-prepared-statements – Barmar Jan 30 '15 at 19:39

score 0 · Answer 2 · answered Jan 30 '15 at 19:59

0

What exactly happens when you run the code? Errors? Unexpected values in your table?

answered Jan 30 '15 at 19:59

user2301506

2 Answers2