swdev:sqlite:start [Audina Documentation]

This is an old revision of the document!

SQLite

Download

Create Database

Method 1: Create a database schema using a file:

$ sqlite3 mydatabase.db < db.schema

Method 2: 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;

$ sqlite3 mydatabase.db
sqlite> CREATE TABLE product (
   ...>   id int(11) primary key,
   ...>   name varchar(30)
   ....>  description text,
   ...>   price real
   ...> );
sqlite>

Method 3: Create table by importing CSV file:

$ sqlite3 mydatabase.db
sqlite> .mode csv
sqlite> .import C:/work/somedata.csv tab1

References

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