Re: Setting date as default value
| From: | Paul DuBois | Date: | Tue, 20 Jun 2000 04:55:08 +0000 |
| Subject: | Re: Setting date as default value | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-509@lists.php.net to get a copy of this message | ||
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. -- Paul DuBois, paul@snake.net