Also doesnt work in 4.1 alpha. Best regards
Nils Valentin Tokyo/Japan (As requested I took Roman of , as he doesnt like direct e-mails ;-) 2003年 6月 25日 水曜日 19:12、Roman Neuhauser さんは書きました: > # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: > > Sometime recently MaFai said: > > > A table contains a column named "mydate". > > > > > > //Wrong sql statement > > > alter table p_asset add mydate datetime default now(); > > > alter table p_asset add mydate datetime default time(); > > > alter table p_asset add mydate datetime default now; > > > alter table p_asset add mydate datetime default time; > > > alter table p_asset add mydate datetime default date(); > > > alter table p_asset add mydate datetime default datetime(); > > > > > > How can I add the default now value into the specified column? > > > I try to find in the mysql manual,but in the default value > > > charter,no relative information can be found. > > > > > > I also know this question is stupid,but hope you help. > > > > alter table p_asset add mydate datetime default 'now()'; > > > > - you need the '' around now(); apparently > > > > http://www.mysql.com/doc/en/DATETIME.html > > and scroll down to the comment made by > > Lazy Soul on Tuesday May 27 2003, @8:15am > > I'd like to know in which version of MySQL this does what it's > intended to do. Definitely not in 4.0.13: > > mysql> create table autotime (foo int, bar datetime default 'now()'); > Query OK, 0 rows affected (0.00 sec) > > mysql> insert autotime set foo = 1; > Query OK, 1 row affected (0.06 sec) > > mysql> insert autotime set foo = 2; > Query OK, 1 row affected (0.00 sec) > > mysql> select * from autotime; > +------+---------------------+ > > | foo | bar | > > +------+---------------------+ > > | 1 | 0000-00-00 00:00:00 | > | 2 | 0000-00-00 00:00:00 | > > +------+---------------------+ > 2 rows in set (0.02 sec) > > mysql> select version(); > +------------+ > > | version() | > > +------------+ > > | 4.0.13-log | > > +------------+ > 1 row in set (0.00 sec) > > > -- > If you cc me or remove the list(s) completely I'll most likely ignore > your message. see http://www.eyrie.org./~eagle/faqs/questions.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
