List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 13 2000 9:11pm
Subject:Re: How to make the date automatically increase by one?
View as plain text  
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
Thread
How to make the date automatically increase by one?Wee Chua13 Mar
  • Re: How to make the date automatically increase by one?Paul DuBois14 Mar
  • Re: How to make the date automatically increase by one?Steve Ruby14 Mar