SQLite command examples:

# To create a new table
$ sqlite ex1
SQLite version 2.0.0
Enter ".help" for instructions
sqlite> CREATE TABLE tbl4 ( f1 varchar(30) primary key, f2 text, f3 real );

$ sqlite ex1
SQLite version 2.0.0
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> insert into tbl1 values('hello!',10);
sqlite> insert into tbl1 values('goodbye', 20);
sqlite> select * from tbl1;
hello!|10
goodbye|20
sqlite>