自动时间戳新条目到数据库 (phpMyAdmin) [英] Auto TimeStamp new entry to DB (phpMyAdmin)

问题描述

If I want each new entry into my db to be automatically timestamped, would I set the Field Type to "timestamp" and have the Default value set to "CURRENT_TIMESTAMP"?

Is this the correct method?

解决方案

That is correct. In SQL code that would be:

CREATE TABLE `table` (
    ...
    `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    ...
)

这篇关于自动时间戳新条目到数据库 (phpMyAdmin)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！