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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
