patricksky
-
Posts
2 -
Joined
-
Last visited
Never
patricksky's Achievements
Newbie (1/5)
0
Reputation
-
i just try this, that seem cannot work......
-
I have the following creat table script create table event( event_id varchar(9) primary key, title varchar(30) not null, description text, photo_dir varchar(8), date date not null default CURRENT_DATE ); when i run this script, the error occur that related to the CURRENT_DATE. the purpose of the date colume set to default current_date is that if user haven\'t given the date, then set this as system current date. what is the error using CURRENT_DATE ? Thx~