I have used that example before to recreate a table. Can I use the same thing to recreate a table and populate a new column with data from a select query.
The table I wish to recreate has an ID number in it and I wish to use this to get the forename and surname from another table.
Lloyd
----- Original Message ----- From: "Paul Dixon" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, January 10, 2005 5:50 PM
Subject: Re: [sqlite] add new column to table
Lloyd Thomas wrote:
I wish to create a new column in a table and add data, which is queried from another table.What is the best way?There's no "ALTER TABLE" support in the support language, so you have to recreate the entire table and re-populate it.
Check the FAQ: http://www.sqlite.org/faq.html#q13
Paul
