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

Community · Accepted Answer · 2017-05-23 12:06:31Z

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

CommunityBot

11 silver badge

answered Jan 30, 2015 at 19:11

user2301506

3005 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

is it still possible to do it the other way ?

@JesperPetersen If you're using MySQLDb, see stackoverflow.com/questions/18128870/…

user2301506 · Accepted Answer · 2015-01-30 19:59:11Z

0

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

answered Jan 30, 2015 at 19:59

user2301506

3005 silver badges11 bronze badges