Mysql command in python yields: SyntaxError: EOL while scanning string literal

Question

I get this error:

SyntaxError: EOL while scanning string literal

while trying to push a CSV file of more than 20 million rows to MySQL server, using this python code:

cur = connection.cursor()

query = "LOAD DATA LOCAL INFILE 'path to csv file' INTO TABLE table.name FIELDS OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';"

cur.execute( query )

connection.commit()

blhsing · Accepted Answer · 2019-12-18 08:26:59Z

2

When you enclose a string literal with a double quote in double quotes, you should either escape the double quote with a back slash:

query = "LOAD DATA LOCAL INFILE 'path to csv file' INTO TABLE table.name FIELDS OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\r\n';"

or enclose the string literal in triple quotes:

query = '''LOAD DATA LOCAL INFILE 'path to csv file' INTO TABLE table.name FIELDS OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';'''

answered Dec 18, 2019 at 8:26

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Mysql command in python yields: SyntaxError: EOL while scanning string literal

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related