Thanks, Igor.
On Thursday, January 22, 2015 4:23 PM, Igor Tandetnik <i...@tandetnik.org>
wrote:
On 1/22/2015 4:05 PM, Jose I. Cabrera wrote:
> imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create
>table t1 (a,b,c,de,e,f);insert into t1 values ('a','b','c',(select * from
>t0));Error: table t1 has 6 columns but 4 values were supplied
> What I would like is to add t0 to t1 so that t1 now hasa|b|c|d|e|f
insert into t1
select 'a', 'b', 'c', *
from t0;
--
Igor Tandetnik
_______________________________________________
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
