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

问题描述

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

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.

参见文档 http://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html

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