Insert a Row
INSERT INTO person ( firstname, lastname, gender, age, active_flag ) VALUES ( 'Jane', 'Austin', 'F', 41, 'Y' );
- 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)