hi,
I have following situation:
database2006: table 'myname': Columns: "ID integer primary key,
timestamp integer, x text, y text
database2007: table 'myname': Columns: "ID integer primary key,
timestamp integer, x text, y text
empty
comvineddatabase: : table 'myname': Columns: "ID integer primary key,
timestamp integer, x text, y text
I would like do have a combined database table 'myname': Columns: "ID
integer primary key, timestamp integer, x text, y text
where I insert first the columns of database2006, and afterwards
database2007.
at the moment I do something like this:
*attach: database2006:*
select timestamp, x , y from database2006
and for eachrow in selectionresult
insert into comvineddatabase (timestamp, x , y) values(?,?,?)
*after that the same for database2006.*
select timestamp, x , y from database2006
and for eachrow in selectionresult
insert into comvineddatabase (timestamp, x , y) values(?,?,?)
I was wondering if there is not a more effective way of doing that:
maybe even within a single SQL statement?
Thanks in advance W.Braun