[sqlite] append table

2009-05-16 Thread James Gregurich
howdy! Questions: suppose tables t1 t2 exits in two separate db files, d1 d2 respectively. t1 t2 have identical schemas, but different data. I want to append t2 to t1. I suppose the way to do that is to open a connect to d1, use the attach command to reference d2.t2 and issue a

Re: [sqlite] append table

2009-05-16 Thread P Kishor
On Sat, May 16, 2009 at 5:22 PM, James Gregurich bayouben...@mac.com wrote: howdy! Questions: suppose tables t1 t2 exits in two separate db files, d1 d2 respectively. t1 t2 have identical schemas, but different data. I want to append t2 to t1. I suppose the way to do that is to open