How to insert data into two tables at once using SQLiteDatabase in Android?

Question

So lets say I have this code:

SQLiteDatabase sqlDB = database.getWritableDatabase();
long iD = 0;
iD = sqlDB.insert(Table1, null, TestV);

Can I somehow rewrite this to insert into two tables instead of one? My problem is that 'values' returns 3 values from one table, and 1 value from another. Therefore, the 1 value that isn't in 'Table1' sets off an error that the column cant be found in 'Table1.' Is there a way to do this? If not then should I do two separate inserts? I am confused as how to insert data into two tables in one database (Tables are Relational: one has a foreign key).

MowDownJoe · Accepted Answer · 2013-05-01 23:09:54Z

7

From the documentation for INSERT in SQLite:

enter image description here

Note that the flowchart doesn't give you an opportunity to post into more than one table at once. SQLiteDatabase.insert() is a convenience method for using the INSERT statement.

answered May 1, 2013 at 23:09

MowDownJoe

7881 gold badge11 silver badges29 bronze badges

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

1 Comment

john Over a year ago

I have seen this diagram before. I simply curious if there is a way around it, and if not any options.

JulianHarty · Accepted Answer · 2017-02-21 15:48:03Z

5

You can simulate this using database transaction:

    SQLiteDatabase db = getWritableDatabase();

    db.beginTransaction();

    try {

        db.execSQL("insert into table1...");
        db.execSQL("insert into table2...");

        db.setTransactionSuccessful();
    } finally {
        db.endTransaction();
    }

You may need to choose the order of the inserts if there are dependencies between the values inserted, for instance if there's a foreign key relationship: ( insert to table1 and then table2, or first insert to table2...)

edited Feb 21, 2017 at 15:48

JulianHarty

3,3365 gold badges36 silver badges48 bronze badges

answered May 1, 2013 at 23:58

m.ghoreshi

8626 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to insert data into two tables at once using SQLiteDatabase in Android?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related