From: Scott Haneda (talklistsnewgeo.com)
Date: Tue Apr 28 2009 - 19:28:52 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

We need to see your entire query and the table structure. timestamp
fields can have options set to auto update them, where order matters,
and only one field can support that feature.

Please supply more data.

On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote:

> You have an error in your SQL syntax; check the manual that
> corresponds to
> your MySQL server version for the right syntax to use near 'Created
> = NOW(),
> Updated = NOW()' at line 8
>
> 'Created' and 'Updated' are set to datetime (InnoDB).
>
> The same syntax works for some newly created tables... and gives no
> error.
>
> It's very strange. 'Now()' works for some tables, and it doesn't for
> some.
> (All set in phpmyadmin...)
>
> What could have caused this? Any similar experience?

--
Scott * If you contact me off list replace talklists with scott *

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]