Re: Timestamp fields
Before 5.6.5 only one TIMESTAMP column per table could be defaulted on INSERT or UPDATE.
Since 5.6.5, what you are doing with Triggers can be accomplished with column definitions: any number of TIMESTAMP columns can be defined with any combination of DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP.
Edited 1 time(s). Last edit at 10/21/2012 01:30PM by Peter Brawley.
Subject
Written By
Posted
Re: Timestamp fields
October 20, 2012 09:42PM
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.