Re: [sqlite] Copying the content of a table to another table

2007-06-05 Thread Lloyd
create table x(c1 number,c2 number); create table y(v1 number,v2 number,v3 number,v4 number); insert into y (v1,v2) select c1,c2 from x; or better you can use the alter table command on your old table (here x) alter table x add v3 number; alter table x add v4 number; the following way

RE: [sqlite] Copying the content of a table to another table

2007-06-05 Thread Kirrthana M
Thanks i ll check it out.. -Original Message- From: Lloyd [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 1:37 PM To: Kirrthana M Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] Copying the content of a table to another table create table x(c1 number,c2 number); create table

[sqlite] Copying the content of a table to another table

2007-06-04 Thread Kirrthana M
Hi all, I have created a table with two columns c1 and c2 and inserted some values into,in future i may include some additional columns c3,c4. to the same table.In tat case i should not loose my data in the current table,so i should be able to copy the content of the current