mysql - 我需要在 MySQL 中添加 30 天作为约束
问题描述
我需要在日期列中添加 30 天,并将新日期存储在截止日期列中,作为填充表之前的约束。我已经创建了表格。这是我到目前为止所拥有的:
UPDATE transactions
SET DueDatePayment = DATE_ADD (TransDate, INTERVAL 30 DAY)
Here I don't know what to add to make work.
ALTER TABLE transactions
ADD CONSTRAINT CHECK (ADDDATE ( transDate, INTERVAL 30 DAY);
我有这两个语句,都显示错误。
解决方案
只需删除 DATE_ADD 之后的空格...
UPDATE transactions
SET DueDatePayment = DATE_ADD(TransDate, INTERVAL 30 DAY)
WHERE TransID = 100;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
推荐阅读
- wordpress - Wordpress,在 woocommerce 上的客户中显示自定义字段
- java - Maven Guava缺少方法Sets.symmetricDifference
- c - Segmentation Fault with for loop
- assembly - 如何清除屏幕上的 BIOS 相关信息然后打印信息?
- react-native - 使用 React Native Firebase 创建具有自定义 uid 作为键的用户
- c++ - Can I define a virtual function (or similar) to return of vector of derived class members?
- facebook - Facebook API - retrieve notifications for my own messages
- python - Shapely's Simplify does not simplify
- flutter - 修改 SVG 文件颤动
- java - Split huge Json objects for saving into database