MySQL Forums
Forum List  »  MySQL for Excel

Re: 1064 Error
Posted by: Javier Treviño
Date: July 16, 2014 11:05AM

Hi Gil,
Thanks for writing in our forums and for using the product!
The error is being thrown by the MySQL server and not happening in MySQL for Excel, can you please produce the SQL query and execute it in the MySQL console or in MySQL Workbench??

In order to produce the query you need to go to the Global Options (in the Schema or Database objects selection panel) and select "Preview SQL queries before they are sent to the server", then when you try to export the Excel data you will get a dialog where the SQL query for the export is shown, then you can copy&paste it in another tool to execute it.

If you think MySQL for Excel is generating a bad query you would greatly help by raising a bug in our bugs page (http://bugs.mysql.com) and supplying the steps to reproduce, if possible attaching a SQL script to recreate the table giving you problems and the data you are using.

Best regards.

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2772
July 15, 2014 11:59PM
Re: 1064 Error
1466
July 16, 2014 11:05AM
1295
August 24, 2014 11:35PM


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.