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

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

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

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