I'd like set up a date database column so that the default value is 30 days from now.
I created the colum and tried to change it like this:
ALTER TABLE news CHANGE expiry expiry DATE DEFAULT 'DATE_ADD(NOW(), INTERVAL 1 MONTH)' NOT NULL
It doesn't work, just ignores the default value
Do I need to work out the default value when I add data using a php script rather than when I create the database?
Julia
