Support Questions
Find answers, ask questions, and share your expertise

How I can bulk insert my csv file into mysql database table

How I can bulk insert my csv file into mysql database table

Explorer

Hi,

I am trying to bulk insert my csv file to mysql table using PutDatabaseRecord.

My CSV file contains all the column values except for the last column as it is auto incremented in table in case of insertion.

 

Can you help me with the attribute setting or processor setting in that case?

1 REPLY 1

Re: How I can bulk insert my csv file into mysql database table

Explorer

Hi,

I am trying to insert my CSV file into mysql table using PutDatabaseRecord processor.

My CSV containr records for all columns except for one as it is auto incremented on insertion.

 

Can you help me with the processors or attribute settings that I can use in such situation?