Android SQLite Database Update?

If you really do mean rows then as antlersoft points out, using the SQL INSERT INTO statement will simply add a new row to a table without affecting any existing table data. This is one of the most basic and commonly used SQL statements. If you actually mean you need to add columns then use the SQL ALTER TABLE statement.

See.. SQL INSERT INTO statement SQL ALTER TABLE statement.

Thanks for the feedback. And you were right, I wanted to insert an additional column I believe. – user1132897 Jan 5 at 21:11 I figured as much.

Just think of it that columns can hold up the roof of a building and you'll remember which is which. You can pretty much do anything with a DB without having to destroy the existing data. Keep that site bookmarked it's pretty good as a quick reference.

– MisterSquonk Jan 5 at 21:18.

The Android framework, as it relates to SQLite (using a SQLiteOpenHelper) provides two distinct methods for handling database lifecycles - onCreate(), used when the database needs to be created from scratch, and onUpgrade(, int oldVersion, int newVersion) for handling updates. You can specify the "new" version number in the constructor for the superclass of your SQLiteOpenHelper, and the framework knows to call onUpgrade() based on this parameter and the internal version # in the actual sqlite database. So, to modify your database during a version change just override onUpgrade() and run whatever SQLite stuff that you need.

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.