On 19 Apr 2010, at 6:47pm, sabapathy wrote: > 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)
You might be able to CREATE a VIEW into one table which has the same number of columns as the other table. The version of INSERT which copies rows from one table to another can use that view which will provide a 'fake' number of columns. http://www.sqlite.org/lang_createview.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
