Re: [sqlite] how to add time in a new column

2012-03-29 Thread Simon Davies
On 29 March 2012 12:36, Black, Michael (IS) wrote: > You'll need to export the table and data.  Change the SQL to what you want. > Then import again. > > Does the shell have ability to name the columns on the insert  statements > from the .dump to make this easier?  I don' t see anythinig offhan

Re: [sqlite] how to add time in a new column

2012-03-29 Thread Black, Michael (IS)
, March 29, 2012 12:43 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] how to add time in a new column sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; Error: Cannot add a column with non-constant default ___ sqlite-users mailin

Re: [sqlite] how to add time in a new column

2012-03-29 Thread Kevin Benson
On Thu, Mar 29, 2012 at 1:43 AM, YAN HONG YE 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

[sqlite] how to add time in a new column

2012-03-28 Thread YAN HONG YE
sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; Error: Cannot add a column with non-constant default ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users