先列出ddd sql:
在mysql里执行后,居然报出如下错误:
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or
ON UPDATE clause
goole了一下,搜到了下面这个页面
http://dev.mysql.com/doc/refman/5.1/en/timestamp.html
**************
If a DEFAULT
value is specified for the first TIMESTAMP
column in a table, it is not ignored. The default can be CURRENT_TIMESTAMP
or a constant date and time value.
*************************************
似懂非懂之下,把registrTime这一列的定义拖到了startTime的最前面,搞定。
非常奇怪啊?