RE: [sqlite] Copying the content of a table to another table
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 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 doesn't seem to work for me alter table x add (v3 number,v4 number); Regards, Lloyd On Tue, 2007-06-05 at 11:25 +0530, Kirrthana M wrote: > 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 table(values of > c1 and c2) to the new table and start working with the new table and delete > the existing one,could anybody give me a suggestion for doing this. > > Regards > Kirrthana __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Copying the content of a table to another table
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 doesn't seem to work for me alter table x add (v3 number,v4 number); Regards, Lloyd On Tue, 2007-06-05 at 11:25 +0530, Kirrthana M wrote: > 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 table(values of > c1 and c2) to the new table and start working with the new table and delete > the existing one,could anybody give me a suggestion for doing this. > > Regards > Kirrthana __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Copying the content of a table to another table
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 table(values of c1 and c2) to the new table and start working with the new table and delete the existing one,could anybody give me a suggestion for doing this. Regards Kirrthana