SQLite Tutorial: Common Commands and Triggers LG #109

http://linuxgazette.net/109/chirico1.html

Excellent resource to get started in sqlite.
sqliteman is an excellent GUI to test queries as well.

Being able to type sql queries on linux cmdline is very helpful in a
lot of situations e.g.

$ sqlite3 test.db "create table t1 (t1key INTEGER
PRIMARY KEY,data TEXT,num double,timeEnter DATE);"

keeping queries saved in txt files is helpful for me to log my methods
for generating data and you can pipe the sql files into the sqlite3
binary as well.

well you can do the same im mysql but u need to mess with usernames
and passwords and privileges.