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
