SQLITE commands

 Create a database with the name rahultest

rahul@rahul-Inspiron-3542:~$ sqlite3 rahultest.db
SQLite version 3.8.11.1 2015-07-29 20:00:57
Enter ".help" for usage hints.








=========================================


Show the databases




sqlite> .databases
seq  name             file                                                    
---  ---------------  ----------------------------------------------------------
0    main             /home/rahul/rahultest.db                                
sqlite>
sqlite>



=======================================

Commit rollback and release



creating a save point



sqlite> savepoint starter;
sqlite>
sqlite> create table test (int );
sqlite> .tables
test
sqlite>
sqlite> rollback to savepoint starter;
sqlite> .tables
sqlite> create table test (int );
sqlite> .tables
test
sqlite> release savepoint starter;
sqlite> .tables
test
sqlite>.quit



Taking backup

.output filename.sql
.dump tablename
.quit