Hi,
I have a requirement to dump CSV file into database wirh extra columns and tried using "Load CSV to Database" plugin available.
Even after giving the column names correctly, it is not inserting the data into database and is giving below error:
__________________________________________________________________________________
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
___________________________________________________________________________________
Could someone help me in resolving the issue.
Thanks,
J Neelima
Discussion posts and replies are publicly visible
neelimaj328 I dont think we can add any extra column in that smart service. It will just move the data from CSV to DB only.
Can you provide the usecase that why we need to add extra column ?
Hi Dinesh,
There is an option to add extra columns in Load CSV to Database. Please find below screenshot.
J. Neelima
Hi Neelima,
Have you given the same column name in the above configuration as present in the database table?
Hi Vadivelan,
Yes, I did.