Набери в конце / и нажми enter

D:\123\>sqlite3 a.db
SQLite version 3.8.5 2014-06-04 14:06:34
Enter ".help" for usage hints.
sqlite> BEGIN TRANSACTION;
sqlite> CREATE TABLE Actors(AId integer primary key autoincrement, Name text);
sqlite> INSERT INTO Actors VALUES(1,'Philip Seymour Hofman');
sqlite> INSERT INTO Actors VALUES(2,'Kate Shindle');
sqlite> INSERT INTO Actors VALUES(3,'Kelci Stephenson');
sqlite> INSERT INTO Actors VALUES(4,'Al Pacino');
sqlite> INSERT INTO Actors VALUES(5,'Gabrielle Anwar');
sqlite> INSERT INTO Actors VALUES(6,'Patricia Arquette');
sqlite> INSERT INTO Actors VALUES(7,'Gabriel Byrne');
sqlite> INSERT INTO Actors VALUES(8,'Max von Sydow');
sqlite> INSERT INTO Actors VALUES(9,'Ellen Burstyn');
sqlite> INSERT INTO Actors VALUES(10,'Jason Miller');
sqlite> COMMIT;
sqlite> /
sqlite> select * from actors;
1|Philip Seymour Hofman
2|Kate Shindle
3|Kelci Stephenson
4|Al Pacino
5|Gabrielle Anwar
6|Patricia Arquette
7|Gabriel Byrne
8|Max von Sydow
9|Ellen Burstyn
10|Jason Miller
sqlite>

MetalHeaderВозник вопрос, как работает автоинкремент в SQLite? Обязательно всегда заполнять значение поля id?

не обязательно - на то он и auto :)

sqlite> CREATE TABLE Actors(AId integer primary key autoincrement, Name text);
sqlite> INSERT INTO Actors VALUES(1,'Philip Seymour Hofman');
sqlite> INSERT INTO Actors VALUES(2,'Kate Shindle');
sqlite> INSERT INTO Actors(name) VALUES('Jason Miller');
sqlite> select * from Actors;
1|Philip Seymour Hofman
2|Kate Shindle
3|Jason Miller