Detailed example of how mysql automatically obtains the time and date

Implementation method:

1. Set the field type to TIMESTAMP

2. Set the default value to CURRENT_TIMESTAMP

##Example application:

1. MySQL script implementation use case

--Add CreateTime to set the default time CURRENT_TIMESTAMP

ALTER TABLE `table_name`
ADD COLUMN  `CreateTime` datetime NULL 
DEFAULT
 
CURRENT_TIMESTAMP 
COMMENT '创建时间' ;

--Modify CreateTime to set the default time CURRENT_TIMESTAMP
##

ALTER TABLE `table_name`MODIFY COLUMN  `CreateTime` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ;

--Add UpdateTime to set the default time CURRENT_TIMESTAMP Set the update time to ON UPDATE CURRENT_TIMESTAMP

ALTER TABLE `table_name`ADD COLUMN `UpdateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间' ;

##--Modify UpdateTime to set the default time

CURRENT_TIMESTAMP Set the update time to ON UPDATE CURRENT_TIMESTAMP

ALTER TABLE `table_name`
MODIFY COLUMN `UpdateTime` timestamp NULL 
DEFAULT CURRENT_TIMESTAMP ON UPDATE
 
CURRENT_TIMESTAMP
 COMMENT '创建时间' ;

##2. MySQL tool settings

Summarize:

1. MySQL automatically manages and maintains time consistency with the database;

2. Simple and efficient, no application development support is required. MySQL autocomplete;

The above is the detailed content of Detailed example of how mysql automatically obtains the time and date. For more information, please follow other related articles on the PHP Chinese website!