Hi All ,
I am using Import CSV to Database smartservice to insert data to MySQL database table but data is not inserting I am getting following 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 '[Data Store Entity:"7db49057-d16b-495d-9a26-a1156390fb73@451789"]' at line 1
C S V Document : I have referred a document in knowledge base (CSV file I have downloaded from the data base table )
Data Source Name : Given a constant which contain jdbc connection string
Delimiter: , and ; both these two I have tried
Table Name: I have created a constant which is of type Data store entity and referred the desired entity
Please correct me where I am doing wrong.
And also let me know this plugin will do update also i.e If I gave the data which is already exist for primary key value , will it update the data ?? or only insert it will do
Thank you,
Bhargavi
Discussion posts and replies are publicly visible