Android SQLite: How to insert data in to a single column of an existed table?

You should read both files simultaneously line-by-line and insert the data into the table with a single insert per line INSERT INTO table_name (linefrompart1, linefrompart2) VALUES ('lili', 'like eating apple') Alternatively if this is not possible then you could add an extra column to your table to store the line number and use an update statement with 'WHERE linenumber = x.

You should read both files simultaneously line-by-line and insert the data into the table with a single insert per line. INSERT INTO table_name (linefrompart1, linefrompart2) VALUES ('lili', 'like eating apple') Alternatively if this is not possible then you could add an extra column to your table to store the line number and use an update statement with 'WHERE linenumber = x'.

Hallo Mark. I took the alternative solution and it works well. Thank you very much!

– TianDong Jul 15 '10 at 23:35 You are welcome! – Mark Byers Jul 15 '10 at 23:47.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.