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
, 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
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> 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
4 matches
Mail list logo