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
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org