Install SQLite3 from Source
$ wget https://www.sqlite.org/src/tarball/sqlite.tar.gz
$ tar xzf sqlite.tar.gz # Unpack the source tree into "sqlite"
$ mkdir bld # Build will occur in a sibling directory
$ cd bld # Change to the build directory
$ ../sqlite/configure # Run the configure script
$ make # Run the makefile.
$ make sqlite3.c # Build the "amalgamation" source file
$ make test # Run some tests (requires Tcl)
$ whereis sqlite3
sqlite3: /usr/bin/sqlite3 /usr/include/sqlite3.h /usr/share/man/man1/sqlite3.1.gz
$ sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
$ sqlite3
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
Ref :- sqlite.org sqlite.org/cli.html
$ wget https://www.sqlite.org/src/tarball/sqlite.tar.gz
$ tar xzf sqlite.tar.gz # Unpack the source tree into "sqlite"
$ mkdir bld # Build will occur in a sibling directory
$ cd bld # Change to the build directory
$ ../sqlite/configure # Run the configure script
$ make # Run the makefile.
$ make sqlite3.c # Build the "amalgamation" source file
$ make test # Run some tests (requires Tcl)
$ whereis sqlite3
sqlite3: /usr/bin/sqlite3 /usr/include/sqlite3.h /usr/share/man/man1/sqlite3.1.gz
$ sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
$ sqlite3
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
[...]
sqlite> .show
[...]
sqlite> .database
[...]
sqlite> .table
[...]
sqlite> .quit
Ref :- sqlite.org sqlite.org/cli.html
No comments:
Post a Comment