Set default value of an integer column SQLite

Question

I am creating an SQLite database in android    db execSQL  CREATE TABLE     DATABASE TABLE               KEY ROWID     INTEGER PRIMARY KEY AUTOINCREMENT          KEY NAME     TEXT NOT NULL           KEY WORKED     INTEGER          KEY NOTE     INTEGER        Is it possible to set the default value of KEY NOTE  which is an integer  for every row created to be 0  zero   If so  what should be the correct code

User · Answer

A column with default value   CREATE TABLE  lt TableName gt        lt ColumnName gt   lt Type gt  DEFAULT  lt DefaultValue gt           lt DefaultValue gt  is a placeholder for a    value literal   expression     Examples   Count INTEGER DEFAULT 0  LastSeen TEXT DEFAULT  datetime  now

User · Answer

It happens that I m just starting to learn coding and I needed something similar as you have just asked in SQLite  I  m using  SQLiteStudio   3 1 1     It happens that you must define the column s  Constraint  as  Not Null  then entering your desired definition using  Default   Constraint  or it will not work  I don t know if this is an SQLite or the program requirment    Here is the code I used   CREATE TABLE  lt MY TABLE gt     lt MY TABLE KEY gt        INTEGER    UNIQUE                                 PRIMARY KEY   lt MY TABLE SERIAL gt     TEXT       DEFAULT   lt MY VALUE gt                                    NOT NULL  lt THE REST COLUMNS gt

User · Answer

Use the SQLite keyword default  db execSQL  CREATE TABLE     DATABASE TABLE               KEY ROWID     INTEGER PRIMARY KEY AUTOINCREMENT          KEY NAME     TEXT NOT NULL          KEY WORKED     INTEGER          KEY NOTE     INTEGER DEFAULT 0        This link is useful  http   www sqlite org lang createtable html

[android] Set default value of an integer column SQLite

Examples related to android

Examples related to database

Examples related to sqlite

Examples related to android-sqlite