MySQL Forums
Forum List  »  MySQL Workbench

CSV import for files with ' apostrophe in the text
Posted by: David Fretwell
Date: August 06, 2020 04:25AM

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.

Options: ReplyQuote

Written By
CSV import for files with ' apostrophe in the text
August 06, 2020 04:25AM

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.