Databases Reference
In-Depth Information
Small symbols on each side of the month and year headers permit easy scrolling
through months and years, and a simple click on the date we want transports it to
our date_published field.
For a DATETIME or TIMESTAMP field, the popup offers to edit the time part:
TIMESTAMP Options
Starting with MySQL 4.1.2, there are more options that can affect a TIMESTAMP
column. Let's add to our topics table a column named stamp of type TIMESTAMP .
As soon as we choose TIMESTAMP from the Type drop-down list - provided that
JavaScript has been activated in our browser - we see a new checkbox under the
Default column: CURRENT_TIMESTAMP . Note that in the Attributes column, we
can choose ON UPDATE CURRENT_TIMESTAMP .
 
Search WWH ::




Custom Search