Never mind... sorry.
http://www.sqlite.org/faq.html#q13
----- Original Message -----
From: "jose isaias cabrera" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, January 19, 2007 9:44 AM
Subject: [sqlite] Moving data from one table to a new table
Greetings!
I have this table,
CREATE TABLE OpenJobs (
id primary key,
login,
cust,
proj,
bdate date,
edate date,
pm,
lang,
notes,
status);
and I want to move all the data there to this new table,
CREATE TABLE LSOpenJobs (
id primary key,
login,
cust,
proj,
bdate date,
edate date,
pm,
lang,
vendor,
notes,
status);
I know I can write a subrouting to do this, but is there an easier way to
do this from within SQLite? Or the better question would be, can I add
more columns to an already existing table? If there are answers to both
questions, will someone point me to where I can get the answers? Or
answer them? Thanks.
josé
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
