setting a default value to a column in SQLite

Question

I am having an SQLite table and wish to set it with a default value for time being. how can I do that?

Below is my DatabaseHelper class code:

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME="iFall.db";
    public static final String TIME="time";
    //public static final String STATUS="status";
    //public static final String MINES="loadmines";
    //public static final String OPENTILE="openTile";

    public DatabaseHelper(Context context)
    {
        super(context,DATABASE_NAME,null,1);
    }
    @Override
    public void onCreate(SQLiteDatabase arg0) {
        // TODO Auto-generated method stub
        //CREATE TABLE minesweeper(_id INTEGER PRIMARY KEY AUTOINCREMENT,userId TEXT
        arg0.execSQL("CREATE TABLE finalP(_id INTEGER PRIMARY KEY AUTOINCREMENT,time TEXT);");

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL("DROP TABLE IF EXISTS finalP");
        onCreate(db);
    }

}

I want to assign a default value say 50 to the column time.

Feel free to accept an answer if it was helpful.

Maximus
– Maximus

2011-05-11 17:52:12 +00:00
Commented May 11, 2011 at 17:52 — Maximus
– Maximus, Commented May 11, 2011 at 17:52

Maximus · Accepted Answer · 2011-05-10 19:56:50Z

17

I believe you can do this:

arg0.execSQL("CREATE TABLE finalP(_id INTEGER PRIMARY KEY AUTOINCREMENT,time TEXT DEFAULT \'50\');");

and it should work fine.

See the sqlite docs for column constraints. http://www.sqlite.org/syntaxdiagrams.html#column-constraint

answered May 10, 2011 at 19:56

Maximus

8,4314 gold badges31 silver badges37 bronze badges

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

Comments

hamid · Accepted Answer · 2020-12-20 19:30:54Z

0

create table permission ( code boolean default 'false' ); it's for boolean type but you can use it for example for TEXT type

answered Dec 20, 2020 at 19:30

hamid

896 bronze badges

1 Comment

YLR Over a year ago

Add more detail in your answer and/or add link to official doc.

Collectives™ on Stack Overflow

setting a default value to a column in SQLite

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related