>-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 current_time.
>
[JS] Would a t
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)