MySQL Forums
Forum List  »  MySQL Workbench

Re: CSV import for files with ' apostrophe in the text
Posted by: David Fretwell
Date: August 07, 2020 03:43AM

I am using 8.0.21.

If I open the file in notepad it is using , to separate the fields but the text is not inside " or anything.

This is the error message I get when trying to load the data into a table:

Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 197, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 132, in start_import
retval = self.module.start(self.stop)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_export_be.py", line 300, in start
ret = self.start_import()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_export_be.py", line 456, in start_import
self._editor.executeManagementCommand(query, 1)
DBError: ("You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Adult`,`AE Identifier`,`Medications for other conditions`,`Site/Trust name`,`D' at line 1", 1064)
ERROR: Import data file: ("You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Adult`,`AE Identifier`,`Medications for other conditions`,`Site/Trust name`,`D' at line 1", 1064)
Failed

It looks to be an issue around " 's Adult " as show on the error message above.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: CSV import for files with ' apostrophe in the text
101
August 07, 2020 03:43AM


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.