====== Sqlite ======

= Using SQLite =

 #Open SQLite database
 sqlite databasefile
 
 #List tables
 .tables
 
 #Desc tables
 .schema users
 
 #Select
 select * from users;
 
 #Update table
 update users set email="test@test.com" where email="wrongemail@test.com";
 
 #Delete row
 delete from users where user_id=5;
 
 #To exit
 CTRL+d

Refs:
http://www.pantz.org/software/sqlite/sqlite_commands_and_general_usage.html <br>
http://sqlite.awardspace.info/syntax/sqlitepg01.htm