ALTER TABLE table_name
ADD COLUMN create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER create_time;
MySQL create_time/update_time字段自动创建/更新
最新推荐文章于 2024-07-29 16:48:44 发布