On Thu, Mar 29, 2012 at 1:43 AM, YAN HONG YE <yanhong...@mpsa.com> wrote:
> sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; > Error: Cannot add a column with non-constant default > _______________________________________________ > http://www.sqlite.org/lang_altertable.html The column may not have a default value of CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, or an expression in parentheses. -- -- -- --ô¿ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users