Re: How to make the date automatically increase by one?

[Paul DuBois]

At 2:10 PM -0500 03-13-2000, Wee Chua wrote:
>Hey all,
>I don't know how to make the date field automatically increase by one
>everyday in MySQL? Would MySQL change automatically to MAR 1 when the
>date comes to FEB 28? Are there any build in function in MySQL for there
>two problems? Thank you.

You'll have to do this yourself.  You could use:

UPDATE tbl_name SET date_col = DATE_ADD(date_col, INTERVAL 1 DAY);

-- 
Paul DuBois, paul@stripped