Error while inserting data to database from csv in remote MySQL
- Dominant language
- Python
- Stars
- 1k
- Forks
- 131
- PR merge metrics
- No merged PRs in 30d
Description
Hi,
I am trying to read CSV dynamically and then by using ODO creating a table schema and hence inserting the CSV data into it. ODO is able to create the table schema successfully but raising error while inserting data into the same table. It is not able to insert a single row.
Also is it possible to create a connection string? I am using the following parameter in string
"host", "user", "passwd", "db", "local_infile"
For this my URI is
odo('G:/django/ml_app/documents/demo.csv', 'mysql://abc:abc1234@abc.cxu0mytwya5e.us-east-1.rds.amazonaws.com/abcdb::testTbl9', delimiter='|')
But I am getting the following error. (I have replaced gpa by abc)

Any help would be appreciated!!!
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.