Android database insert into specific row

Question

I have a database and i can insert into it and read from it fine, but this is my issue:

first of all i have two tables, table1 and table2. Both tables only have 1 column and 1 row. So i didn't set my Key to autoincrement. Basically i want to keep overwriiting that value in the row and column instead of adding many values how do i do this?

private static final String DATABASE_CREATE_DATA = "create table table1 (_id integer primary key, " + "table1 text);";
private static final String DATABASE_CREATE_WIFI = "create table table2 (_id integer primary key, " + "table2 text);";

and my insert is:

db.insertOrThrow(DATABASE_TABLE1, null, value);

But for some reason this increments the key and adds many values where i just want to keep overwriting the first value.

Medo42 · Accepted Answer · 2011-08-27 20:32:34Z

1

Generally with SQL, you use UPDATE to change data in rows, and INSERT to create new ones. I never worked with SQLite, but I'd be surprised if there wasn't an update function beside that insert one.

Edit: Looking at the docs, replaceOrThrow might be just what you're looking for.

answered Aug 27, 2011 at 20:32

Medo42

3,8411 gold badge23 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jack · Accepted Answer · 2011-08-27 20:32:54Z

0

You would need to either do a rawQuery using a WHERE clause, or use db.update, see this post for reference.

answered Aug 27, 2011 at 20:32

Jack

9,2524 gold badges52 silver badges75 bronze badges

Comments

Ivan Nikolchov · Accepted Answer · 2011-08-27 20:34:27Z

0

What you actually want to do is an update .

answered Aug 27, 2011 at 20:34

Ivan Nikolchov

1,5941 gold badge28 silver badges42 bronze badges

Collectives™ on Stack Overflow

Android database insert into specific row

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related