Linux SQLite Installation

I. Software Packages
A) sqlite-autoconf-3070400.tar.gz

Ii. Installation Steps

A) tar zxvf sqlite-autoconf-3070400.tar.gz

B) cd sqlite-autoconf-3070400

C)./configure -- prefix =/usr/local/sqlite

D) Make

E) Make install

Iii. SQLite3 commands

A)/usr/local/sqlite/bin/Sqlite3 user. db create a database

B) view help

SQLite version 3.3.6

Enter ". help" for instructions

Sqlite & gt;. databases

Seq name file

----------------------------------------------------------------------------

0 main/usr/local/sqlite/bin/userdb

Sqlite & gt;. help

. Databases List names and files of attached databases

. Dump? TABLE? ... Dump the database in an SQL text format

. Echo ON | OFF Turn command echo on or off

. Exit Exit this program

. Explain ON | OFF Turn output mode suitable for EXPLAIN on or off.

. Header (s) ON | OFF Turn display of headers on or off

. Help Show this message

. Import file table Import data from FILE into TABLE

. Indices TABLE Show names of all indices on TABLE

. Mode MODE? TABLE? Set output mode where MODE is one:

Csv Comma-separated values

Column Left-aligned columns. (See. width)

Html HTML <table> code

Insert SQL insert statements for TABLE

Line One value per line

List Values delimited by. separator string

Tabs Tab-separated values

Tcl TCL list elements

. Nullvalue STRING Print STRING in place of NULL values

. Output FILENAME Send output to FILENAME

. Output stdout Send output to the screen

. Prompt main continue Replace the standard prompts

. Quit Exit this program

. Read FILENAME Execute SQL in FILENAME

. Schema? TABLE? Show the CREATE statements

. Separator STRING Change separator used by output mode and. import

. Show Show show the current values for various settings

. Tables? PATTERN? List names of tables matching a LIKE pattern

. Timeout MS Try opening locked tables for MS milliseconds

. Width NUM... Set column widths for "column" mode

Sqlite & gt; select * from students;

Name | age | sex | id

Sadgsd | 1 | 2 | 1

Sadgsd | 1 | 2 | 2

Sadgsd | 1 | 2 | 3

Sdagds | 2 | 1 | 4

Sdagdsg | 12 | 1 | 6

Sdagdsg | 12 | 1 | 7

Sdagdsg | 12 | 1 | 9

Sdagdsg | 12 | 1 | 16

Sqlite & gt;. dump & gt;/opt/a. SQL export data

C) sqlite & gt;. quit exit

D) All internal commands of sqlite are not added at the end; No. Must be added for SQL statements; No.

E) when data is inserted in the sqlite database, an error is reported because the sqlite database file has no permission to write. You can modify the File Permission.