sqlite quickstart

prefer sqlite3, not sqlite2 or sqlite

$ sqlite3 --help

batch script like so..

$ sqlite3 -header {database}.db '.schema'
$ sqlite3 settings.db delete from system where name like 'lock%'

.. or interactive

$ sqlite3 {database}.db
sqlite> .show
sqlite> .headers on
sqlite> .databases
sqlite> .tables
sqlite> .tables t%
sqlite> .schema {table}
sqlite> select * from test;
sqlite> update {table} set {column1}=99 where {column2}='red';
sqlite> .exit

No comments:

Post a Comment

most popular posts