I am trying to run a SQL statement using cursor.execute
<code>LOAD DATA LOCAL INFILE
'/home/ubuntu/test.csv'
INTO TABLE app_data
CHARACTER SET UTF8MB4 FIELDS TERMINATED BY ','
ENCLOSED BY ""
LINES TERMINATED BY 'rn'
</code>
<code>LOAD DATA LOCAL INFILE
'/home/ubuntu/test.csv'
INTO TABLE app_data
CHARACTER SET UTF8MB4 FIELDS TERMINATED BY ','
ENCLOSED BY ""
LINES TERMINATED BY 'rn'
</code>
LOAD DATA LOCAL INFILE
'/home/ubuntu/test.csv'
INTO TABLE app_data
CHARACTER SET UTF8MB4 FIELDS TERMINATED BY ','
ENCLOSED BY ""
LINES TERMINATED BY 'rn'
This runs using mysql command line but the ENCLOSED BY raises a ProgrammingError / OperationalError.
Any help/pointers appreciated. I have already tried variations such as ENCLOSED BY ‘”‘.