At 20:25 -0500 4/4/02, James Hedrick wrote: >Hi Gang, >I am currently specing out a table in MySQL manager and I am trying to set >sysdate as default value for ActivityDate column ( a datetime field). If I >specify sysdate() in default value field then the DDL changes to show >default as "default '0000-00-00 00:00:00'". What am I doing wrong? > >Thanks, >James
You're not believing the manual, which says that default values must be constants. :-) --------------------------------------------------------------------- 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