MySQL Forums
Forum List  »  MySQL for Excel

Re: 1064 error when exporting
Posted by: Javier Treviño
Date: September 28, 2015 11:01AM

Hi Nico,
Thanks for writing in our forums.

Just by looking at the error message you pasted here, I can think that you typed in something on the data type combo box for the `Research_Output_Category`column. The data type according to the error message seems to be "varc'" (with an apostrophe at the end of it). Can you confirm this?

A screenshot of the Export Data dialog before clicking Export and a copy of the generated SQL script for the "CREATE TABLE" statement would also help me troubleshoot your problem. To get the generated SQL script you need to go to the global options and check the setting to show SQL scripts before sending them to the server.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
2055
September 26, 2015 04:41AM
Re: 1064 error when exporting
1138
September 28, 2015 11:01AM
883
October 17, 2015 03:23AM


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.