MySQL Forums
Forum List  »  MySQL Workbench

How to set TIMESTAMP and DATETIME in workbench
Posted by: Pete Watters
Date: September 01, 2017 10:17AM

Using work bench I have 2 data fields/columns that are dates

One is the date and time the record was first inserted into the table and will remain the same until the record is deleted lets call it DATE_CREATED

The second is the date and time the record was updated lets call it DATE_CREATED

Data Type for both is TIMESTAMP or should I make it DATETIME

In the workbench how should I set the default value to keep DATE_CREATED static and keep DATE_UPDATED dynamic so it changes each time the record is updated

Options: ReplyQuote


Subject
Views
Written By
Posted
How to set TIMESTAMP and DATETIME in workbench
137
September 01, 2017 10:17AM


Sorry, only registered users may post in this forum.

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.