November 7, 2022 at 10:38 am
Thank you for your help. I have tested "LOAD DATA INFILE" from csv.
The main problem is CSV itself generating wrong data.
Ex: if I have columns like this, value is loaded differently in each column. Some of CreatedDate value is loade into CreatedBy etc.
Location_ID -bigint
Location -nvarchar
SetAsDefault -bit
CreatedBy -nvarchar
CreatedDate -datetime
Just noticed it is because of "," ex: - Irvington, NJ Office
November 7, 2022 at 12:04 pm
yes - that is one of the pains of using the files - on the cases where you have values on your tables with the delimiter you use you need to enclose those fields with double quotes - and if there is a double quote within the contents it needs to be escaped - similar for the delimiter itself I think. (not enough knowledge here as I don't use mysql)
the db to db option (the other option on the wizard) is likely to bypass this issue - but the query it generates may still need to be changed in some cases.
Viewing 2 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply