Updating an SQLite table

I have two tables. The two tables have more than one column in common. One of these columns has unique value. One column is there in one table which is not present in other table. How can write a query which can insert that column data from 开发者_JS百科one table into other table?

You need to use the ALTER TABLE query to add the column to the second table.

ALTER TABLE Your_Table ADD NewFieldName NewFieldType

Then just copy the data from one table to another.