RE: Default Date and Time

>-Original Message- >From: Jason Todd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com] >Sent: Friday, June 26, 2009 1:10 PM >To: mysql@lists.mysql.com >Subject: Default Date and Time > >Hi All, > >I want to create a table that defaults to current_date and c

Re: Default Date and Time

Hi Jason The DEFAULT value can't be an expression. 2009/6/26 Jason Todd Slack-Moehrle > Hi All, > > I want to create a table that defaults to current_date and current_time. > > I have: > > CREATE TABLE `personalevent`( >`pevent` mediumint(10) NOT NULL, >`eventid` mediumint(10)

Default Date and Time

Hi All, I want to create a table that defaults to current_date and current_time. I have: CREATE TABLE `personalevent`( `pevent` mediumint(10) NOT NULL, `eventid` mediumint(10) NOT NULL, `userid` mediumint(10) NOT NULL, `username` varchar(10) NOT NULL, `pa