CSV import for files with ' apostrophe in the text
I have a csv file which is separated by , but some of the text sections contain ' apostrophe all I get is a syntax issue. If I replace the ' with say a * then it works fine. Surely there must be a way of using the import wizard in MySQL Workbench 8.0 that can handle the ' apostrophe. In SQL Server you can usually just put ''' around it or something to that effect just not sure what the approach is in MySQL.
Any help would be greatly appreciated.
Subject
Views
Written By
Posted
CSV import for files with ' apostrophe in the text
1723
August 06, 2020 04:25AM
705
August 06, 2020 12:17PM
765
August 07, 2020 03:43AM
634
August 07, 2020 08:32AM
554
August 11, 2020 04:02AM
431
August 11, 2020 04:04AM
517
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.