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 '创建时间' ;
Copy after login
--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 '创建时间' ;
Copy after login
##--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 '创建时间' ;
Copy after login
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!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
