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]
-
