Re: CSV import for files with ' apostrophe in the text
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.