Skip to main content

Posts

Showing posts from February, 2016

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 bac