MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: Timestamp
Posted by: Peter Brawley
Date: June 08, 2006 10:27AM

On a 2nd timestamp column, unfortunately, DEFAULT and ON UPDATE are permitted only if the first TIMESTAMP defaults to a constant, so you cannot default both INSERT and UPDATE timestamps to NOW() in the same table. Weird, I know.

PB

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


Subject
Written By
Posted
Timestamp
flashster2003
June 08, 2006 04:56AM
Re: Timestamp
Peter Brawley
June 08, 2006 10: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.