编程论坛's Archiver

xqiang 发表于 2006-9-26 16:33

[求助]列timestamp为何无法使用default?

create table test (<BR>    'UpDate' timestamp default current_timestamp<BR>);<BR><BR>就这么简单的一名建表,为何就是不成功?<BR>报错是这样的:<BR>ERROR 1064 (42000): You have an error in your SQL syntax.  Check the manual that<BR> corresponds to your MySQL server version for the right syntax to use near 'curr<BR>ent_timestamp)' at line 2<BR><BR>有谁知道这是怎么回事?<BR><BR>谢谢<BR>

页: [1]

Powered by Discuz! Archiver 6.1.0  © 2001-2007 Comsenz Inc.