Re: [sqlite] Split a table

2007-07-11 Thread Ulrich Schöbel
Hi Yves, hi Filip, thanks a lot for your help. You solved my problem and I learned something new. Kind regards Ulrich Am Wednesday 11 July 2007 20:00 schrieb [EMAIL PROTECTED]: > Ulrich Schöbel a écrit : > > As this list has excellent SQL wizards, I hope someone can help > > me on the problem

Re: [sqlite] Split a table

2007-07-11 Thread [EMAIL PROTECTED]
Ulrich Schöbel a écrit : As this list has excellent SQL wizards, I hope someone can help me on the problem to split a table into two. I have something like this: create table org ( a text, b text, c text, d text ); I need to split it into rwo tables as follows: create tbl_a ( a_id i

[sqlite] Split a table

2007-07-09 Thread Ulrich Schöbel
As this list has excellent SQL wizards, I hope someone can help me on the problem to split a table into two. I have something like this: create table org ( a text, b text, c text, d text ); I need to split it into rwo tables as follows: create tbl_a ( a_id integer not null autoincreme