错误日志：

{ [Error: Incorrect datetime value: ‘2012-08-24T17:29:11.683Z’ for
column ‘robot _refreshed_at’ at row 1] number: 1292,sqlStateMarker:
‘#’,sqlState: ‘22007’,message: ‘Incorrect datetime value:
\’2012-08-24T17:29:11.683Z\’ for column \’ robot_refreshed_at\’ at row
1′,sql: ‘INSERT INTO users
(id,name,count_moments,count_likes,count_followers,rob
ot_refreshed_at,robot_count_followers) VALUES
(\’1834084\’,\’NNNyingzi\’,\’5\’,\
‘0\’,\’0\’,\’2012-08-24T17:29:11.683Z\’,\’0\’)’,setMaxListeners:
[Function],emit: [Function],addListener: [Function],on: [Function],
once: [Function],removeListener: [Function],removeAllListeners:
[Function],listeners: [Function] }

我在Node.js中使用这段代码

@H_301_25@  if s instanceof Date
         return s.toISOString()

并在数据库中更新它们.

sql插入表达式如下：

@H_301_25@     INSERT INTO users (id,rob ot_refreshed_at,robot_count_followers) VALUES (\'1834084\',\'NNNyingzi\',\'5\',\ '0\',\'0\',\'2012-08-24T17:29:11.683Z\',\'0\')

我做错了吗？我只是从服务器中的表中使用PHPMyAdmin复制了一个表.

非常感谢.

MysqL recognizes 07001 and 07002 values in these formats:

• As a string in either @H_301_25@'YYYY-MM-DD HH:MM:SS' or @H_301_25@'YY-MM-DD HH:MM:SS' format. A “relaxed” Syntax is permitted here,too: Any punctuation character may be used as the delimiter between date parts or time parts. For example,@H_301_25@'2012-12-31 11:30:45',@H_301_25@'2012^12^31 11+30+45',@H_301_25@'2012/12/31 11*30*45',and @H_301_25@'2012@12@31 11^30^45' are equivalent.

• As a string with no delimiters in either @H_301_25@'YYYYMMDDHHMMSS' or @H_301_25@'YYMMDDHHMMSS' format,provided that the string makes sense as a date. For example,@H_301_25@'20070523091528' and @H_301_25@'070523091528' are interpreted as @H_301_25@'2007-05-23 09:15:28',but @H_301_25@'071122129015' is illegal (it has a nonsensical minute part) and becomes @H_301_25@'0000-00-00 00:00:00'.

• As a number in either @H_301_25@YYYYMMDDHHMMSS or @H_301_25@YYMMDDHHMMSS format,provided that the number makes sense as a date. For example,@H_301_25@19830905132800 and @H_301_25@830905132800 are interpreted as @H_301_25@'1983-09-05 13:28:00'.

A 07001 or 07002 value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. Although this fractional part is recognized,it is discarded from values stored into 07001 or 07002 columns. For information about fractional seconds support in MysqL,see 07007.

您的日期字体’2012-08-24T17：29：11.683Z’不适合任何这些格式;建议你 –

>使用Node.js Date对象的toLocaleFormat()方法(确保MysqL连接的时区与Node.js的语言环境的时区匹配)：

@H_301_25@  if s instanceof Date
         return s.toLocaleFormat("%Y-%m-%d %H:%M:%s")

>使用Node.js Date对象的valueOf()方法获取自UNIX纪元以来的时间值(以毫秒为单位),除以1000(从UNIX纪元开始获得秒数)并通过MysqL的FROM_UNIXTIME()函数.

我试图在MySQL表中插入一行并获取它的插入ID.我知道MysqL的last_insert_id()函数,我似乎无法让它工作.目前,我正在尝试使用注释为事务的函数,我只返回0.我使用的是Spring 3.1.

    @Transactional (propagation = Propagation.required,rollbackFor = Exception.class)
    private long insertTransactionRecord 
    (
        int custID,int porID,String date,short crvID
    ) {
        m_template.update ("INSERT INTO " +
                           "    transaction " +
                           "( " +
                           "    por_id," +
                           "    cust_id," +
                           "    trans_date," +
                           "    crv_id " +
                           ") " +
                           "VALUES " +
                           "( " +
                           "    ?," +
                           "    ?," +
                           "    ? " +
                           ")",new Object[] {
                               porID,custID,date,crvID
                           });
        return m_template.queryForLong ("SELECT " +
                                        "    last_insert_id() " +
                                        "FROM " +
                                        "    transaction " +
                                        "LIMIT 1");
    }

public int createCompany(Company company) throws sqlException {
        jdbcTemplate.update(
                "INSERT INTO company (name) VALUES (?)",company.getName()
        );
        return jdbcTemplate.queryForInt( "select last_insert_id()" );
    }

如果你注意到那里没有FROM

解决方法