blocks|key|369369|text|创建一个表并为该表设置一个触发器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|369370|CREATE+TABLE+product(
++++product_id+INT+PRIMARY+KEY,
++++product+VARCHAR(40),
++++entryDate+DATETIME,
++++expDate+DATETIME
);

CREATE+TRIGGER+test_trigger+BEFORE+INSERT+ON+`product`+
FOR+EACH+ROW+SET
++++NEW.entryDate+=+IFNULL(NEW.entryDate,+NOW()),
++++NEW.expDate+=+TIMESTAMPADD(DAY,+14,+NEW.entryDate);|code-block|syntax|javascript|369371|在每个插入到表中时，触发器将entryDate设置为当前时间，expDate设置为14天时间。|offset|length|style|CODE|369372|entityMap^0|0|0|E|9|V|7|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

Create a table and set up a trigger for that table.

<pre><code>CREATE TABLE product(
 product_id INT PRIMARY KEY,
 product VARCHAR(40),
 entryDate DATETIME,
 expDate DATETIME
);

CREATE TRIGGER test_trigger BEFORE INSERT ON `product` 
FOR EACH ROW SET
 NEW.entryDate = IFNULL(NEW.entryDate, NOW()),
 NEW.expDate = TIMESTAMPADD(DAY, 14, NEW.entryDate);
</code></pre>

On each insert into the table, the trigger sets the <code>entryDate</code> to the current time and <code>expDate</code> to 14 days time.

blocks|key|274204|text|您可以在MySQL中使用MySQL方法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|274205|DATE_ADD(date_starts,INTERVAL+14+DAY)|code-block|syntax|javascript|274206|例如：|274207|UPDATE+events+SET+date_starts+=+DATE_ADD(date_starts,INTERVAL+14+DAY)+WHERE+event_id+=+3;|274208|有关更多细节，请访问这里。|274209|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html^0|4|5|0|0|0|0|A|2|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|Q|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

You can use this by using <code>DateTime</code> methods in MySQL:

<pre><code>DATE_ADD(date_starts,INTERVAL 14 DAY)
</code></pre>

for example:

<pre><code>UPDATE events SET date_starts = DATE_ADD(date_starts,INTERVAL 14 DAY) WHERE event_id = 3;
</code></pre>

For more details go <a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html" rel="nofollow">here</a>.

blocks|key|369330|text|date+=+DATE_ADD(NOW(),+INTERVAL+14+DAY)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|369331|或者如前所述，将该字段(该field=的属性)的表结构更改为"on+Update+CURRENT_TIMESTAMP“|unstyled|369332|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>date = DATE_ADD(NOW(), INTERVAL 14 DAY)
</code></pre>

or as said, alter your table structure for that field (attribute for that field=) to "on Update CURRENT_TIMESTAMP"

blocks|key|368395|text|您可以尝试这个函数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|368396|DATE_ADD(now(),+INTERVAL+14+DAY);|offset|length|style|CODE|368397|entityMap^0|0|0|X|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

you can try this this function

<code>DATE_ADD(now(), INTERVAL 14 DAY);</code>

blocks|key|754178|text|根据这个来源，您不能使用表达式作为默认说明符。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|754179|所以不确定它是否在错误发布后发生了变化。|754180|但是，我不知道为什么我假设OP要将其定义为默认值。|754181|entityMap|0|LINK|mutability|MUTABLE|url|http://bugs.mysql.com/bug.php?id=56835^0|4|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

According to this <a href="http://bugs.mysql.com/bug.php?id=56835" rel="nofollow">source</a> you can't use expressions as a default specifier.

So not sure if it has changed since the bug was posted.

I'm not sure however why I assumed that the OP wants to define it as a default value.

blocks|key|754227|text|我相信MySQL不会允许您使用默认值的表达式。你可能想写个触发器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|754228|MySQL确实提供了时间戳数据类型，可以在创建或更新行时将其设置为CURRENT_TIMESTAMP。您可能会发现这个特性有些用处：|754229|CREATE+TABLE+table1+(
++++`Column1`+VARCHAR(50)+NULL,
++++`Created`+TIMESTAMP+NOT+NULL+DEFAULT+CURRENT_TIMESTAMP
)|code-block|syntax|javascript|754230|一旦您确信MySQL按预期填充了该列，就可以编写如下查询：|754231|SELECT+`Created`,+`Created`+%2B+INTERVAL+14+DAY+AS+`expiry_date`
FROM+table1|754232|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I believe MySQL won't allow you to use expressions in the default value. You might want to write a trigger.

MySQL does provide a TIMESTAMP datatype which can be set to CURRENT_TIMESTAMP when a row is created or updated. You might find this feature somewhat useful:

<pre><code>CREATE TABLE table1 (
 `Column1` VARCHAR(50) NULL,
 `Created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
)
</code></pre>

Once you're sure that MySQL is filling that column as expected, you can write queries like this:

<pre><code>SELECT `Created`, `Created` + INTERVAL 14 DAY AS `expiry_date`
FROM table1
</code></pre>

blocks|key|754283|text|解决这个问题的最简单的方法就是插入你想要的值--没有触发器或者以后的更新，例如。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|754284|+INSERT+INTO+<your_table>+(name,+expiry_date)+VALUES+('foo',+DATE_ADD(CURRENT_TIMESTAMP,INTERVAL+7+DAY))|code-block|syntax|javascript|754285|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The easiest way to solve that is just insert the value you want - without trigger or later update, eg.

<pre><code> INSERT INTO &lt;your_table&gt; (name, expiry_date) VALUES ('foo', DATE_ADD(CURRENT_TIMESTAMP,INTERVAL 7 DAY))
</code></pre>

blocks|key|368437|text|我更喜欢这种格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|368438|SELECT+NOW()%2BINTERVAL+14+DAY|code-block|syntax|javascript|368439|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I like this format better:
<pre><code>SELECT NOW()+INTERVAL 14 DAY
</code></pre>

I was wondering if the following is possible to do through MySQL or will it have to be done using PHP.

Task - "Expiry Date"

<ol>
<li>User enters product name</li>
<li>User clicks submit form button</li>
<li>Data is POST'ed and then sent to MySQL</li>
<li>Expiry date = date now + 14 days</li>
</ol>

What I am trying to achieve is a way for mysql to insert an "expiry_date" in a table column that will equal 14 days after the date the row was created in that table.

e.g.

<pre><code>product_name - foo
entry_date - 2012-02-01
expiry_date - 2012-02-15
</code></pre>

I have a feeling it may not be possible to do in mysql unless using a stored procedure.

I am happy to do it in PHP however I was hoping if I could do it with mysql it would leave less scope for error in my system.

Thanks

MySQL default date() + 14 days, for a column?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我想知道是否可以通过MySQL完成以下操作，还是必须使用PHP完成。任务-“到期日期”用户输入产品名称用户单击“提交表单”按钮数据被发布，然后发送到MySQL到期日期=现在的日期+ 14天我试图实现的是mysql在表列中插入一个"expiry_date“的方法，该列在表中创建行的日期后14天。例如：product_name - fooentry_date - 2012-02-01expiry_da

问MySQL默认日期()+ 14天，列？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL默认日期()+ 14天，列？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL默认日期()+ 14天，列？
EN