Re: CSV import for files with ' apostrophe in the text
If WB proposes making a table with such names and definitions, I'm astonished ...
1 All columns---numbers, dates, everything---are text. That's excruciatingly stupid and wrong.
2 The table name and column names contain spaces. Such names need to be surrounded by backticks whenever they're referenced. Yikes.
3 The import file is suspect, MySQL usually doesn't like sequences of commas representing missing values.
So if it's me, I fix the names and definitions, create the table, then reprocess the import file to provide suitable defaults for missing values.
Edited 1 time(s). Last edit at 08/11/2020 11:04AM by Peter Brawley.
Subject
Views
Written By
Posted
1761
August 06, 2020 04:25AM
722
August 06, 2020 12:17PM
783
August 07, 2020 03:43AM
647
August 07, 2020 08:32AM
565
August 11, 2020 04:02AM
440
August 11, 2020 04:04AM
Re: CSV import for files with ' apostrophe in the text
527
August 11, 2020 10:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.