MySQL Forums
Forum List  »  MySQL Workbench

Re: CSV import for files with ' apostrophe in the text
Posted by: Peter Brawley
Date: August 11, 2020 10:58AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: CSV import for files with ' apostrophe in the text
72
August 11, 2020 10:58AM


Sorry, only registered users may post in this forum.

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.