MySQL Forums
Forum List  »  MySQL for Excel

Re: Retain leading zeros
Posted by: Javier Treviño
Date: April 16, 2015 01:42PM

Hi Benjamin,
Thanks for writing in our forums!

I tested your scenario and this is clearly a bug in MySQL for Excel, could you please raise a bug report in about it?

Since we are talking about the PK here, it is a field that normally does not need to be edited, but I understand that you may want to insert new data into the table.
As a workaround you can simply change the format of the cells from "Number" to "Text", you will see that the data will be committed successfully into the DB.

Hope this helps.

Best regards.

Javier Treviño
MySQL on Windows Team

Options: ReplyQuote

Written By
April 08, 2015 09:43AM
Re: Retain leading zeros
April 16, 2015 01:42PM

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.