Script started on 2019-10-15 15:13:11-0400
pi:~/public_html> sqlite3 w3.sqlite

SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite> INSERT INTO Persons VALUES (4,'Nilsen','Johan','Bakken 2','Stavenger');
sqlite> select * from Persons;
1|Hansen|Ola|Timoteivn 10|Sandnes
2|Svendson|Tove|Borgvn 23|Sandnes
3|Pettersen|Kari|Storgt 20|Stavanger
4|Nilsen|Johan|Bakken 2|Stavenger
sqlite> insert into Persons (P_Id,LastName,FirstName) values (5,'Tjessem','Jakob');
Error: NOT NULL constraint failed: Persons.Address
sqlite> .read input2.txt
sqlite> select * from Persons;
P_id        LastName    FirstName   Address       City      
----------  ----------  ----------  ------------  ----------
1           Hansen      Ola         Timoteivn 10  Sandnes   
2           Svendson    Tove        Borgvn 23     Sandnes   
3           Pettersen   Kari        Storgt 20     Stavanger 
sqlite> insert into Persons (P_Id,LastName,FirstName) values (5,'Tjessem','Jakob');
sqlite> select * from Persons;
P_id        LastName    FirstName   Address       City      
----------  ----------  ----------  ------------  ----------
1           Hansen      Ola         Timoteivn 10  Sandnes   
2           Svendson    Tove        Borgvn 23     Sandnes   
3           Pettersen   Kari        Storgt 20     Stavanger 
5           Tjessem     Jakob                               
sqlite> .quit
pi:~/public_html> exit

exit

Script done on 2019-10-15 15:16:35-0400