Windows SQLite Installation

Install/Run SQLite:
   1. Download SQLite: To download SQLite visit this page : http://www.sqlite.org/download.html
   2. Unpack SQLite
   3. Install SQLite: Now double click on the sqlite.exe file to install SQLite.
   4. Test SQLite:T o test SQLite open up a command prompt window and type 'sqlite3'. To get some help with SQLite type '.help' and to close sqlite3 type '.quit'
 
Create a Test SQLite Database:
    1.  Create SQLite Test Database :
        sqlite3 sqlite.db
       
    2. Create a SQLite Table :
        sqlite3 sqlite.db "create table tb1 (tb1key INTEGER PRIMARY KEY,data TEXT,num double,timeEnter DATE);"

    3. Add Data Into Test Database :
        sqlite3 sqlite.db "insert into tb1 (data,num) values ('Test data',9);"
        sqlite3 sqlite.db "insert into tb1 (data,num) values ('More test data',8);"
        sqlite3 sqlite.db "insert into tb1 (data,num) values ('Third set of data',7);"
       
    4. View Test SQLite Data :
        sqlite3 sqlite.db "select * from tb1";


You may find a GUI Tool to control database
    1. sqlitestudio.2.1.5
    2. sqlitebrowser-3.3.1-win32
    3. sqliteadmin