Re: Setting date as default value
| From: | Randy Perry | Date: | Tue, 20 Jun 2000 19:29:23 +0000 |
| Subject: | Re: Setting date as default value | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-521@lists.php.net to get a copy of this message | ||
on 6/20/00 12:55 AM, Paul DuBois at paul@snake.net wrote:
> At 8:59 PM -0400 2000-06-19, Randy Perry wrote:
>> Can anyone tell me how to set the current date as a default value with PHP
>> and MySql. I tried using the MySql function CURDATE() as a default like so:
>>
>> ALTER TABLE customer ALTER enter_date SET DEFAULT CURDATE();
>>
>> It didn't like that.
>
>
> Defaults must be constants.
Aha...this ain't Foxpro. :-(