Table of Contents
If you want to send us your comments, please do so. Thanks
More on comments
sqlite
Useful tool to look into a database: sqlitebrowser
Commands
Remark: DOT commands do not need a semicolon at the end. Ohter commands do
| Command | Explanation | Remark |
|---|---|---|
| sqlite3 | Start sqlite | You get a prompt: sqlite> |
| .exit | Go back to bash | |
| .help | Show all commands | |
| .open local.sqlite | Open database local.sqlite | |
| .database | Show open databases | |
| .tables | Show tables | |
| .schema tablemame | Show the structur of the table named tablename | |
| .indexes | Show indexes of all tables | |
| pragma quick_check; | Check the database quick | |
| pragma integrity_check; | Check the database thorough | |
| Selection commands | ||
| select title from cal_todos |
Install sqlite-autoconf-3080500.tar.gz
3080500 is the version number
Download from:
http://www.sqlite.org/download.html#docco
untar with
tar -xf sqlite-autoconf-3080500.tar.gz
Do in its your own home folder as normal user:
CFLAGS="-Os" ./configure CFLAGS="-Os" avoids the compilation of debug info.\\
The file will become smaller.
Do in your own home folder as normal user:
make
Do in your own home folder as normal user:
make check
Do as root:
make install
Do as root
make installcheck
Do in your own home folder as normal user:
make clean make distclean
Useful links
SQlite on the commandline
Main subjects on this wiki: Linux, Debian, HTML, Microcontrollers, Privacy
RSS
Disclaimer
Privacy statement
Bugs statement
Cookies
Copyright © : 2014 - 2026 Webevaluation.nl and the authors
Changes reserved.