I'm using the following DDL statement: create table if not exists dbname.tablename ( ..., the_date date not null default current_date );
I receive the following error message: ERROR 1064: You have an error in your SQL syntax near 'current_date, I'm been looking around and can find no support on how to instruct the database to default to current date. All I've found was something like this: create table if not exists dbname.tablename ( ...., the_date date not null default '0000-00-00' ); This second option is not really what I want. I want the let the database create the current date when I insert a row. Is this possible and if so, how can it be done? Thanks. Eric Ray [EMAIL PROTECTED] --------------------------------------------------------------------- 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