swdev:sqlite:start [Audina Documentation]

This is an old revision of the document!

SQLite

Download

Create Database

Create a database schema using a file:

$ sqlite3 mydatabase.db < db.schema

Or create schema manually (and then enter SQL commands at the prompt to create and populate the new tables):

$ sqlite3 mydatabase.db
sqlite> create table greetings(one varchar(10), two smallint);
sqlite> insert into greetings values('hello!',10);
sqlite> insert into greetings values('goodbye', 20);
sqlite> select * from greeting;

Or create table interactively:

sqlite> CREATE TABLE tbl2 (
   ...>   f1 varchar(30) primary key,
   ...>   f2 text,
   ...>   f3 real
   ...> );
sqlite>

References

CLI: http://sqlite.org/cli.html