The DB had some 15 columns before. And there are lot of records saved using the s/w tool. But in the latest version of tool there are some columns added in DB inbetween of existing columns. So to use the DB saved using previous version of tool, I need to add some columns(blank) in between in the old DB. But I came to know that new columns can be added only at the end. So I have to create an empty table in new format and insert the records from old table & delete the old table(?). How can I do this efficiently even if there are tens of thousands of records..?
Can I provide mapping of columns to insert from one table to another? (For eg, if the old table has 2 columns & new one 3 columns, I want to insert 1st column to 1st column, 2nd to 3rd and leave 2nd column empty in new table) Thanks.. -- View this message in context: http://old.nabble.com/Inserting-from-other-table-tp28287723p28287723.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
