MySQL在插入时的DATETIME字段中设置当前日期 [英] MySQL set current date in a DATETIME field on insert

问题描述

我有一个"created_date" DATETIME字段，我希望在插入时使用当前日期填充该字段.我应该为此触发使用什么语法?到目前为止，这是我所拥有的，但这是不正确的.

I have a 'created_date' DATETIME field which I would like to be populated with the current date upon insert. What syntax should I use for the trigger for this? This is what I have so far but it is incorrect.

CREATE TRIGGER set_created_date
BEFORE INSERT ON product
FOR EACH ROW BEGIN
SET NEW.created_date = now();

推荐答案

您最好的选择是将该列更改为时间戳. MySQL将自动使用连续的第一个时间戳作为最后修改的"值，并为您更新它.如果您只想节省创建时间，则可以进行配置.

Your best bet is to change that column to a timestamp. MySQL will automatically use the first timestamp in a row as a 'last modified' value and update it for you. This is configurable if you just want to save creation time.

请参阅doc http://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html

这篇关于MySQL在插入时的DATETIME字段中设置当前日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！