At 1:32 -0700 9/18/02, neal wrote: >Is there a wat to have mySQL auto fill in the current date into my >dateCreated field? > >In SQLServer I would simply specify the getDate() method as a default value. >I presume I would use the analogous MySQL function curDate() but it does not >appear to work for me.
It's better to read the manual than to presume. In this case, the presumption is incorrect. Default values in MySQL must be constants. However, you might find the TIMESTAMP column type helpful. I'll let you read about it in the manual. :-) http://www.mysql.com/doc/en/DATETIME.html > >Any suggestions? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
