MySQL 在插入时在 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 将自动使用一行中的第一个时间戳作为最后修改"值并为您更新它.如果您只想节省创建时间，这是可以配置的.