re: Can I set a default value to a function?

2003-01-28 Thread Egor Egorov
On Tuesday 28 January 2003 05:04, Carlin Anderson wrote: > I am running mysql 3.23, and want to know if I can set the default value > of a column to to_days(now()), or the equivelant. I have tried this, > and the default gets translated to 0. Nope. Default column value must be constant. -- F

Re: Can I set a default value to a function?

2003-01-28 Thread Jeremy Zawodny
On Mon, Jan 27, 2003 at 10:04:07PM -0500, Carlin Anderson wrote: > I am running mysql 3.23, and want to know if I can set the default value > of a column to to_days(now()), or the equivelant. I have tried this, > and the default gets translated to 0. You cannot. -- Jeremy D. Zawodny | Perl,

Can I set a default value to a function?

2003-01-27 Thread Carlin Anderson
I am running mysql 3.23, and want to know if I can set the default value of a column to to_days(now()), or the equivelant. I have tried this, and the default gets translated to 0. Thanks Carlin - Before posting, please check: