CODEWITHSUNDEEP
sqlmysql
Narendra
Narendra

Reputation: 5773

Inserting default value as current date + 30 days in MySQL

How can I make a column's default value equal to the current date + 30 days in MySQL? For example, if current date is 10-1-2011 then the column value must be inserted as 9-2-2011.

Upvotes: 6

Views: 5149

Answers (1)

moinudin
moinudin

Reputation: 138347

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.

Upvotes: 6

Related Questions