Analyzing the MySql CURRENT_TIMESTAMP function by example

When creating a time field

DEFAULT CURRENT_TIMESTAMP

Indicates that when inserting data, the default value of this field is the current time

ON UPDATE CURRENT_TIMESTAMP

Indicates that every time this data is updated, the field will be updated to the current time

These two operations are maintained by the MySQL database itself, so the two fields [Creation Time] and [Update Time] can be generated based on this feature, and no code is required to maintain them.

as follows:

CREATE TABLE `mytest` (
  `text` varchar(255) DEFAULT ''COMMENT 'content',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update time'
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

Can be operated directly through navicat's visual interface

So how do you set a specific default time?

As follows, note that there are two single quotes

TIMESTAMPDEFAULT 'yyyy-mm-dd hh:mm:ss'

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.