Importing .csv into MySQL error during import
Posted by:
A J
Date: July 29, 2017 07:47PM
Hi. I need help importing a .csv file into MySQL Workbench. So far, I created a schema in Workbench “dbABC” which contains Tables, Views, Stored Procedures, and Functions. I right clicked on “dbABC” and chose Table Data Import Wizard. I chose my .csv file I wanted to import in, clicked Next a few times to start the Import. I then received this error in the Import Data screen. Please let me know how to fix this.
Starting...
Prepare Import...
Prepare Import done
Import data file....
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_wizard.py", line 125, in start_import
retval = self.module.start(self.stop)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 271, in start
ret = self.start_import()
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 408, in start_import
if not self.prepare_new_table():
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 237, in prepare_new_table
self._editor.executeManagementCommand(""" CREATE TABLE %s (%s)""" % (self._table_w_prefix, ", ".join(["`%s` %s" % (col['name'], col["type"]) for col in self._mapping])), 1)
DBError: ("Incorrect column name ''", 1166)
ERROR: Import data file: ("Incorrect column name ''", 1166)
Failed