How to create and open SQLite table in Android?

Question

db = openOrCreateDatabase("tompomodoros.db", Context.MODE_PRIVATE, null);
db.execSQL("CREATE TABLE mytable (_id INTEGER PRIMARY KEY AUTOINCREMENT, mydate VARCHAR, mydata SMALLINT)");

I use above code to create db and its table "mytable". But for the second time I run it, the phone goes to dead. I guess that is because I create the table again but it already exists there. So my question is how to create the table for the first time and open it for the rest times?

The simplest way it to use the SQLiteOpenHelper which does all the version checking for you vogella.com/articles/AndroidSQLite/… — zapl
– zapl, Commented Nov 20, 2012 at 10:00

Michał Powaga · Accepted Answer · 2012-11-20 09:38:04Z

3

Try with if not exists:

db.execSQL("CREATE TABLE if not exists mytable (_id INTEGER PRIMARY KEY AUTOINCREMENT, mydate VARCHAR, mydata SMALLINT)");

and then us it as usual.

answered Nov 20, 2012 at 9:38

Michał Powaga

23.4k8 gold badges55 silver badges62 bronze badges

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

Comments

Nermeen · Accepted Answer · 2012-11-20 09:37:09Z

1

First check if the table exists, use the following:

Cursor cursor = db.rawQuery("SELECT DISTINCT tbl_name FROM sqlite_master WHERE tbl_name = 'mytable'", null);
if(cursor == null || cursor.getCount() == 0) { //table does not exist
        //create the Db attachments table
        db.execSQL("CREATE TABLE mytable (_id INTEGER PRIMARY KEY AUTOINCREMENT, mydate VARCHAR, mydata SMALLINT)");
}
cursor.close();

answered Nov 20, 2012 at 9:37

Nermeen

16k5 gold badges62 silver badges73 bronze badges

Collectives™ on Stack Overflow

How to create and open SQLite table in Android?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related