Powered by emcons.net

SQLite

From How2s

Example how to create a new SQLite database:

sqlite3 filename.sqlite

Example how to create a table:

sqlite> create table
  ...> dictionary
  ...> (key INTEGER PRIMARY KEY, 
  ...> word TEXT,
  ...> num double,
  ...> timeEnter DATE);

Example how to import data

read ./example.txt

Where the contents of example.txt is

INSERT INTO dictionary (key, word, num, timeEnter) VALUES ('1', 'foo', '2', DATETIME('NOW'));