Setting date as default value
| From: | Randy Perry | Date: | Tue, 20 Jun 2000 00:59:33 +0000 |
| Subject: | Setting date as default value | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-506@lists.php.net to get a copy of this message | ||
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.
--
Randy Perry
rgp systems
Mac Consulting/Sales