If you're using MySQL >= 5.0, use a trigger:
CREATE TRIGGER setDefaultDate
BEFORE INSERT ON tableName
FOR EACH ROW
SET NEW.date = ADDDATE(curdate(), INTERVAL 30 DAY);
The trigger will activate when you insert into tableName
, setting date
to now + 30 days. If your insert sets the date, it will override this default due to the BEFORE
. The date is calculated using ADDDATE
.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…