Skip to content

Error while inserting data to database from csv in remote MySQL #620

@girijesh18

Description

@girijesh18

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:[email protected]/abcdb::testTbl9', delimiter='|')

But I am getting the following error. (I have replaced gpa by abc)

screenshot 31

Any help would be appreciated!!!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions