Insert a Row

 
INSERT INTO person (
  firstname,
  lastname,
  gender,
  age,
  active_flag
 )
 VALUES (
  'Jane',
  'Austin',
  'F',
  41,
  'Y'
);

Notes:

  • You do not need to enter a primary key value if the primary key is an integer. The system will do this for you.
  • You are only required to enter data for columns that are NOT NULL. (in SQLite NULL is a data type)

Schema and Data use on this page