MySQL Forums
Forum List  »  General

Advanced Search
New Topic

MySQL ON Update
Posted by: Craig Morris
Date: February 21, 2005 05:02PM

Hey All,

Looking through some source databases, and when exporting them via phpMyAdmin I have found the statement

'Tstamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,'

What im iterested in is the 'on update CURRENT_TIMESTAMP', I have found no reference in the manual for this.

What im trying to add to my table is this

`updated` datetime NOT NULL default '0000-00-00 00:00:00' ON UPDATE NOW( )

but doesnt seem to work, anybody?

Thanks in advance,
Craig

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL ON Update
Craig Morris
February 21, 2005 05:02PM
Re: MySQL ON Update
hossein haghparast
February 21, 2005 05:15PM


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.