> I tried the following two commands. Neither of them work. Would
> you please let me know what is the command to insert a record with the
> default value?
Try this:
insert into test default values;
Pavel
On Fri, Jul 2, 2010 at 9:40 PM, Peng Yu <pengyu...@gmail.com> wrote:
> Hi,
>
> create table test (value text default 'unknown', value2 text default
> 'unknown');
> insert into test (value) values('xxx');
>
> The above code works correctly. But if there is only one column with a
> default value, I don't see how to insert a record with the default
> value. I tried the following two commands. Neither of them work. Would
> you please let me know what is the command to insert a record with the
> default value?
>
> create table test (value text default 'unknown');
> insert into test () values();
> insert into test values();
>
> --
> Regards,
> Peng
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
