Insert default value while creating Table in android sqlite

Question

I would like to know how to insert a default value to a table when it's created using Android Sqlite.

which data type you want to insert?

Giru Bhai
– Giru Bhai

2014-05-26 07:00:44 +00:00
Commented May 26, 2014 at 7:00 — Giru Bhai
– Giru Bhai, Commented May 26, 2014 at 7:00
TEXT datatype. I need it when creating the table

user3506595
– user3506595

2014-05-26 07:02:54 +00:00
Commented May 26, 2014 at 7:02 — user3506595
– user3506595, Commented May 26, 2014 at 7:02

Giru Bhai · Accepted Answer · 2014-05-26 07:11:27Z

2

try this,it uses both text and integer type
replace MyTableName with yourtable

 @Override
            public void onCreate(SQLiteDatabase paramSQLiteDatabase) { // sqlite oncreate method
        paramSQLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS MyTableName(_id INTEGER DEFAULT 0,name TEXT DEFAULT 'ram');");
        }

edited May 26, 2014 at 7:11

answered May 26, 2014 at 7:04

Giru Bhai

14.4k5 gold badges50 silver badges74 bronze badges

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

2 Comments

Giru Bhai Over a year ago

Which error you got?I tested this command on Sqlite browser and its working

deadfish Over a year ago

it's not working because probably you've already created this database, try uninstall app/clear app and try again

Collectives™ on Stack Overflow

Insert default value while creating Table in android sqlite

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related