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
