-- 2024-07-22 10:22:20
select (DATE_FORMAT(CURRENT_TIMESTAMP, '%Y-%m-%d %H:%i:%s'));
ALTER TABLE tablename
MODIFY COLUNN CREATE_DATE varchar (23)
DEFAULT(DATE_FORMAT(CURRENT_TIMESTAMP, '%Y-%m-%d %H:%i:%s'))
COMMENT "创建日期;
-- 2024-07-22 10:22:20
select (DATE_FORMAT(CURRENT_TIMESTAMP, '%Y-%m-%d %H:%i:%s'));
ALTER TABLE tablename
MODIFY COLUNN CREATE_DATE varchar (23)
DEFAULT(DATE_FORMAT(CURRENT_TIMESTAMP, '%Y-%m-%d %H:%i:%s'))
COMMENT "创建日期;