MySQL Forums
Forum List  »  MySQL for Excel

timestamp problem: append new data fail
Posted by: yunwei dong
Date: September 02, 2014 09:27AM

mysql environment: redhat-linux-gnu(x86-64) mysql version 5.1.73
client environment: windows 7 (VM) + excel 2010+mysql for excel 1.2.1

The problem: when I used append data to table button, one of the column is timestamp. (e.g. 9/17/2011 11:23:01).

The sql created by the mysqlforexcel is this:

INSERT INTO `test23`.`testtime` (`value`,`timestamp`) VALUES (244444,'0000-00-00 00:00:00');

Apparently, mysqlforexcel can not recognize the timestamp identified in the excel.

The solution I tried:
1. I try different excel format, none of them work.
2. I try Edit data in table function. After input the data and click commit, the data (exactly the same format) actually get into the db without any problems. THe SQL mysqlforexcel seems fine.

I was using the mysqlForExcel1.2.0 before without any problems. Just wondering what is going on for the new version.

Options: ReplyQuote


Subject
Views
Written By
Posted
timestamp problem: append new data fail
2111
September 02, 2014 09:27AM


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.